topic Re: All CSV data (field names and values) is placed in one column in ArcGIS Pro Questions

All CSV data (field names and values) is placed in one column

MK13 — Tue, 08 Apr 2025 00:09:21 GMT

What would cause ArcGIS Pro to place all csv data into one column? In excel, the data shows up in separate columns as expected. PS: The data is blurred intentionally.

ArcGIS Pro:

MS Excel:

Re: All CSV data (field names and values) is placed in one column

DanPatterson — Tue, 08 Apr 2025 00:52:27 GMT

If you have the data in Excel, did you use?

Excel To Table (Conversion)—ArcGIS Pro | Documentation

or if you have the csv then you can use it as the input to the following tool

Table To Table (Conversion)—ArcGIS Pro | Documentation

do both yield the same results?

If so then there may be something wrong with how the field names are being interpreted.

Re: All CSV data (field names and values) is placed in one column

MK13 — Tue, 08 Apr 2025 02:07:24 GMT

Running Export Table (which is the replacement for Table to table) on the csv file didn't solve the issue but Excel to table did. Once I converted the csv to excel and ran excel to table, the columns and data were split into their correct spots. Unfortunately though, I am unable to utilise excel in this way because the CSV data that I will be working with contains more that 1 millions rows. The data is upward of 4 millions rows.

Re: All CSV data (field names and values) is placed in one column

DanPatterson — Tue, 08 Apr 2025 02:12:15 GMT

From my link

This is a deprecated tool. This functionality has been replaced by the Export Table tool.

but perhaps there is an issue with the replacement. Rule that possibility out as well using the 'deprecated' tool.

Re: All CSV data (field names and values) is placed in one column

DanPatterson — Tue, 08 Apr 2025 02:21:07 GMT

and if that doesn't work then creating a schema.ini file is recommended

https://support.esri.com/en-us/knowledge-base/how-to-edit-the-field-properties-of-a-csv-file-in-arcgi-000024378