Layers with groups
When you import a spreadsheet, all its rows land in one group. Import a second one and you have two groups on the same map, like layers. In this guide you give each group its own name and color, and switch one off and on again.
To follow along, download the sample spreadsheets chicago_places.xlsx and chicago_libraries.xlsx.
Import two spreadsheets
-
On a new map, click Import on the right, then Select file. Your computer’s file window opens.
-
Click your first spreadsheet, then Open.
-
Wait a moment while MapHub finds each address. A marker appears for every row, and all of them land in one group in the item list, called Imported from chicago_places.xlsx.
-
Click Import above the item list, then Select file.
-
Click your second spreadsheet, then Open.
-
Wait a moment while MapHub finds each address. Its rows land in a group of their own.
Name and color each group
-
Click the first group in the item list, and type a new name under Title. This selects every marker in the group, so what you change next applies to all of them.
-
Under Set colors, click a color. All the markers of the group change to it at once.
-
Do the same for the other group: click it, type a name and click a color.
Show, hide and save
-
Click the eye icon next to a group to hide its markers, and click it again to show them.
-
In the Map tab, type a Title and click Save. Your map is saved with both groups, ready to share.
Groups from a column
If your places are all in one spreadsheet, you can still split them into groups: add a group column and write each row’s group name in it. Every name becomes a group of its own when you import the file.
For more about groups and the other columns, see XLSX / CSV import.