Difference between revisions of "User:Jeremy Butler"
From GnuCash
(→Things for me to remember about GnuCash: formatting) |
(→Things for me to remember about GnuCash) |
||
| Line 6: | Line 6: | ||
:One way to easily export GnuCash data to Excel is to find a report (such as the General Ledger) that you can adjust to a satisfactory output, and export the report to an HTML file. Then open the HTML file from Microsoft Excel. (Using File>Open from within Excel, selecting "html" as the file type.) The Excel program will load the report into a spreadsheet, allowing filtering and other spreadsheet functions. | :One way to easily export GnuCash data to Excel is to find a report (such as the General Ledger) that you can adjust to a satisfactory output, and export the report to an HTML file. Then open the HTML file from Microsoft Excel. (Using File>Open from within Excel, selecting "html" as the file type.) The Excel program will load the report into a spreadsheet, allowing filtering and other spreadsheet functions. | ||
| + | |||
| + | '''[[FAQ#Q:_What.27s_the_gnucash_file_extension.3F|File Extension?]]''' | ||
| + | |||
| + | :GnuCash does not enforce any particular file naming convention or extension. However, the following extensions are described in the "shared-mime-info" package used by almost every distro and desktop environment to associate applications with files. Naming your datafile with one of these extensions will allow the gnucash to be opened when a file is seen and activated in a file browser. | ||
| + | :*.xac (short for "X-Accountant", the predecessor of GnuCash), still in use for your backup files, | ||
| + | :*.gnc (the "internal" three-letter-abbreviation of GnuCash) | ||
| + | :*.gnucash (recommended and the only one that works on Windows) | ||
Latest revision as of 02:09, 4 April 2010
I began using GnuCash on 3 April 2010, having gotten fed up with Micro$oft Money's approach to financial software.
Things for me to remember about GnuCash
- One way to easily export GnuCash data to Excel is to find a report (such as the General Ledger) that you can adjust to a satisfactory output, and export the report to an HTML file. Then open the HTML file from Microsoft Excel. (Using File>Open from within Excel, selecting "html" as the file type.) The Excel program will load the report into a spreadsheet, allowing filtering and other spreadsheet functions.
- GnuCash does not enforce any particular file naming convention or extension. However, the following extensions are described in the "shared-mime-info" package used by almost every distro and desktop environment to associate applications with files. Naming your datafile with one of these extensions will allow the gnucash to be opened when a file is seen and activated in a file browser.
- .xac (short for "X-Accountant", the predecessor of GnuCash), still in use for your backup files,
- .gnc (the "internal" three-letter-abbreviation of GnuCash)
- .gnucash (recommended and the only one that works on Windows)
