Time for action – exporting data from GnuCash for migration and other purposes
Let us say you are trying to migrate to another accounting and bookkeeping software. That software requires either a CSV file or a QIF file for importing. In this tutorial, we will see how to create a CSV file of all the transactions in GnuCash:
Prerequisites: Make a backup of your accounts data file first.
From the menu, select Reports | Transaction Report. Open the Report Options dialog and unselect Totals, Subtotals, Account Name, and Secondary Keys, leaving only the main headers other than the transactions. The Transaction Report will now appear as shown in the following screenshot:
From the menu, select File | Export | Export Report to export that report as an HTML file.
Open this HTML file in your favorite spreadsheet program.
Delete all the header rows, leaving only the transaction data. Select the amount column. Change the format so that the 1000 separator comma is removed. Save this file first in the spreadsheet...
