What does my spreadsheet need to look like so I can import it?

In this article, you will learn how to create a list to get all locations quickly on a map.

This documentation is always evolving.

You have a list of locations and you need to get all of them quickly on a map? With Mapcreator that’s no problem at all! There are a few things you need to take into consideration to make the import process smooth and efficient. Let’s have a look at them together.

The most important information is the address information. If you import latitudes and longitudes, make sure they are separated in one column each. For address lines, which can consist of street names, numbers, ZIP codes or city names, keep in mind that the more information you provide, the more detailed the tool will be able to pinpoint a marker. You may also import a file that contains city names only. It can be that the tool does not place the marker where you intend it to, since a city name probably exists several times in this world.

These are the location saving options visually explained:

Location saving options visually explained _ spreadsheet look

Mapcreator supports file imports with up to 1.000 location entries.

Import icon names

There are additional ways that make the files import process easy and allow you to link information almost automatically. For instance, did you know you can store an icon’s name so the tool will place the corresponding icon right away? To make this happen, let’s go find the icon name in the tool. You can either obtain it via hovering over an icon, or you copy and paste the icon name in the styling menu.

Import icon names _ Spreadsheet look

In your spreadsheet, you’ll have to add a column header ‘icon’ and store the icon name in the cells underneath. There is no limit how many icon names can be stored, as long as they’re unique the tool will load the correct one immediately.

At this point, your spreadsheet may look as follows:

Spreadsheet may look like this _ Spreadsheet look

Pro tip: If you look to import numbers on icons, make sure you have the ‘Mapcreator Numbering’ icon set in your account. Contact our support team if you don’t find it in your tool.


Import labels

Additionally, we can load labels via the import as well. To make this happen, add a column header ‘text’, ‘label’, ‘name’, ‘location name’ or ‘tekst’. Store any label you’d like to attach to a marker in there, and the tool will place it as a label with the marker.

Pro tip: You can style the associated markers and make them transparent. That way you’ll only have labels without markers.

Next to facilitating the editing work in the tool, you can also add interactivities to the markers you’re importing. We’re covering everything you need to know about the how-to here.

Import colors

Icons or textbox elements that consist of one main color field, can get a certain color automatically assigned via the import file. The color header for these needs to be ‘iconcolor’, ‘iconcolour’, ‘icon color’, ‘icon color’, ‘iconcolors’, ‘iconcolours’, ‘icon colors’, ‘icon colours’.
You can also set it hindsight, using the table management menu. The supported colors are RGB and hexadecimal.

Examples: RGB(255,92,92), RGBa(255,92,92,1), (#ff5c5c).