X

How can I create an interactive map with a spreadsheet import?

  • Created : Jun, 03, 2019
  • Last Updated: Dec, 18, 2019

This documentation is always evolving.

You have a list of locations and you need to get all of them quickly on a map? No problem! You can import spreadsheets (CSV or XLSX format) or text files that contain location information such as latitude and longitude or address lines which consist of street names, numbers, ZIP codes or city names. To add interactivities to them, you can even include text or rich media links in separate columns and reference to them with the upcoming steps. Here is an example of what an Excel spreadsheet can be built of:

To import this file, simply drag it from your PC’s location onto the mapping canvas. When latitude and longitude are included, the system recognizes these cells and will place the icons automatically for you. Of course, if you need to make changes to the icon’s location, you can either move them manually, fill in the icon’s address popup or change the lat/long info inside of the table. You can open the inline spreadsheet by going to the elements list, click on the file name and make changes to the required columns. You can also define the styling of the imported icons. Apply to all will change all the icons of the imported file at once.

If no lat/long info is available, you can specify different columns to indicate the address. This can look as follows:

Finally, to include the interactivity, click on one of the icons, toggle the “Apply to Group” and go to the interactivity tab of the icon popup. Here you can insert references from the spreadsheet by opening the drop-down menu or by choosing one of the suggestions after writing the $-sign.

To preview an example, click on the Preview button or go directly to the export menu to output the iframe and link.

See Mapcreator in action