How do I import a spreadsheet?
- Created : Jun, 03, 2019
- Last Updated: Jan, 03, 2020
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! With Mapcreator 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. Here is an example of what a 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.
If no lat/long info are available, you can specify different columns to indicate the address. This can look as follows:
Finally, to style your icons, click on one of the icons from the map, toggle the “Apply to Group”, this will make changes to all of the icons that you have imported from your file. Right above, you will find various options for styling your icons. These include: rotation, scale, color and the ability to change the icon itself.
If you are planning to publish this map online as well, you can click here to learn how to make your icons interactive based on the data from your file.