Excel Guides

Exporting Latitude and Longitude in Excel

Exporting latitude and longitude in Excel is a relatively simple process. First, open your Excel spreadsheet. Then, click on the "File" tab in the top left corner of the screen. Next, click on "Save As." In the "Save As" dialogue box, select the location where you want to save your file. Then, in the "File Name" field, type in the name of your file. Finally, click on the "Save" button.

Once your file has been saved, open it up in a text editor such as Microsoft Word or Notepad. Next, find the column that contains your latitude data. Then, copy and paste that column of data into a new column. Next, find the column that contains your longitude data. Copy and paste that column of data into a new column as well.

Next, save your file as a .CSV (comma separated values) file. To do this, simply add ".csv" to the end of your file name. For example, if your original file was named "MySpreadsheet.xlsx", you would save it as "MySpreadsheet.csv".

Once you have saved your file as a .CSV file, open up Google Earth Pro. Then, click on the "File" tab in the top left corner of the screen and select "Open." In the "Open" dialogue box, navigate to the location of your .CSV file and select it. Once your file has been opened in Google Earth Pro, you will see all of your latitude and longitude data points plotted on a map!

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.