# Can't import .csv bank statement due to date format issue
**URL:** https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182
**Category:** Uncategorized
**Created:** [November 19, 2018, 5:33am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182 "2018-11-19T05:33:42Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@WildTZ](https://forum.manager.io/u/WildTZ)
#### Post date: [November 19, 2018, 5:33am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/1 "2018-11-19T05:33:42Z")
Hi there!
I have looked through similar threads but I get none the wiser. I’m obviously missing something.
First off Excel refuses to save the .csv file with comma separators so I have to open the file in text edit and replace the “;” with “,”.
I have tried setting the date cell in excel the same format as in manager before saving it as .csv.
I still get the same error. “Year, Month, and Day parameters describe an un-representable DateTime.”
When I open the file in texedit it looks ok, if I import it again to excel the date format is off slightly, but I guess that is because excel puts it in whatever is the default format when it’s imported from csv.
Any help would be greatly appreciated!
---
### Author:  [@jude46](https://forum.manager.io/u/jude46)
#### Post date: [November 19, 2018, 5:52am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/2 "2018-11-19T05:52:05Z")
I had problems also. I was able to import file to excel and add a column for description which my bank did not show. Also, the date format you have appears might be a problem - mine was 05/01/2018 - but I am in Australia.
Hope this helps!
---
### Author:  [@raj\_nann](https://forum.manager.io/u/raj_nann)
#### Post date: [November 19, 2018, 6:58am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/3 "2018-11-19T06:58:28Z")
according to what i know, manager stopped importing CSV file.
I used to create CSV file with all my receipt and payments (daily expenses). and import all transactions at once. it was very easy. not its not accepting csv file.
---
### Author:  [@WildTZ](https://forum.manager.io/u/WildTZ)
#### Post date: [November 19, 2018, 7:26am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/4 "2018-11-19T07:26:03Z")
I have tried so many different date formats without any success. I tried what you recommended (dd/mm/yyyy) and it seems to have worked.
Now I have to try it on the whole sheet to see if I have success. Thank you!
---
### Author:  [@raj\_nann](https://forum.manager.io/u/raj_nann)
#### Post date: [November 19, 2018, 8:13am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/5 "2018-11-19T08:13:47Z")
Please let us know if you find any solution
thank you
---
### Author:  [@WildTZ](https://forum.manager.io/u/WildTZ)
#### Post date: [November 21, 2018, 5:34am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/6 "2018-11-21T05:34:40Z")
It worked once I tried the opposite date format (changed it in excel and in manager). I still can’t make the original format work, but doesn’t really matter.
I tried several different formats (but all with year first) and I couldn’t make any of them work. Once I tried dd-mm-yyyy or dd/mm/yyyy) it imported it no problem.
.csv seems to be working fine so not sure where you got the information that it’s no longer working.
The first issue was that my excel wouldn’t save .csv with “,” separators so had to do “find & replace”.
---
### Author:  [@raj\_nann](https://forum.manager.io/u/raj_nann)
#### Post date: [November 21, 2018, 5:38am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/7 "2018-11-21T05:38:58Z")
can you show me a screenshot of your first line of csv file please
---
### Author:  [@WildTZ](https://forum.manager.io/u/WildTZ)
#### Post date: [November 21, 2018, 5:41am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/8 "2018-11-21T05:41:29Z")
Here it is. What is your issue?
---
### Author:  [@raj\_nann](https://forum.manager.io/u/raj_nann)
#### Post date: [November 21, 2018, 6:20am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/9 "2018-11-21T06:20:02Z")
few days back when i tried , it was not working
i read in some forum that csv was creating problems so they planning to stop importing csv format.
but now its working and it makes my life easier.
so thank you
---
### Author:  [@elouera](https://forum.manager.io/u/elouera)
#### Post date: [November 26, 2018, 2:12am UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/10 "2018-11-26T02:12:18Z")
Hope you got it all sorted. I haven’t had any trouble downloading CSV file to Excel but in early days I had to get help with the date & column headings so that I could import. No trouble now - each time I download CSV to Excel I then put headings across the columns: DATE- PAYEE- DESCRIPTION- REFERENCE- AMOUNT (making sure the info is actually in description column which is what Manager uses for bank rules), highlight the Date column and change to dd/mm/yyyy and delete the last column which is the running bank balance column and not needed.
---
### Author:  [@Ealfardan](https://forum.manager.io/u/Ealfardan)
#### Post date: [January 18, 2023, 2:49pm UTC](https://forum.manager.io/t/cant-import-csv-bank-statement-due-to-date-format-issue/19182/11 "2023-01-18T14:49:40Z")