Forum Discussion
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 ...
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