topic Re: fail to open CSV in ArcGIS Pro Questions

fail to open CSV

clt_cabq — Mon, 13 May 2024 15:55:19 GMT

I am trying to open a CSV with 93 records and 11 columns but am getting this error.. any ideas what could be causing this?

Re: fail to open CSV

Ed_ — Mon, 13 May 2024 17:27:07 GMT

May be try converting the CSV to an Excel Worksheet, check the column(s) datatype and then use the tool 'Table to Excel'.

Re: fail to open CSV

RobertBorchert — Mon, 13 May 2024 17:48:04 GMT

it means you have an integer field that is way to long.

Create a table and use the .csv to fill in the attribute names. Change the integer field to a string with a length of 255. Make sure none of the field has a length of 8000. All need to be 255 or less

then load it using Load Data

Re: fail to open CSV

clt_cabq — Mon, 13 May 2024 18:03:41 GMT

@RobertBorchert that isn't the case here, which is about what I had thought it was initially but some other research pointed to this article and information about some settings (as described in my response to @Ed_ ) . Situation is resolved now, but thanks for your suggestion!

Re: fail to open CSV

clt_cabq — Mon, 13 May 2024 18:06:37 GMT

Update: situation resolved - this article points to some changes at v3.2 that change how Pro handles tabular/text file data and points to settings that should be changed via the Options page. Took me a couple of tries, and the fix finally took when I removed the .csv file from my project and then added it back in again, which is a little bizarre but ArcGIS be like that sometimes.

Re: fail to open CSV

Ed_ — Mon, 13 May 2024 18:12:07 GMT

As a side note, when I work with CSVs I usually bring it in as a Geodatabase table using the Table to Geodatabase tool I usually avoid bringing in CSVs as is using Add Data

Re: fail to open CSV

RobertBorchert — Mon, 13 May 2024 18:18:33 GMT

good info I will have to check my settings. Have not imported a csv since I upgraded