[GNC] New CSV Import Wiki Entries

Michael or Penny Novack stepbystepfarm at comcast.net
Sun Aug 16 18:07:51 EDT 2026


On 8/16/2026 12:22 PM, Patrick James via gnucash-user wrote:ou
> For various reasons, new users have struggled with the CSV import of transactions. I looked back at the various questions, and while there is no single magic solution, I decided to write a Guided CSV Import. The strategy is to start with known CSV data, as published on the Wiki page, a clean GnuCash file and import the data both non-multi-split and multi-split.
>   
> If someone is struggling with a first CSV import, this guided tour will probably answer the questions of where things are going wrong.
>   
> https://wiki.gnucash.org/wiki/Guided_CSV_Import

Might I add a perhaps useful tip? The csv format ONLY specifies that the 
fields of each record will be delineated by commas. It does NOT specify 
the order of the fields of each record. Therefore ......

FIRST do an export of transactions to csv. Almost all applications 
export records with fields in the order they expect when importing. If 
you know (from gnucash) what the amounts/dates/accounts/etc. of the 
transactions you exported you can look at the records in the file you 
exported to learn what the order of fields is.

THEN look at the file you want to import/ Same order? Different order? 
If different you will need to reorder the data.

Michael D Novack




More information about the gnucash-user mailing list