How to Plot Latitude and Longitude in Google Sheets

To get latitude and longitude in Google Sheets, install a dedicated mapping add-on like InstaMaps and use the =GEOCODE() formula. Typing =GEOCODE(A2:A50) turns a column of text addresses into clean decimal coordinates that automatically update whenever the underlying spreadsheet changes.

This method is built for field service managers, real estate analysts, and local government planners who need to map locations directly within their existing databases. By the end of this tutorial, you will have a workbook that converts standard addresses to coordinates, translates raw GPS points back to street names, and publishes a shareable web map.

What you need to get started

To begin mapping coordinates, you need a Google Sheets document containing physical addresses and a dedicated geocoding tool. Standard Google Sheets functions cannot automatically translate text strings into geographic coordinates without a bridge to a mapping server.

Install the InstaMaps add-on from the Google Workspace Marketplace. It is free and provides the specific custom functions required to process location data. Once installed, access the tool from the Extensions menu to open the sidebar, which inserts formulas without typing so you avoid syntax errors.

Structure your spreadsheet cleanly. Place your addresses in a single column, ensuring the street number, city, and postcode are combined into one cell for the most accurate results.

1. A Google Sheets document with address data.

2. The free InstaMaps add-on installed.

3. Clean, structured text in single cells.

Step 1: Convert addresses to coordinates

The core task is translating a text string like "1600 Amphitheatre Parkway, Mountain View, CA" into numerical latitude and longitude. To do this, use the =GEOCODE() formula. If your addresses are listed in column A from row 2 to row 201, click cell B2 and enter =GEOCODE(A2:A201).

When you press enter, the formula exhibits spill behaviour. It automatically populates the adjacent columns. Column B will display the latitude (e.g., 37.4220) and column C will display the longitude (e.g., -122.0841). You do not need to drag the formula down; it fills the entire array instantly.

If you add a new address to the bottom of your list, the array expands automatically. This ensures your coordinate columns remain perfectly synchronised with your source data without requiring manual formula updates.

Step 2: Convert coordinates to addresses

Sometimes you receive raw GPS data from tracking devices or survey equipment and need to understand the physical location. This requires translating decimal degrees back into a readable street address.

Use the =REVERSE_GEOCODE() formula to accomplish this. If latitude is in column A and longitude is in column B, select cell C2 and type =REVERSE_GEOCODE(A2:B100). The formula reads the coordinate pairs and returns the closest known street address, standardising the data into a clean format.

This process is highly useful for delivery fleets that need to verify drop-off locations or field crews recording coordinates at a job site. You can pair this with the =CLEAN_ADDRESS() function to fix any formatting inconsistencies in the output text.

Step 3: Generate a live map from your data

Coordinates are difficult to interpret as raw numbers. Visualising them on a map provides immediate geographic context. While you could copy and paste coordinates into a map engine manually, doing so for hundreds of rows is inefficient.

InstaMaps solves this with the =INSTAMAP() formula. If you have latitude and longitude in columns B and C, type =INSTAMAP(B2:C201) into an empty cell. The cell returns a live, hosted shareable map URL.

Clicking this link opens a web map displaying every coordinate from your range. Because the map reads directly from your spreadsheet, any changes you make to the coordinates or addresses appear on the live map instantly. You can also use =ROUTE_LINK() to generate specific navigation links using Google Maps' official URL scheme, which supports a maximum of 11 stops.

Worked example: Mapping a 200-home farm inspection

Consider a local agricultural inspector managing a 200-home rural farm assessment. The council provides a list of property addresses, but the inspectors need precise coordinates to navigate the large estates using mobile devices.

The coordinator installs InstaMaps and applies =GEOCODE(A2:A201) to the property list, instantly generating two columns of coordinates. The coordinator then uses =ROUTE_LINK() to generate a standard Google Maps navigation link for the five inspection crews. Because the route limit is 11 stops, the coordinator breaks the data down into daily routes for each crew.

Finally, the coordinator uses =INSTAMAP() to create a master overview map. When a property is marked as 'Inspected' in column D, the master map updates automatically, giving the operations centre a real-time view of their progress across the 200 homes.

Limits and honest alternatives

Spreadsheet mapping add-ons rely on external servers to process data, which means daily query limits apply. InstaMaps provides a free tier of 100 lookups per day. If you verify your account with a free email unlock, this limit increases to 1,000 lookups per day.

For small to medium datasets, this is more than sufficient. However, if you have a dataset with 50,000 rows that requires daily coordinate updates, a spreadsheet is the wrong environment. In that scenario, a dedicated Geographic Information System (GIS) like QGIS or a paid cloud database with native spatial indexing will handle the data much faster and without daily limits.

Similarly, if you only need to map three or four locations occasionally, copying and pasting them directly into Google Maps is faster than setting up a spreadsheet architecture. InstaMaps is designed specifically for users who need repeatable, automated mapping directly alongside their existing spreadsheet workflows.

1. Free tier: 100 daily lookups.

2. Email unlock: 1,000 daily lookups.

3. Use a dedicated GIS for datasets exceeding 10,000 rows.

Common Questions