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

Address City State Zipcode Name Phone Number Group URL Email
12032 SE Sunnyside rd Clackamas OR 97015 Safeway Clackamas (503) 698-1121 Group B https://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html [email protected]
4715 SE Cesar Estrada Chavez Blvd Portland OR 97202 Trader Joe's Portland SE (503) 777-1601 Group C https://locations.traderjoes.com/or/portland/143/ [email protected]
3380 Lancaster Dr NE Salem OR 97305 Safeway Salem (503) 399-1502 Group B https://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html [email protected]
12220 SW Scholls Ferry Rd Tigard OR 97223 Whole Foods Market Greenway (971) 371-7000 Group A https://www.wholefoodsmarket.com/stores/greenway [email protected]
8145 SW Barbur Blvd Portland OR 97219 Safeway Barbur (503) 452-6068 Group B https://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html [email protected]
1550 NW 9th St Ste 100 Corvallis OR 97330 Trader Joe's Corvallis (541) 753-0048 Group C https://locations.traderjoes.com/or/corvallis/154/ [email protected]
1210 NW Couch St Portland OR 97209 Whole Foods Market Pearl (503) 525-4343 Group A https://www.wholefoodsmarket.com/stores/pearl [email protected]
353 E Broadway Eugene OR 97401 Whole Foods Market Eugene (541) 434-8820 Group A https://www.wholefoodsmarket.com/stores/eugene [email protected]
3527 SE 122nd Ave Portland OR 97236 Safeway 122nd (503) 760-5448 Group B https://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html [email protected]
9940 NE Cornell Rd Hillsboro OR 97124 Whole Foods Market Tanasbourne (503) 645-9200 Group A https://www.wholefoodsmarket.com/stores/tanasbourne [email protected]
15391 Bangy Rd Lake Oswego OR 97035 Trader Joe's Oswego (503) 639-3238 Group C https://locations.traderjoes.com/or/lake-oswego/142/ [email protected]
2490 OR-99W McMinniville OR 97128 Safeway McMinniville (503) 435-3120 Group B https://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html [email protected]
4121 NE Halsey St Portland OR 97232 Trader Joe's Portland Hollywood (503) 284-4232 Group C https://locations.traderjoes.com/or/portland/144/ [email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

Address City State Zipcode Name Phone Number Group URL Email
12032 SE Sunnyside rd Clackamas OR 97015 Safeway Clackamas (503) 698-1121 Group B https://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html [email protected]
4715 SE Cesar Estrada Chavez Blvd Portland OR 97202 Trader Joe's Portland SE (503) 777-1601 Group C https://locations.traderjoes.com/or/portland/143/ [email protected]
3380 Lancaster Dr NE Salem OR 97305 Safeway Salem (503) 399-1502 Group B https://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html [email protected]
12220 SW Scholls Ferry Rd Tigard OR 97223 Whole Foods Market Greenway (971) 371-7000 Group A https://www.wholefoodsmarket.com/stores/greenway [email protected]
8145 SW Barbur Blvd Portland OR 97219 Safeway Barbur (503) 452-6068 Group B https://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html [email protected]
1550 NW 9th St Ste 100 Corvallis OR 97330 Trader Joe's Corvallis (541) 753-0048 Group C https://locations.traderjoes.com/or/corvallis/154/ [email protected]
1210 NW Couch St Portland OR 97209 Whole Foods Market Pearl (503) 525-4343 Group A https://www.wholefoodsmarket.com/stores/pearl [email protected]
353 E Broadway Eugene OR 97401 Whole Foods Market Eugene (541) 434-8820 Group A https://www.wholefoodsmarket.com/stores/eugene [email protected]
3527 SE 122nd Ave Portland OR 97236 Safeway 122nd (503) 760-5448 Group B https://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html [email protected]
9940 NE Cornell Rd Hillsboro OR 97124 Whole Foods Market Tanasbourne (503) 645-9200 Group A https://www.wholefoodsmarket.com/stores/tanasbourne [email protected]
15391 Bangy Rd Lake Oswego OR 97035 Trader Joe's Oswego (503) 639-3238 Group C https://locations.traderjoes.com/or/lake-oswego/142/ [email protected]
2490 OR-99W McMinniville OR 97128 Safeway McMinniville (503) 435-3120 Group B https://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html [email protected]
4121 NE Halsey St Portland OR 97232 Trader Joe's Portland Hollywood (503) 284-4232 Group C https://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

    Reduslim Kaufen