Date format changes when exporting to a csv file

barbarabeach · April 2021

I am trying to make an excel table of transactions from my Mac Quicken for Canada investment account.

The date format is unusable in numbers or excel so the table won't sort by date. the date format in my quicken is 10-07-2020. WOW! It just changed!
In my register it appears to be 2020-mm-dd. In .csv format it switches to m/d/yyyy and I cannot get excel to recognize the number as a date.

RickO · April 2021

I just tried this. The CSV does come out in m/d/yyyy format. Here's what the begininning of it looks like when opened in Word:

,"Split","Clr","Date","Match Status","Check #","Payee","Amount","Category","Tags","Action","Transfer","Memo/Notes","Balance"
Balance:,,,,,,,,,,,,, 9817.84
,,"","4/30/2021","",,"

When I import into Excel, the date field is covered to raw dates

Split	Clr	Date	Match Status
		4/30/21
		4/30/21
		4/26/21
		4/23/21

I'm not sure what's going wrong with yours, but it sounds more like an Excel problem. Have you tried selecting the date column in Excel, then menu Format > Cells > Date? Try opening the CSV file in Word and see what it looks like. If it looks like mine, then it should work fine and you may need to pursue this on a Office forum.

Date format changes when exporting to a csv file

Answers

Categories