Convert coordinates DMS to decimal in Google Sheets (=COORD_CONVERT)

To convert coordinates from DMS (Degrees, Minutes, Seconds) to decimal in Google Sheets, install the InstaMaps add-on and use the =COORD_CONVERT() function. Point it at a cell containing a DMS string like 48° 51' 30" N, and it outputs the decimal equivalent 48.85825 ready for spatial calculations.

This reference page is for surveyors, logistics managers, and environmental scientists dealing with raw GPS hardware exports. By standardising legacy DMS strings into clean decimal degrees, your data feeds directly into distance formulas or the =INSTAMAP() function without manual text manipulation.

Syntax and arguments

Converts coordinates between decimal degrees (DD) and degrees, minutes, and seconds (DMS). The function automatically detects the input format and converts it to the opposite standard.

=COORD_CONVERT(location, [format])

| Argument | Required | Description | | :--- | :--- | :--- | | `location` | Yes | The cell or range containing the coordinates you want to convert. Accepts standard DMS strings (e.g., `48°51'24.1"N`) or decimal numbers (e.g., `48.856613`). If your latitude and longitude sit in two separate columns, supply a combined range like `A2:B201` to process both sets of coordinates simultaneously. | | `format` | No | A string specifying the desired output format. If omitted, InstaMaps auto-detects the input: if you feed it DMS, it outputs decimal degrees, and vice versa. You can override this behaviour by explicitly typing `"DD"` to force decimal output, or `"DMS"` to force degrees, minutes, and seconds output. |

