[GNC] Column Detection when Importing Transactions from CSV

Stephen M. Butler kg7je at arrl.net
Wed Jun 26 18:18:46 EDT 2019


On 6/26/19 12:31 PM, Patrick wrote:
> When importing transactions from a CSV file, is there a way to have GnuCash
> automatically detect the meaning of the columns based on the CSV headers?
> The headers in my CSV file are "Date", "Description", "Account", etc., so I
> was wondering if GnuCash had the ability to determine what the columns were
> from these headers, so that I don't have to select them from the dropdown
> menus every time I do an import.
>
> Regards,
> Patrick


The screen where you pick these has a field at the very top where you
can name this setup and then save it.

You will have to select this name on the next import but it will remember:

* The field assignments

* The account into which you are doing the import

* The date format

* How many lines to skip

It was a big help when I discovered that!

--Steve


-- 
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8



More information about the gnucash-user mailing list