Style a dataset: colors and icons
When you import a spreadsheet, every row becomes a blue marker. In this guide you give all of them a new color and icon in a few clicks, then swap in your own marker image.
To follow along, download the sample spreadsheet chicago_places.xlsx and the marker image chicago_heart.png.
Import your data
-
On a new map, click Import on the right, then Select file. Your computer’s file window opens.
-
Click your 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 the group in the item list. This selects every marker in it, so what you change next applies to all of them.
Pick a color and an icon
-
Under Set colors, click a color. All the markers change to it at once.
-
Under Set icons, click an icon, then click Set to confirm. The markers keep their new color and show the icon.
Use your own marker
-
Click Add Icon, then Choose File. Your computer’s file window opens.
-
Click your PNG image, then Open. Use an image with a transparent background. It appears at the end of the icons.
-
Click your image, then click Set. Every marker in the group now shows it.
Save
- Click Save. Your map keeps the new look, for you and for everyone you share it with.
Styling rows one by one
You can also give each row its own color or icon, right in your spreadsheet. To find the values to use, style one marker on the map the way you like and save the map. Then click Download above the item list and choose Excel XLSX. The downloaded file has an icon and a color column: copy their values into your own spreadsheet and import it again.
For more about these columns, see XLSX / CSV import.