1. INSTALL ADD-IN
If you have not already done so, download and install the Mapline Excel Add-in.
2. OPEN YOUR EXCEL SPREADSHEET
Open the Excel spreadsheet that contains your data, and click on the “Mapline” tab in the ribbon at the top.
1. CLICK “UPLOAD”
After clicking the “Mapline” tab in the ribbon, click the “Upload” button.
2. SELECT DATA
After clicking “Upload,” a box will open that allows you to select the range of data you want to upload to Mapline. Be sure to include the column headers of your data such as “Name,” “Address,” “Sales Volume,” etc. Mapline will use these to identify what data is contained in each column. If the correct cells are highlighted, click “OK.” Otherwise, click and drag to select the data you want to upload, then click “OK.”
3. NAME YOUR DATASET
In the box that opens, input a name for your dataset.
4. ADD YOUR DATASET TO A MAP
Underneath the name field, select whether you want to add this dataset to a new map, or to an existing map. If adding it to a new map, click the circle next to “New Map,” and give that map a name. Otherwise, click “Existing Map,” and select the map you want to add the dataset to. Click “Continue.”
5. GO TO YOUR MAP
Your dataset has now been added to a map in Mapline. Click the “Go to Map” button to view the map now.
1. CLICK “REPLACE”
After clicking the “Mapline” tab in the ribbon, click the “Replace” button.
2. SELECT DATA
After clicking “Replace,” a box will open that allows you to select the range of data you want to upload to Mapline. Be sure to include the column headers of your data such as “Name,” “Address,” “Sales Volume,” etc. Mapline will use these to identify what data is contained in each column. If the correct cells are highlighted, click “OK.” Otherwise, click and drag to select the data you want to upload, then click “OK.”
3. SELECT A DATASET
Select the dataset that you want to replace, then click “Continue.”
4. OPEN MAPLINE
Your dataset has now been successfully replaced. Open your Mapline account to view the replaced dataset.
1. CLICK “DOWNLOAD”
After clicking the “Mapline” tab in the ribbon, click the “Download” button.
2. SELECT A DATASET
Select the dataset that you want to download, then click “Continue.”
3. CHOOSE THE LOCATION TO DOWNLOAD DATASET
Choose where you would like to put the downloaded dataset. If you would like to keep it in the same worksheet, click on the cell you want to put the data in, then click “OK.” If you would like to put the dataset in a new worksheet, click the circle next to “New worksheet,” then click “OK.”
4. CLICK “OK”
The dataset has now been downloaded to your Excel workbook. Click “OK” to close the message box.
1. CLICK “MAPS”
After clicking the “Mapline” tab in the ribbon, click the “Maps” button.
2. SELECT A MAP
Select the map that you want to open, then click “Go to Map.” This will open your map in an internet browser window.
1. MAPLINE BUTTON
After clicking the “Mapline” tab in the ribbon, click the “Mapline” button in the top left corner of the screen. This will bring you to the Mapline homepage. From here, you can log in to your account and access your maps and datasets.
2. LOGOUT BUTTON
After clicking the “Mapline” tab in the ribbon, click the “Logout” button at the top of the screen to log out of your Mapline account within Excel.
3. HELP BUTTON
After clicking the “Mapline” tab in the ribbon, click the “Help” button at the top of the screen. This will open an article to help you use Mapline’s Excel Add-in.
