How to Convert Map Coordinates in Excel

Tuesday, June 14, 2016 | Milos Gregor

This post shows you how to convert coordinates between different map projections directly in Excel.

The GIS.XL add-in does not support direct map coordinates conversion. But this feature you can use indirectly. Imagine that you have in your Excel table of GPS coordinates and you want to convert them from one coordinate system to another. If you use the GIS.XL add-in, you only need to take 3 simple steps:

The procedure is very simple and quick.

The following video shows the conversion in practice. The example uses a list of 1,288 springs with their spatial positions in WGS84 coordinate system (latitude, longitude). After the shapefile creating, the coordinate system in Map Panel is changed to “USA Contiguous Lambert Conformal Conic”. Finally, converted coordinates are imported back into Excel spreadsheet.

Stay informed on the latest news via our newsletter.