Before you copy your data, ensure that any spreadsheet columns containing location data have the correct header names.

To streamline uploading your data, we recommend using the following column headers:

• Address
• City
• State
• Zip Code (or Postal Code)
• County
• Country
• Latitude & Longitude (both should be in the same cell)

Once you have the correct column headers, you’re all set!

Select all the data in your spreadsheet, including the column headers.

Here’s the quickets way to do this:

• Click the first column header in your spreadsheet.
• Use CTRL + Shift + Down Arrow to select all cells in that column.
• Still holding down CTRL + Shift, use the Left Arrow to select all cells in the adjacent columns.
• Use CTRL + V to paste the spreadsheet data into Mapline.

It’s important to copy only the data you need instead of using CTRL + A to copy blank cells from your spreadsheet.

Confirm that Mapline has correctly identified all of your address columns. If one is incorrect, click the drop-down menu to select the correct column header.

You only need to worry about the data that actually exists in your spreadsheet. For example, if your spreadsheet doesn’t include latitude and longitude information, then just leave Mapline’s drop-down selection at None.

You can do so much with your data now that it’s in Mapline!

Here are some of the top ways businesses use their datasets:

• Add locations to a map
• Compare competitor locations with Dynamic Data
• Create optimized, one-time routes
• Automate daily routes
• Generate charts, reports, or dashboards

What’s next? The possibilities are endless!