Difference between revisions of "CSV Import/Export"
(tx import window) |
(list of items that can be imported) |
||
| Line 7: | Line 7: | ||
The CSV importer has been enhanced for GnuCash v3, allowing customization of the importer. One can now select specific fields from a .csv file and map them to the values of the resulting Split. | The CSV importer has been enhanced for GnuCash v3, allowing customization of the importer. One can now select specific fields from a .csv file and map them to the values of the resulting Split. | ||
Several different formats, for numbers and dates, are available to choose from. | Several different formats, for numbers and dates, are available to choose from. | ||
| + | |||
| + | Accounts, transactions, and commodity prices can be imported from CSV files. | ||
More specs to be added after testing and writing a CSV exporter library. | More specs to be added after testing and writing a CSV exporter library. | ||
| + | |||
| + | === Importing Accounts === | ||
| + | |||
=== Importing Transactions === | === Importing Transactions === | ||
| Line 22: | Line 27: | ||
* description | * description | ||
* deposit/withdrawal | * deposit/withdrawal | ||
| + | |||
| + | === Importing Prices === | ||
| + | |||
== Export == | == Export == | ||
TBA | TBA | ||
Revision as of 17:15, 3 March 2019
This page will contain the information specific to import and export of CSV-formatted data into and out of GnuCash. More specifically, it will related to the current production version of GnuCash, which is v3.4 at the time of writing.
A MasterCard-specific issues are handled in a separate page.
Import
The CSV importer has been enhanced for GnuCash v3, allowing customization of the importer. One can now select specific fields from a .csv file and map them to the values of the resulting Split. Several different formats, for numbers and dates, are available to choose from.
Accounts, transactions, and commodity prices can be imported from CSV files.
More specs to be added after testing and writing a CSV exporter library.
Importing Accounts
Importing Transactions
This is the CSV import for transactions window: https://imgur.com/F17CZwK
It allows setting the destination account, column separator character, date format, file encoding, currency format, number of lines to skip at the beginning or the end of the file, column mapping.
The mandatory fields are:
- date
- account
- description
- deposit/withdrawal
Importing Prices
Export
TBA
