Orange question mark icon that reads Quick Reference Guide
DATASETS:
ADD NEW
DATASETS:
ADD NEW

Adding a new dataset into Mapline is as easy as Copy, Paste, Done!

But here are some quick tips that’ll make the process even smoother for you.

PROOF YOUR SPREADSHEET

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!

Screenshot of an excel spreadsheet with store locations

ADD NEW DATASET

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.

IDENTIFY ADDRESS COLUMNS

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.

Screenshot of the Identify Address Columns lightbox in Mapline

USE YOUR DATASET

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:

What’s next? The possibilities are endless!

screenshot of a route on a grayscale map