Plotting Latitude And Longitude

Map making, or cartography, was a serious, tedious, and often life-long craft back in the days when much of the world was still unexplored. These days, mapmaking is assisted by advanced tools, such as satellites, GPS, aerial photography, sensors, and many more. Latitude and longitude coordinates have continued to be invaluable in map-making. In fact, modern geolocation methods still make use of latitude and longitude data to generate maps.

Latitude And Longitude 101

If you remember your basic algebra and plotting points on the X and Y axes, then you already have a basic understanding of latitude (represented by the Y-axis) and longitude (represented by the X-axis). 

Because the world is spherical in shape, and not flat, imaginary latitude lines encircle the globe east-west and parallel to each other, with the main reference point as the equator — the zero latitude. Latitude lines, or parallels, that run above the equator (towards the North pole) are numbered from one to 90 degrees; parallels below the equator (towards the South pole) are numbered from -1 to -90 degrees. In short, latitude is the measurement of distance north and south of the equator. 

Imaginary longitude lines, on the other hand, have no natural zero reference point, so the Greenwich Observatory in London was assigned as the zero longitude, or the prime meridian. Longitude lines, or meridians, run around the earth from the North pole to the South pole and parallel to the prime meridian. Meridians to the east of the prime meridian are numbered from one to 180 degrees; meridians to the west of the prime meridian are numbered from -1 to -180 degrees. Longitude, therefore, is the measurement of distance east and west of the prime meridian.   

Using these imaginary lines, latitude and longitude number pairs — or coordinates — can be plotted on a map; the latitude always comes first, and the longitude comes second. Using a world map or a globe, for example, and plotting zero latitude (0 degrees) and -78.455833 longitude (-78.455833 degrees or -78 degrees and 456 minutes), you’ll arrive at the Mitad del Mundo in Quito, Ecuador. Plot 51.500833 latitude and -0.141944 longitude and you’ll arrive at Buckingham Palace, which is very near the Greenwich Observatory.  

Latitude and longitude coordinates are often represented simply as number pairs separated by a comma. The number pairs can be in the form of decimals or expressed in degrees and minutes.

Mapping Coordinates

If you have a list of coordinates that you want to map and you know how to code, you can directly use Google Map’s API to do it. Or you can simply copy and paste your list of coordinates on ShowMyMap’s map creation tool. 

If you have location data on a spreadsheet which includes coordinates and the latitude and longitude coordinates are together in the same column, the first thing you have to do is place them in separate columns. 

Follow these steps:

  1. Insert two new columns before/to the left of the coordinates column. Name these columns Latitude and Longitude, respectively. 
  2. To find and input the latitude coordinates into the latitude column, use this formula: =LEFT(F2, FIND(“,”, F2)-1). (Make sure the formula does not include the “.” when you copy and paste it.) F2 is column F row 2, or the first cell with the coordinates; the formula “finds” the value to the left of the comma. Copy the formula down the column.
  3. To find and input the longitude coordinates into the longitude column, use this formula: =RIGHT(F2, LEN(F2)-FIND(“,”, F2)). The formula “finds” the value to the right of the comma. Copy the formula down the column. 

Once you have separated the latitude and longitude coordinates, simply copy and paste your spreadsheet into ShowMyMap’s map-making tool. You’ll generate a map similar to this one:

Finding Latitude And Longitude Coordinates Using Addresses

If you need to find latitude and longitude coordinates and you have addresses, city names, postal/zip codes, and/or landmarks, you can convert these into their respective coordinates by using ShowMyMap’s batch geocoding tool. 

Create your first map now for free!

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]raderjoes.com
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