Title: CSV Import
Last modified: March 12, 2019

---

# CSV Import

 *  [auctionworks](https://wordpress.org/support/users/auctionworks/)
 * (@auctionworks)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/csv-import-41/)
 * I’m having trouble with importing a CSV file, particularly when there are multiple
   line items. I cannot get the CSV file to import without an error about there 
   being too many pipe symbols. The CSV file is formatted as explained on the “Import
   CSV” page and is identical to the sample file provided. Any assistance would 
   be greatly appreciated, thanks!

Viewing 1 replies (of 1 total)

 *  [Andrew Reva](https://wordpress.org/support/users/ndrwrv/)
 * (@ndrwrv)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/csv-import-41/#post-11331266)
 * Hello there
 * I agree the CSV file is difficult sometimes to maintain because when you have
   a big table you physically cannot read everything. And the worst thing is that
   it requires you to keep using correct delimiters between cells (commas “**,**“)
   and rows (**CR/LF**). And if you use long strings with space characters, they
   should be wrapped with quote symbols (‘**“**‘) because if not, they could be 
   split into several cells. The worst thing is that you have to follow the rules
   globally for the whole file and sometimes it won’t work while visually the document
   could look good. So please pay a little more attention and make sure the CSV 
   is really ok.
 * My best,
    Andrew

Viewing 1 replies (of 1 total)

The topic ‘CSV Import’ is closed to new replies.

 * ![](https://ps.w.org/sliced-invoices/assets/icon.svg?rev=1314180)
 * [Sliced Invoices - WordPress Invoice Plugin](https://wordpress.org/plugins/sliced-invoices/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sliced-invoices/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sliced-invoices/)
 * [Active Topics](https://wordpress.org/support/plugin/sliced-invoices/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sliced-invoices/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sliced-invoices/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 1 reply
 * 2 participants
 * Last reply from: [Andrew Reva](https://wordpress.org/support/users/ndrwrv/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/csv-import-41/#post-11331266)
 * Status: not resolved