topic Re: Translate and reverse geocode a spreadsheet in ArcGIS API for Python Questions

Translate and reverse geocode a spreadsheet

AlyssaRenteria — Fri, 21 Mar 2025 23:41:41 GMT

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.

Re: Translate and reverse geocode a spreadsheet

EdMorris — Mon, 24 Mar 2025 10:20:58 GMT

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

Re: Translate and reverse geocode a spreadsheet

AlyssaRenteria — Mon, 24 Mar 2025 18:59:12 GMT

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.