Text File Importer Extension
The CSV (comma separated values) format is essentially a table of rows and columns, like a spreadsheet. It is very versatile and not specifically designed to contain financial information.
As such there is no standard way for a bank to store data in such a file. There is no standard order for the columns in a CSV file or names for those columns.
As a result of this the import process for CSV files is much more involved that any other standard format.
For this reason, we recommend using either OFX, QFX, OFC or QIF files for importing your data whenever possible. OFX and QFX files are the best format, with QIF files being the second best and CSV files being a distant third.
The 'Text File Importer' extension allows you to specify which columns in a CSV file should correspond to which fields in a Moneydance transaction.
To install the Text File Importer extension, navigate to Extensions -> Manage Extensions and install the extension there. If you purchased Moneydance from the Mac App Store, then you can go here to download the extension, then drag and drop it onto the Moneydance window to install it.
Once you have installed the "Text File Importer" extension, select Extensions --> Text File Importer.
A window will open, allowing you to browse to the CSV file you want to import. Navigate to the CSV file and select it to begin the import process.
You'll be given the option to select the file encoding from these options:
In most cases, you can leave it to the default option. Click Next to continue.
In the next window, specify the account you want to import the data into.
Select the Fields Delimiter from these options -
[tab] [space] [,] [.] [/]  [-] [_] [*] [~] [;]
This is the character that's used in your CSV file to separate the fields. Comma is quite common and so is tab, but if you're using something different you can specify that as well. If you're unsure, select comma.
You may also need to change the date format to that used in the file. To do so, select the Date Format from the following options -
MDY, DMY, YMD, YDM
After that, specify either a period '.' or comma ',' as the decimal used in the file and click Next.
The next window displays a list of fields. Each of these fields represents a column in the CSV file.
E.g. "Field 1" is the first, left most column in the file. "Field 2" is column 2, to the right of the first column, and so on..."
You need to select the Moneydance transaction field that corresponds with the column in the CSV file.
To do this we suggest opening your CSV file in a spreadsheet program to see which column is which, and use that as a reference to match the different field values to the corresponding columns in the CSV file.
Use the "More Fields" and "Fewer Fields" buttons to adjust the number of fields to import, corresponding to the number of columns in your CSV file.
You should remove any unnecessary fields, rather than assigning as 'Ignore'.
Then, for each field/column, select the transaction field in Moneydance that the column value corresponds to from these options -
Account (this is "Category" in the register)
Amount (positive for deposit, negative for payment)
Click "Finish" to import the file.
The Text File Importer supports dates in the format of XX/YY/ZZ and XX/YY/ZZZZ. If your dates are in a format that includes letters (Jan-1-2015, for example), the Text File Importer will not be able to recognize your dates. You'll have to change the format in a spreadsheet program to a format that the Text File Importer can recognize.
If your CSV file has your credits and debits in one column, and another column that specifies whether the row is a debit or credit - you'll have to adjust the amount column in your CSV file to make the credits negative (with a minus sign in front of them).
If your CSV file has credits and debits in two columns, then you'll have to merge the columns into one to be able to import it with the 'Text File Importer' extension, or use the 'CSV Importer' extension to try importing the data.
- Archive - Moneydance 2017 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2017 from Moneydance 2012, 2014 and 2015
- Archive - Upgrading to Moneydance 2017 from Moneydance 2011 or earlier
- Archive - Changing colours and theme in Moneydance 2017
- Archive - Sharing data using the Moneydance 2017 syncing engine
- View all (15 more)
- Archive - Moneydance 2015 license keys and upgrade policy
- Archive - Upgrading to Moneydance 2015 from Moneydance 2012 and 2014
- Archive - Upgrading to Moneydance 2015 from Moneydance 2011 or earlier
- Archive - How to restore from a checkpoint in Moneydance 2012 and 2014
- Archive - Opening a backup file in Moneydance 2015
- View all (3 more)
- Archive - Does Moneydance allow for assigning 'classes' to transactions?
- Archive - How do I get the Register to auto fill todays date instead of the last entered date?
- Archive - How do I move a transaction to a different account?
- Archive - How do I enter my Paycheck?
- Archive - How do I create a split transaction?
- View all (2 more)
- Archive - Syncing Moneydance 2015 with your Mobile Device
- Archive - Syncing Moneydance 2012 and 2014 with your Mobile Device
- Archive - How to sync with Moneydance 2008, 2010, and 2011
- Archive - How do I delete a transaction on the iPhone, iPad, or iPod touch?
- Archive - How to sync one data file with multiple iOS devices using different Dropbox accounts
- View all
- Archive - Creating a budget using the 'Newer' format
- Archive - Creating reminders (automatic repeating transactions or notes)
- Archive - Creating a budget using the 'Mixed Interval' (Older) format
- Archive - What's the difference between a General and Transaction reminder?
- Archive - How do I have a reminder automatically entered into my register?
- View all (1 more)
- Archive - Setting up VAT/GST
- Archive - Can you change the word "Check" to "Cheque" anywhere in the programme?
- Archive - How can I enter the exact amounts on both sides of a foreign currency transfer?
- Archive - My household/country/company uses a fiscal year instead of a calendar year. Can I do this in Moneydance?
- View all
- Archive - How do I add Securities to a new Investment Account?
- Archive - How can I import security, stock or mutual fund prices?
- Archive - Entering your current holdings
- Archive - Creating a new investment subtype
- Archive - Fixing mismatched securities from downloads in investment accounts
- View all (6 more)