# Difficulty with .csv import

**URL:** <https://forum.manager.io/t/difficulty-with-csv-import/12175>\
**Category:** Uncategorized\
**Created:** [October 13, 2017, 10:08am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175 "2017-10-13T10:08:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [October 13, 2017, 10:08am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/1 "2017-10-13T10:08:17Z")

</div>

Hi, I don’t realy understand why I cannot import my csv bank statement. Here are the first few lines:

```
> Date,Payee,Reference,Description,Amount
> 04/05/2017,,,GBD04057H9BDA740 001000 53824WA00IA6 8727576 XXXX 000000 S103,-650.00 
> 10/05/2017,,,GBD100578WBX3RLS 001000 70414WG01BPW 9053160 XXXX 000000 O TEST S103,-1200.00

```

I always get: “Date in CSV file must be in format dd/mm/yyyy or mm/dd/yyyy”

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 13, 2017, 10:15am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/2 "2017-10-13T10:15:36Z")

</div>

You can send me the whole file to `lubos@manager.io` and I can have a look.

My guess would be that one row doesn’t have a date in correct format.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [October 13, 2017, 10:21am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/3 "2017-10-13T10:21:16Z")

</div>

just sent. thanks a lot

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 13, 2017, 10:30am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/4 "2017-10-13T10:30:52Z")

</div>

Your CSV file is not valid because your descriptions contain LF (line feed) character without being properly escaped.

It’s actually quite common issue but it is not Manager fault. For this reason, in near future it will not be possible to import CSV files at all. Instead you will need to copy & paste your transactions from some spreadsheet program which will make this issue go away. Spreadsheet programs will correctly escape new line characters during copy/paste operation so Manager receives valid data.

For the time being, when you export your spreadsheet into CSV format, spreadsheet program should do the right thing and properly escape new line characters within cells.

---

<div class="post-metadata">

**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\
**Post date:** [October 13, 2017, 10:51am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/5 "2017-10-13T10:51:25Z")

</div>

How can I remove them from the file? I need to find a quick solution and to import it right now…

Thanks a lot

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [October 13, 2017, 11:00am UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/6 "2017-10-13T11:00:28Z")

</div>

Open your bank statement in spreadsheet program (e.g. Excel), then `Save as` CSV file. Try to import that CSV file.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:24pm UTC](https://forum.manager.io/t/difficulty-with-csv-import/12175/7 "2023-01-18T15:24:12Z")

</div>