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

[MK13]

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:

[DanPatterson]

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.

[MK13]

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.

[DanPatterson]

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.

[DanPatterson]

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-arcg...