Map Excel Location Data With ShowMyMap

Most folks know that using Excel is a great way to store location data, as you can easily arrange addresses, city names, states, zip codes, and other pertinent information into neat rows and columns. 

With ShowMyMap, you can create an interactive map using your Excel location data in a jiffy! But why bother with a map, you might ask?

Having a map to visualize your data can help you formulate an efficient plan on how to go about following up on your company’s lead prospects, for example, or picking up donations for your community drive, or figuring out the best route when picking up and walking dogs from all over the neighborhood.

ShowMyMap’s interactive map also allows you to click on any markers to get more information on any location data; choose specific location data/map markers to display; zoom and pan the map; share the map with others; and many more.

Generate Your Map From Excel

You can easily convert your spreadsheet data into a map using ShowMyMap’s convenient tools and advanced algorithms, and with the benefit of Google Maps’ innovative API. you may even use Numbers or Google Docs to organize your location data and still be able to generate a map from it. 

The more data you have, the better your map will look. But you can also create a map from only a single column of data, such as if you only have city names or zip codes. 

If you have your location data on hand, you can start creating your map now! Just follow the steps below. 

  1. Once your spreadsheet is open, press Ctrl + A or Cmd + A to select your location data. 
  2. Press Ctrl + C or Cmd + C to copy the data. 
  3. Go to the ShowMyMap homepage: https://www.showmymap.com/.  
  4. In the Copy + Paste Your Data box, paste your data by pressing Ctrl + V or Cmd + V. 
  5. Click “Create Map.”*Alternatively, you can simply drag and drop your XLS or CSV file into the appropriate box
  6. You will be prompted to use the Geo Decoding section. Choose allthe appropriate fields that apply to your location data, i.e., if your data includes an address, city or county, state, zip code, and/or latitude and longitude.*You may opt to configure the Map Preview and Customize Map sections before proceeding to the final steps. Or you can make changes to your map after it’s been created and saved.
  7. Click “Make Map” and wait for the ShowMyMap’s geocoder to do its job. 
  8. When the geocoding process is done, you will be prompted to “Save Map & Continue.”
  9. Select how you want to save your map: public, unlisted/private, or password protected. 
  10. Input your map’s title, your email, and any notes or description you might want to add (the latter is optional).  
  11. Click “Save Map.” Once your map has been saved, you will be provided with your map’s URL.  
  12. Click “View Saved Map” and then you will be directed to your map page.

Watch The How-To Video

Here’s a short video to show you how the process works.

Map Sharing

If you saved your map as “Public” or “Unlisted,” you can give others access to it in a number of ways. Anybody who has access will also be able to explore your map using the many, helpful features of ShowMyMap. Here are your options for sharing. 

  1. Copy your map’s URL from your web browser’s location bar, and then paste the URL into an email, an instant message, or anywhere you want it posted, such as on your Twitter account and Facebook page.
  2. Embed your map directly into a web page, or embed a simple badge that shows a map preview and which is linked to your full map. You can retrieve the embed code from the email you received when you saved your map. An embed code is also provided when you edit your map. 
  3. Load the KML version of your map to view it in Google Earth

Start creating map

Drag and drop your file (xls, xlsx or csv) Use our sample data, by clicking here. Or

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Copy + paste your data
Configuration

Map Fields

+ Add Custom Field
Show More

    Oh no!

    On the free tier you can only map up to 150 locations at one time. Please add a plan if you wish to map more than 150 locations.

    Related Articles