Excel Guides

Displaying Latitude and Longitude in Excel

There are a few different ways that you can display latitude and longitude values in Excel. One way is to use the built-in functions LATITUDE and LONGITUDE. These functions will take a cell reference as an argument and return the latitude and longitude of that location, respectively. For example, if you have a list of cities in column A and you want to display the latitude and longitude values for those cities in columns B and C, you could use the following formulas:

=LATITUDE(A1)
=LONGITUDE(A1)

You could also use the GEOCODE function, which is similar to the LATITUDE and LONGITUDE functions but also returns the address of the location. The syntax for this function is as follows:

=GEOCODE(latitude,longitude)

So, if you wanted to find the address of a location using its latitude and longitude values, you could use a formula like this:

=GEOCODE(40.7128,-74.0059)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.