What to do with your old Mint transactions CSV
A practical way to bring years of Mint history into an iPhone app, with a clean-up checklist.
If you still have an old Mint transactions CSV on a laptop or in a cloud folder, it is worth more than it looks: years of categorized spending that you can import into a new app. This guide covers what to do with your Mint transactions CSV, how to clean it up, and how to import it into Vartu on your iPhone.
One honest note first: Vartu has no dedicated Mint importer. It reads any CSV, and you tell it which columns hold the date, the amount and the description. That works for a Mint file just as it does for a bank file.
What a Mint export contains
Open the file in Numbers, Excel or a plain text editor and look at the header row. Mint transaction exports have typically had columns along the lines of date, description, original description, amount, transaction type (debit or credit), category, account name, labels and notes. Your file may differ, so check it rather than trusting this list.
The columns you care about are:
- Date: check the format. US files usually show month/day/year.
- Amount: in Mint files the amount was often positive for everything, with a separate column saying whether it was a debit or a credit. If that is the case in yours, you will want to turn debits into negative numbers before import (see below).
- Description: there may be a cleaned-up name and an original bank description. Pick the one you recognize best.
- Category and account: useful for reference, even if you map only three columns.
Clean-up before importing
A few minutes in a spreadsheet saves headaches later. Keep a copy of the original file untouched, then work on a duplicate.
- Make debits negative. If the amount column is all positive and a second column says debit or credit, add a helper column that makes debits negative, then use that as your amount column.
- Look at transfers. Moves between your own accounts (checking to savings, a credit card payment) appear as two rows. Vartu does not count transfers between your own accounts as spending, but only once both sides are recognized as transfers. If your file has a clear transfer category, you can remove those rows or keep them and review them after import.
- Check split transactions. If you split one purchase across categories in Mint, the file may have several rows for one payment. Decide whether to keep the split or merge it.
- Save as CSV in UTF-8. Vartu reads UTF-8 and Windows-1252, which covers what spreadsheets normally produce. Avoid saving in a spreadsheet format such as .xlsx.
- Split big files by year if you like. It is easier to review three years one at a time than ten at once.
Choose the columns once, import, check
- Move the CSV to your iPhone (AirDrop, iCloud Drive, or email it to yourself).
- Open it from Files or Mail and choose Vartu when asked "Import this file?". Or go to Settings → Import statements inside the app. Statement importing is a Pro feature.
- Choose which columns are the date, amount and description. Vartu remembers the choice, so a second Mint file (or a later export of the same kind) needs no new setup.
- Every row is shown for checking before it is saved. Scan a few rows from the start, middle and end: dates in the right month, signs in the right direction, descriptions readable.
- Save. If something looks wrong, fix the file and import again.
Duplicates and overlapping files
If you exported Mint history in several chunks and the date ranges overlap, you do not need to trim them by hand. Vartu does not add duplicate rows from overlapping files twice. The same applies when you later import your bank's recent activity: a month that overlaps with the end of your Mint file will not double up. There is also a review screen for possible duplicates if something slipped through, for example the same purchase with a slightly different description.
Categories: use rules to re-categorize
Mint categories will not match Vartu's one to one, and that is fine. Rather than editing thousands of rows, create rules: "if the description contains this merchant, use this category." Rules apply to imported rows automatically, and Vartu suggests a category when it meets a new merchant. Start with your twenty most frequent merchants and you will have covered most of the file. Tags can hold anything that does not fit a category.
If you only wanted the history for reference, you can import it all under one account and let the totals and search do the work. Search is useful for questions like "what did we pay for car insurance in 2021?".
If you did not export in time
If you never saved a Mint file, check the usual places before giving up: old email attachments, a Downloads folder, a laptop backup, cloud storage and any app you moved to that imported your data (some services kept the Mint file you uploaded). Credit Karma was Intuit's suggested destination for Mint users, so check there for anything still available.
If the history is truly gone, you are not stuck. Your banks keep their own records, usually as downloadable statements. A year or two of CSV or PDF statements from each bank rebuilds most of what matters, and Vartu reads PDF statements too. Our US bank CSV export guide links to the help pages of the big banks, and the general import guide covers the Vartu side.
What to do next
- Import the Mint history into its own account so it is easy to tell apart.
- Add a current account and start importing recent bank files monthly.
- Build a handful of rules for your most common merchants.
- Export a full CSV from Vartu occasionally. It is always free, and it means you will never be in the position of searching for a lost file again.
Is this a Mint replacement in general? See our Mint alternative guide for what Vartu does and does not do. Nothing in this article is financial or tax advice; it is about getting your own records in order.
A few more tips
- Work on a copy of the file, and keep the original untouched in case you need to start over.
- Import one account at a time, in its own Vartu account, so the checks are easy.
- If the review screen shows a wrong sign or date, stop, fix the column choice or the file, and import again instead of correcting rows one by one.
- When you finish, glance at the totals for a month you remember well. If rent, salary and a couple of big purchases look right, the import is probably right.
To try it with your own file, install Vartu from the App Store. One spending account and one broker account are free, and your data stays on your iPhone.
On a computer?
Scan with your iPhone camera to open Vartu in the App Store.
More guides
- A Mint alternative that never links to your bank
- Track your investments on iPhone, in dollars
- A budgeting app that never links to your bank
- Import your bank CSV or PDF into Vartu
Vartu is not financial advice. Forecasts and estimates are arithmetic on your own figures.