Help center

Preparing your file to be imported

Feature available for all plans: Free – Up to 100 pins | Essential – Up to 1,000 pins | Pro – Up to 10,000 pins | Advanced – Up to 100,000 pins

3 key elements for a successful data import 🚀

1. Accepted file format

Excel file only

2. Required information in your Excel

The only required information is the address of the locations you want to import.
This can be in a single column or spread across multiple columns in your file.

Your Excel file can include as many columns and details as needed.

3. Supported and recommended address formats

Note: The more precise your address is, the more accurately your data will be geolocated on the map.
Here are the two formats that ensure optimal geolocation:

  • Full and clean address with country
    Example: 1835 Piedmont avenue NE Atlanta Georgia 30324 Unites States
  • Latitude, longitude
    Example: 43.611822539119885, 1.4297573402798625

Partial addresses are also accepted (In this case, the pin will be placed at the centroid of the selected postal code or city):

  • Zip code and country
    Example: 30324, United States
  • City and country
    Example: Atlanta United States

If your file doesn’t include the country, no worries — our smart assistant will help you choose the country where you want to import your data!

Here is an example of a format that could be imported:

Once the file is ready, you can click on “My data” on the right-hand panel, then “Add your data”.


Common mistakes to avoid

When imported data is geolocated incorrectly, its usually due to one of these 4 common issues:

  • A city name that exists in multiple countries: If you don’t specify the country, the pin may be placed in the wrong location.
  • Unnecessary elements: Commas, punctuation, address extras (building, floor, ZAC, ZI…), or line breaks can confuse the geocoding.
  • Missing spaces between words can prevent proper recognition when your address is in a single cell
  • Abbreviated districts in large cities

To go further:

Updated on April 10, 2025