Forum Discussion

Shelbyj's avatar
Shelbyj
Copper Contributor
Apr 29, 2026

Importing CSV file properly

Hey, I'm having issues importing a CSV file properly. There are three columns of data, two columns as dates and one as a measurement. I have done all the steps to import the CSV data. I've saved the ...
community
excel
office 365
Olufemi7's avatar
Olufemi7
Iron Contributor
Apr 30, 2026

HelloShelbyj​,

Issue is likely due to delimiter settings and Excel not recognizing the date format.

CSV not splitting:
Check Data > From Text/CSV and confirm delimiter is set to comma
Verify the file actually uses commas (not semicolons)
Check system list separator if needed

Dates (YYYYMMDD not converting):
Excel does not auto-detect this format
Use formula:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
Then format as Date

Or use Text to Columns:
Data > Text to Columns > Delimited > Next > Next
Select Date = YMD
Finish