[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