topic Re: Trouble getting ArcGIS Pro to geocode medium-sized file in ArcGIS Pro Questions

Trouble getting ArcGIS Pro to geocode medium-sized file

JennaPollack — Thu, 09 May 2024 14:34:08 GMT

I'm trying to import a spreadsheet (3 columns, 883,311 rows; one of the columns is full addresses) in order to geocode it -- have now tried two different ways.

1) Using the Geocode Addresses tool, with the spreadsheet on my computer as the Input Table. But after 20min of trying to import it just gave up and closed (I missed the error message).

2) I tried to plainly import the .csv into the program and got this error:

Re: Trouble getting ArcGIS Pro to geocode medium-sized file

ShanaBritt — Thu, 09 May 2024 15:24:45 GMT

@JennaPollack What were your steps to add the sheet from your Excel file? How did you try to add the csv?

Also remove the space from the name of the excel file and replace it with an underscore before trying to geocode it.

https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm

Re: Trouble getting ArcGIS Pro to geocode medium-sized file

BobBooth1 — Fri, 10 May 2024 13:20:05 GMT

It might help to use the Export Table geoprocessing tool to export your table to a file geodatabase table.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/export-table.htm

Re: Trouble getting ArcGIS Pro to geocode medium-sized file

JennaPollack — Fri, 10 May 2024 14:24:04 GMT

Thank you!

Re: Trouble getting ArcGIS Pro to geocode medium-sized file

JennaPollack — Fri, 10 May 2024 14:24:07 GMT

Thank you so much, that did it!