OneClickToQIF consists of a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by programs such as GnuCash, Money and Quicken. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
docs
vbasic
xlsx_templates
LICENSE
README.md
accounts.xlsm
payrolls.xlsm

README.md

OneClickToQIF is a project consisting of a series of spreadsheet templates and macros, which are used to export data (such as bank accounts, mortgage ...) to QIF format, used by programs such as GnuCash, Money and Quicken.

With OneClickToQIF you can export, in just one click, all the tabs in your spreadsheet, both for simple and split transactions.

You can use the templates provided, or easily adapt your own existing spreadsheet, without any knowledge of macros. Every tab is automatically exported from the spreadsheet to QIF files, both assets (bank accounts, cash ...) and liabilities (credit cards, mortgage ...).

You do not need to indicate each time the columns containing data, or the transactions to be exported: just label the columns the first time you use the template. Only new movements (those who have never been exported) will be exported to the QIF file.

License

OneClickToQIF is licensed GNU GPL v3: You can use the software free of charge study, share and modify.

See details: https://github.com/OneClickToQif/OneClickToQif/blob/master/LICENSE

How to get help

About the project

[Why did you create this project? Why should I use it?] (https://github.com/OneClickToQif/OneClickToQif/wiki/About-the-project)

[How to join the project] (https://github.com/OneClickToQif/OneClickToQif/wiki/About-the-project)

Alternatives to OneClickToQIF

Using the spreadsheet templates

[Where do I start?] (https://github.com/OneClickToQif/OneClickToQif/wiki/Using-the-spreadsheet-templates)

[How to download bank account transactions and export them to QIF] (https://github.com/OneClickToQif/OneClickToQif/wiki/Using-the-spreadsheet-templates)

[What are the "auxiliary formulas" columns?] (https://github.com/OneClickToQif/OneClickToQif/wiki/Using-the-spreadsheet-templates)

[How can I re-export a set of transactions?] (https://github.com/OneClickToQif/OneClickToQif/wiki/Using-the-spreadsheet-templates)

Adapting your own spreadsheet to export data

[Simple vs. Split Transactions] (https://github.com/OneClickToQif/OneClickToQif/wiki/Adapting-your-own-spreadsheet-to-export-data)

[How to adapt a spreadsheet with simple transactions] (https://github.com/OneClickToQif/OneClickToQif/wiki/Adapting-your-own-spreadsheet-to-export-data)

[How to adapt a spreadsheet with split transactions] (https://github.com/OneClickToQif/OneClickToQif/wiki/Adapting-your-own-spreadsheet-to-export-data)