When applied to an array like `A2:A201`, the function dynamically expands downwards, generating a spilled array of converted coordinates without needing to drag a fill handle down 200 rows. Input coordinates must contain standard geodetic symbols (° ' ") for the auto-detect feature to recognise DMS formatting.

Common errors

If your cell returns `#NAME?`, Google Sheets cannot find the `=COORD_CONVERT` function. This occurs because the InstaMaps add-on is not installed in the current spreadsheet. To resolve this, install the free InstaMaps add-on from the Google Workspace Marketplace. Once installed, refresh the sheet, click Extensions > InstaMaps > Enable formulas, and the error will resolve immediately.

If the cells return `#ERROR!` or `#VALUE!`, check your input data. A missing degree symbol (°) or an extra space in the DMS string prevents the format detector from parsing the coordinate. Ensure your inputs follow standard formats like `48°51'24.1"N` or `48.8566, 2.3522`.

You may also encounter quota limits. The free tier permits 100 lookups per day. If you attempt to convert a 500-row array, the cells will return a `Quota exceeded` message after the 100th coordinate. You can raise this limit to 1,000 lookups per day with a free email unlock. For troubleshooting related to coordinate extraction before conversion, see our guide on the [google-sheets-geocode-formula]. If you frequently exceed 1,000 daily conversions, process your data in batches or copy and paste the output values to free up computation space.

Worked example: 200-home farm survey

A rural surveyor is mapping a 200-home farm development. The local county planning office provides parcel records using degrees, minutes, and seconds (DMS). Cell A2 contains the latitude `48°51'24.1"N` and cell B2 contains the longitude `2°21'03.5"E`. These DMS strings run down columns A and B, ending exactly at row 201.

To map these 200 locations using InstaMaps, the surveyor requires decimal degrees. Manually converting 400 separate DMS strings is impractical, and writing a standard Google Sheets formula using `LEFT`, `MID`, `RIGHT`, and `FIND` to extract the numbers is highly prone to breaking.

Instead, the surveyor uses a single formula in cell D2: =COORD_CONVERT(A2:A201)

They repeat this in cell E2 for the longitude: =COORD_CONVERT(B2:B201)

InstaMaps detects the degree, minute, and second symbols in the cells and outputs standard decimal numbers (e.g., `48.856694`), filling columns D and E down to row 201 automatically. The surveyor can now feed these clean decimal coordinates into the mapping formula.

Because the surveyor needs to map all 200 homes in one sitting, they will hit the standard 100-lookup daily quota on the free tier. By completing the free email unlock inside the InstaMaps sidebar, the daily limit increases to 1,000 lookups, allowing the entire 200-row array to calculate without interruption.

Alternatively, to avoid hitting the daily quota, the surveyor can open the InstaMaps sidebar, click the Build-the-workflow button, and apply one of the templates from get-instamaps.com/templates, which structures the conversion alongside the mapping functions automatically.

Worked example: 5-crew reporting dashboard

An operations manager runs a 5-crew daily shift report for a regional utility provider. The dispatch system outputs raw decimal coordinates into the Google Sheets dashboard. Cell B2 holds the latitude `51.5074` and cell C2 holds the longitude `0.1278` for Crew 1. This data runs down five rows, tracking Crews 1 through 5 (B2:B6 and C2:C6).

While decimal coordinates are necessary for the backend formulas, the human-readable shift report emailed to the 5 crew foremen needs traditional degrees, minutes, and seconds. The foremen prefer reading `51°30'26.6"N` because their hardware surveying compasses and printed county grid maps require the DMS standard to cross-reference physical waypoints accurately.

In cell E2, the manager applies the optional format argument: =COORD_CONVERT(B2:B6, "DMS")

And in cell F2 for the longitude: =COORD_CONVERT(C2:C6, "DMS")

By explicitly defining `"DMS"` in the second argument, InstaMaps overrides the auto-detect feature and converts the decimals back into formatted text strings. The resulting 5-row array provides the exact notation the foremen expect.

To make the dashboard fully functional, the manager uses the `=INSTAMAP()` function on a separate sheet to visualise these 5 crew locations. Since the map formula returns a live hosted shareable map URL that updates when the sheet changes, the foremen open the link on their phones and watch the 5 crews move throughout the shift as the decimal coordinates update in the backend.

This small 5-crew report easily stays well under the 100 daily lookups provided by the free tier, making the format argument highly efficient for daily operational reporting.

Worked example: 47-stop logistics log

A common problem in fleet management is inconsistent driver inputs. A driver submits a logistics log with 47 stops. The coordinate column (A2:A48) contains mixed formats based on the device used. Cell A2 contains a decimal coordinate (40.7484, -73.9857). Cell A3 contains a degrees, minutes, and seconds (DMS) string exported from an older in-cab GPS unit (40°44'54.2"N 73°59'08.5"W). Native Google Sheets formulas cannot process this mixed data without extensive manual cleaning or fragile REGEX chains.

InstaMaps standardises the entire column directly. To process the 47-stop log, you apply the conversion formula to a neighbouring column.

1. 1. Select cell B2 to create a clean, decimal-only column alongside the raw driver data.

2. 2. Enter the formula =COORD_CONVERT(A2, "decimal").

3. 3. Press Enter. The formula parses the DMS string and outputs 40.748389, -73.985972. If it encounters a decimal coordinate, it outputs the decimal format unchanged.

4. 4. Click the bottom right of cell B2 and drag it down to row 48 to cover the entire logistics log.

Composes with

InstaMaps formulas pass data sequentially. The output of one formula becomes the input for the next, allowing you to build automated mapping pipelines without manual copy-and-paste.

Chain 1: Convert DMS and calculate driving distance. You have a starting depot location in cell A2 and a destination in cell A3. Both are formatted as DMS strings copied from a surveyor's report. You need the exact driving distance between them. You can nest the conversion directly inside the distance calculation. The formula =DISTANCE(COORD_CONVERT(A2, "decimal"), COORD_CONVERT(A3, "decimal"), "driving") transforms the two surveyor strings into standard decimal coordinates on the fly. The =DISTANCE() formula receives these clean decimal inputs and calculates the driving distance in miles, bypassing the need to create a separate conversion column.

Chain 2: Convert an array and generate a live map. You have a column of 200 varying DMS coordinates in cells A2:A201. You want to plot every point on a hosted map to share with a field team. First, create a clean array of decimal coordinates in column B using =ARRAYFORMULA(COORD_CONVERT(A2:A201, "decimal")). Next, generate the map using the cleaned column. The formula =INSTAMAP(B2:B201, "Field Assets") takes the decimal array and returns a live hosted shareable map URL that updates when the sheet changes. Because the map reads the converted output in column B, the pipeline remains dynamic. If a surveyor corrects a DMS value in cell A45, =COORD_CONVERT() updates B45. =INSTAMAP() detects the sheet change and automatically adds the updated pin to the hosted map URL without requiring you to rebuild the link.

Limits and honest alternatives

The InstaMaps add-on is free, but formula executions count against a daily quota to manage server resources. The free tier allows 100 lookups per day. You can raise this limit to 1,000 lookups per day with a free email unlock via the add-on interface.

If you are processing a static, historical dataset of 10,000 rows and do not need to map the data, feed it into =INSTAMAP(), or calculate distances, do not use =COORD_CONVERT(). Doing so wastes your daily quota. Instead, use native text manipulation. You can write a formula to parse the strings manually. By combining SPLIT, SUBSTITUTE, and arithmetic operators like (degrees) + (minutes/60) + (seconds/3600), you can convert DMS to decimal locally. This consumes zero daily lookups. Reserve =COORD_CONVERT() for dynamic sheets where data changes frequently or when you need to feed the result directly into other InstaMaps functions.

Who this is for

This formula targets professionals who handle raw GPS data and require reliable decimal outputs without writing complex code.

1. Logistics planners: Legacy fleet GPS hardware often exports location logs strictly in DMS format. Planners need those points in decimal degrees to run modern distance calculations or build live route maps in Google Sheets.

2. Field surveyors: Surveyors record coordinates in varying DMS notations depending on the specific handheld equipment used on site. They require a reliable way to standardise hundreds of rows into a single decimal format before passing the spreadsheet to a client.

3. GIS analysts: Analysts building lightweight reporting tools without a full ArcGIS licence use this formula to clean messy text inputs. If you need to convert DMS to decimal without maintaining a fragile web of REGEXMATCH functions, =COORD_CONVERT() handles the string parsing automatically.

Common Questions