SEO Dubai | Best SEO Company in Dubai

How to find latitude and longitude in Google Sheets

Are you looking for a functional tool to extract latitude and Longitude from Google Map URL in Google Sheets? I realized there is no such tool that will extract geocodes in bulk without prior knowledge of coding.

Step by Step Guide on how to extract geocodes from Google Maps.

Here are the simple steps to extract geocodes from Google Map URL in Google Sheets.

Step 1 Add all the Google Map URLs in a column. (e.g. Column A)

Step 2 Insert the formula =SPLIT(A1, “@”) in the next column (e.g. Column B)

Step 3 Latitude and Longitude will appear together in Column C.

Step 4 Insert the formula =SPLIT(C1, “,”) in Column D

Step 5 latitude and Longitude will appear separately in Columns D & E

You can hide columns B, C, & F later. As deleting the column will delete the geocodes as well.

If you wish to delete the columns, you can copy the columns D & E and paste special as “Values Only” before deleting the columns B & C that contain our formulae.

This is the easiest way for extracting the geocoordinates. You can download our template file below with all the formulas already inserted. All you have to do is, insert the Google Map URL and the latitude and longitudes will be automatically extracted from the Google Map URLs.

Download the template here

Leave a Reply

Nullam eget felis

Do you want a more direct contact with our team?

Sed blandit libero volutpat sed cras ornare arcu dui. At erat pellentesque adipiscing commodo elit at.

Give your website a boost today!

Get results in 90 Days

Enter your email address to receive a free analysis about the health of your website marketing.