Use ShowMyMap to import location data from Excel or similar spreadsheets and generate a personalized map of places you are interested in or would like to recommend to others.
- Input location data, such as addresses, street names, cities, and zip codes on Excel.
- The more location data you have, the more defined the map will be.
- Share your generated map with family, friends, colleagues, or website visitors.
How To Use ShowMyMap To Generate A Map From Excel
- Create a spreadsheet that lists different location data in separate columns, i.e. street names in one column, city names in another column, and so on. The more columns you fill up with location data, the more detailed and user-friendly your map will be.
- Simply select and copy all the spreadsheet data using the corresponding keyboard shortcuts.
- Open ShowMyMap on your browser.
- Paste the copied location data into the location data box. The various column data should also populate separate columns in the location data box.
- Click on the “Validate and Set Options” button to verify that all imported data are correctly placed in their respective columns.
- Click on “Make Map.” ShowMyMap will geocode the location data you have provided.
- ShowMyMap will generate a map based on your location data.
- Click on “Save and Continue.” You will be asked for a map name and description; the latter is optional.
- Click on “Save Map.” You will be asked to provide an email address and your map will be automatically sent to your mailbox.
View And Share Your Map
- The ShowMyMap email you receive will contain a link address to your map.
- Simply share this link with anyone you like, through emails, instant messaging, or social media.
- The email will also contain an HTML snippet code which you can embed into your website so that your site visitors can have interactive access to your map.
- You will also be given a KML file version of your map which you can use to view your map using Google Earth.