# Import invoices **URL:** \ **Category:** Uncategorized\ **Created:** [November 4, 2021, 4:13pm UTC](https://forum.manager.io/t/import-invoices/37794 "2021-11-04T16:13:25Z")\ **Posts on this page:** 14\ **Page:** 2
**Author:** ![alasdair](https://avatars.discourse-cdn.com/v4/letter/a/fbc32d/32.png) [@alasdair](https://forum.manager.io/u/alasdair)\ **Post date:** [November 9, 2021, 2:51am UTC](https://forum.manager.io/t/import-invoices/37794/21 "2021-11-09T02:51:55Z")
Format - do this. Create a multi line invoice or three directly in a manager test business with whatever detail you need. Go to invoices and select batch update then copy to clip board. Paste that into a spreadsheet. That’s the format you need to get things in to import. Good luck! ---
**Author:** ![Morne\_Kruger](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/morne_kruger/32/28437_2.png) [@Morne\_Kruger](https://forum.manager.io/u/Morne_Kruger)\ **Post date:** [November 10, 2021, 7:31pm UTC](https://forum.manager.io/t/import-invoices/37794/22 "2021-11-10T19:31:57Z")
Apart from the last column, Key, which should be excluded from Batch Create. ---
**Author:** ![Genti\_Ge](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/genti_ge/32/14096_2.png) [@Genti\_Ge](https://forum.manager.io/u/Genti_Ge)\ **Post date:** [May 25, 2022, 4:06pm UTC](https://forum.manager.io/t/import-invoices/37794/23 "2022-05-25T16:06:40Z")
> [@cloudphone](#): > > If the csv format for multi line invoices was available I’d give it a go but referencing a guide that doesn’t mention what I needed is of little help frankly i was convinced that you could batch create invoces, wanted to create some using batch create and the guy was right. **every invoice in the batch update has only 1 line .** these invoices have multiple items and prices but in batch update they have only 1 line of the first item in the invoice @Tut ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [May 25, 2022, 4:23pm UTC](https://forum.manager.io/t/import-invoices/37794/24 "2022-05-25T16:23:33Z")
The multiple lines have to be one cell on the invoice line The easiest way to see how to do this is to create sample invoices with multiple lines, then use Batch Update to export to Excel and examine the resulting format ---
**Author:** ![Genti\_Ge](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/genti_ge/32/14096_2.png) [@Genti\_Ge](https://forum.manager.io/u/Genti_Ge)\ **Post date:** [May 25, 2022, 6:56pm UTC](https://forum.manager.io/t/import-invoices/37794/25 "2022-05-25T18:56:38Z")
> [@Joe91](#): > > create sample invoices with multiple lines, then use Batch Update to export to Excel and examine the resulting format tried it, didnt work the batch update onlyshows 1 line, the first one of the invoice not the others ---
**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:** [May 25, 2022, 7:40pm UTC](https://forum.manager.io/t/import-invoices/37794/26 "2022-05-25T19:40:34Z")
It shows, use wrap text to view the multiple lines. ![Screenshot_20220525-223720~2](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/8/78b72552de4caf1567be175376df373dd87b9de5.png) They’re separated by a carriage return followed by line feed special characters, which spreadsheets don’t display until you use wrap text. ---
**Author:** ![Genti\_Ge](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/genti_ge/32/14096_2.png) [@Genti\_Ge](https://forum.manager.io/u/Genti_Ge)\ **Post date:** [May 25, 2022, 8:38pm UTC](https://forum.manager.io/t/import-invoices/37794/27 "2022-05-25T20:38:53Z")
Would have never guessed that, Thank you i will check this as soon i go to office. Thank you again But is somewhat limiting when you are making batch create. How you adapt multiple lines from spreadsheet to go in a single wrapped cell… Formulas are are not helpful here 🤔 ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [May 25, 2022, 8:55pm UTC](https://forum.manager.io/t/import-invoices/37794/28 "2022-05-25T20:55:33Z")
Yes they are, but it would require a little bit of programming ---
**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:** [May 25, 2022, 9:04pm UTC](https://forum.manager.io/t/import-invoices/37794/29 "2022-05-25T21:04:09Z")
If you’re using latest excel, you can use the `TEXTJOIN` function, else you can concatenate by placing `&char(13)&char(10)&` in between text strings. ---
**Author:** ![Genti\_Ge](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/genti_ge/32/14096_2.png) [@Genti\_Ge](https://forum.manager.io/u/Genti_Ge)\ **Post date:** [May 25, 2022, 9:38pm UTC](https://forum.manager.io/t/import-invoices/37794/30 "2022-05-25T21:38:40Z")
Once again i will scuba dive into the depth of excel formulas ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [May 26, 2022, 1:48am UTC](https://forum.manager.io/t/import-invoices/37794/31 "2022-05-26T01:48:01Z")
> [@Ealfardan](#): > > you can concatenate by placing `&char(13)&char(10)&` in between text strings. I thought Manager batch operations used - Carriage return ie char(13) as the record separator - eg between invoices - Line feed ie char(10) as a line separator - eg line items within an invoice ---
**Author:** ![Yaser](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/yaser/32/43236_2.png) [@Yaser](https://forum.manager.io/u/Yaser)\ **Post date:** [May 26, 2022, 9:10am UTC](https://forum.manager.io/t/import-invoices/37794/32 "2022-05-26T09:10:23Z")
1 Day you can finish all with the minimum effort if it is in an excel sheet Usually, I upload it to the invoice screen using an external program (invoice by invoice), and each invoice is more than 300 lines which takes 1 minute for each invoice or even less. If you like to go for this way please let me know! ---
**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:** [May 26, 2022, 2:26pm UTC](https://forum.manager.io/t/import-invoices/37794/33 "2022-05-26T14:26:14Z")
> [@Patch](#): > > Carriage return ie char(13) as the record separator - eg between invoices I’m sure it’s CR/LF – at least in all the servers I’ve used so I assume that this could be the case everywhere. You can test this by pasting the batch in a text editor that can show special characters. > [@Patch](#): > > Line feed ie char(10) as a line separator - eg line items within an invoice I can confirm that. ---
**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:** [July 5, 2026, 8:13pm UTC](https://forum.manager.io/t/import-invoices/37794/34 "2026-07-05T20:13:14Z")
Closed on July 5, 2026, 8:13pm UTC Uncategorized topics older than 3 years with no recent activity [Previous page](https://forum.manager.io/t/import-invoices/37794.md?page=1)