Go to
Google My Maps
Click on [Create a New Map] (on mobile devices, its the red circle at the bottom right)
Click where it says "Untitled Map" and give your map a name (on mobile devices, you may have to click on [LEGEND] first)
Click on "Import" and import the CSV file you exported in the first step
On the next screen (Choose columns to position your placemarks), select the Address, Town and Postcode columns, and click on [Continue]
On the next screen (Choose a column to title yoiur markers), select the Name column, and click on [Finish]
Once the map has loaded, click where it says "Uniform Style"
Under "Group places by", click on the drop-down and change the value to "Style by data column:" and "Visited"
Colours are selected automatically, you can change them by hovering over the style name (either "Y" or "Other./No value"), then click the paint icon and select a colour and optionally an icon
Click to return to the main page.
