Dates Wrongs when Import CSV

#1

When import CSV, the date initial and end are wrong, how fix it, I change format in Excel but nothing resolve this problem.

#2

Please share the CSV file and the result of importing, so that we could see what is “wrong”.

#3

This csv.CRN_UNV_JD_HOLANDES.csv (27.2 KB)

#4

Thanks. What is the result of importing? And what is the date format in the settings dialog?

#5

the schedule has the current data in sequence.

errors_date
errors_date583×547 26.7 KB

#6

so what is the date format in the settings dialog?

#7

dd/MM/yyyy, I changed for tests, dd/MM/yy, MM/dd/yy, and mm/dd/yy or dd/mm/yy, everything don’ts worked.

#8

You have capitalized column names: Data Inicial;Data Final
GanttProject expects the second words to be lowercased: Data inicial;Data final

Also, it appears that the files are in Windows CP-1252 encoding. I recommend using UTF-8, there must be a setting for that in Excel.

By the way, you can import Excel files directly without export to CSV step,

#9

Thanks a lot!! About o UTF-8 yep, fixed it too, thank you