Re: [GNC] New CSV Import Wiki Entries
Michael or Penny Novack via gnucash-user <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnucash.user |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.