Import CSV Bills & Invoices - Notes field

JP Liew jpliew at
Wed Jun 18 08:04:12 EDT 2014

Hi Mike,

Thanks for your reply.

I tried \n at the notes field but it just got imported as 


below is my test data

"tt163175101012","13/04/2014","000003","","test\nnotes\nline3","13/04/2014","Arduino Compatible board with Ethernet plus socket for XBee,nRF24L01+ and SDCard","Material","Income:Sales","1","25","","","","1","1","GST Received","","13/04/2014","","",""

Also thanks for your code, will take a look.


 From: Mike Evans <mikee at>
To: gnucash-devel at 
Sent: Wednesday, June 18, 2014 9:12 PM
Subject: Re: Import CSV Bills & Invoices - Notes field

On Wed, 18 Jun 2014 01:36:04 -0700

JP Liew <jpliew at> wrote:

> Hi all, 
> I did a search and was not able to find an answer to my question. 
> Basically, I would like to write an eBay or Paypal sales to GnuCash 
> invoice converter that will export eBay/PayPal sales to GnuCash CSV file that 
> can be imported by the "Import Bills & Invoices".  The prototype 
> works ok except I was not able to figure out how to deal with multi-line
>  Notes. 
> In GnuCash, a user can type multi-line notes, however in CSV, I 
> was not able to find a way to code the CR / LF in the Notes field. 
> If anyone has done this before, could you share some lights please?
> If not, can any let me know the actual src that is dealing with the part of the import please? 
> Cheers 
> John 
Hi John.

You should just be able to insert '\n' where you want the newline.

Regarding e-bay to invoices, I wrote a utility to create Bills from ebay purchases, there may be something useful in there.

Mike E

Anti NSA?  Use PGP.  

gnucash-devel mailing list
gnucash-devel at

More information about the gnucash-devel mailing list