Translate and reverse geocode a spreadsheet

241
2
03-21-2025 04:41 PM
AlyssaRenteria
Emerging Contributor

I have a spreadsheet that contains coordinates across the world separated into two columns (latitude and longitude). Due to the size of the spreadsheet, it's unreasonable to manually input all x and y coordinates. Is there a way to batch reverse geocode a spreadsheet and still use the lang_code parameter? The example shows only a single location and I wasn't sure if the batch geocoding section would actually apply in this situation.

Tags (1)
0 Kudos
2 Replies
EdMorris
Esri Contributor

Hello!
Have you had a look at the ArcGIS for Excel add-in? This will geocode the coordinates for you.

Have a look at this link as an introduction to ArcGIS For Excel:

https://doc.arcgis.com/en/microsoft-365/latest/excel/get-started-with-arcgis-for-excel.htm

The document goes over the core features of the add-in and where to download and how to install it.

Also.... have a look at this really quick video to get the basics of the add-in:

https://www.youtube.com/watch?v=IdPw8XnlQFM

I hope this helps!

kind regards

ed

Are you a Microsoft Excel power user and want to bring ArcGIS mapping capabilities into your worksheets? This GeoSnap introduces you to ArcGIS for Excel, a Microsoft 365 add-in designed to allow you to create interactive maps from your Excel data in a few seconds. We will show you how to install ...
0 Kudos
AlyssaRenteria
Emerging Contributor

Hi Ed,

I appreciated the suggestion. It's not a solution to my question but was still cool to learn about this feature. I'm more interested in the translation of existing fields since reverse geocoding was successful. The output results are in their native language and I'm trying to have them in English if possible.

0 Kudos