Import your accounts, categories, tags or brokers from a file
Each list in Settings has an Import button that reads a CSV file: match its columns, name the kinds and currencies, check the review, then import.
Press Import on a list
In Settings, open the list you want to fill, Accounts, Categories, Tags or Brokers, and press Import at the top of it. A panel opens over the page, with the step you are on at the top, such as Step 1 of 6 and Upload for accounts. With no account yet, Or import them from a file on Accounts opens it too.
Add your file
The first step says Add your CSV file: Any CSV with a header row: you match its columns next. Drop the file on Drop your CSV file here, or click there to choose it. It is read on your device and never uploaded: Processed locally on your device. Press Continue to go on to the columns. Nothing is saved yet.
Match the columns, kinds, currencies and tags
Match your file's columns shows each field with the column of your file it reads, picked by the column's name when it looks alike. A field on Select column reads nothing yet: pick its column there. Accounts need Name, Kind and Currency, with Tag and Notes if you like. Next goes on, and Back returns.
Accounts then ask about each value your file uses. Match the kinds of account lists each type your file writes, such as Checking, with the app's kinds to pick from: Current account, Savings, Cash, Credit card, Retirement, Loan, Mortgage and Other. Match the currencies does the same for currencies. Match the tags matches each tag your file names to one of your tags: New tag adds one you do not have yet, and every tag in the file needs a match. A value that already reads like a kind, a currency or a tag you have is picked for you. Brokers ask about currencies only. Categories and tags go straight to the review.
Check the review, then import
The last step, Review, starts with a Summary. Lines in your file counts every line, and the rows under it say what becomes of them:
- New accounts: the ones that come in, with how many of each kind under it. Categories also show New groups, named under it.
- Already here: the ones you have (left out, so nothing doubles).
- Repeated in the file: lines your file lists more than once (each comes in once).
Below the summary, a card lists the new ones with their kind, currency, tags and notes. Nothing is saved until you import.
Leave out lines repeated in the file, at the foot of the summary, is on at first. Turn it off to bring in every line, repeats included. Categories have no such switch: they always leave a repeat out.
Press the button named for what comes in, such as Import 4 accounts. A message says how many came in, such as Added 4 accounts., and they join the list. When the file adds nothing, the button reads Close instead. Back goes back a step.
What each list reads
| List | Steps | Columns | Left out as a duplicate |
|---|---|---|---|
| Accounts | Upload, Columns, Kinds, Currency, Tags, Review | Name, Kind and Currency. Tag and Notes if you like | An account with the same name, kind and currency as one you have, or as an earlier line |
| Brokers | Upload, Columns, Currency, Review | Name and currency. Notes if you like | A line with the same name and currency as an earlier line. The brokers you already have are not checked, so Already here stays 0: leave them out of the file |
| Categories | Upload, Columns, Review | Name. Group and Notes if you like | A name you already have, upper or lower case alike, built-in ones included, or one an earlier line took |
| Tags | Upload, Columns, Review | Name | A tag with the same name as one you have, or as an earlier line |
A kind cannot change once the account is added, so pick it with care on Kinds.
If the import stops
A red Errors box at the top of the panel lists what stopped it, three at a time, with a line such as + 4 other errors not shown when there are more. A file too big for your plan is refused by a message at the bottom of the screen instead, with See plans.
| Message | What to do |
|---|---|
| Don't forget to upload import file | Drop a file before you press Continue. |
| We could not process column names from your file | The first line must name the columns. Add a line such as Name,Type,Currency at the top. |
| File exceeds 10,000 row limit | Split the file in two and import each. |
| Name is empty on row 3 for selected type column Name | That line has no name. Fill it in, or delete the line, and upload the file again. The same goes for a line with no kind or no currency. |
| Only 2 more accounts fit on your plan (3 total). Upgrade to add more. | The file holds more than your plan has room for, so nothing is added. Take lines out of the file, or see Plans and limits. |
Good to know
An account from a file has no starting balance. It starts counting on the day you imported it, or on its first transaction if that is earlier. Open each one to set its Starting balance and Opening date: see The opening date.
With a Group column, each new category goes into the group its line names, and a group you do not have yet is made. A category you already have is left out and keeps its group, as the review says: left out, and it keeps its group. The file never moves it.
Download as CSV saves a file each list can import back. The categories download has names and notes but no group, so add a Group column before you import it elsewhere. Tags come back by name only: their notes stay behind.
If the file does not fit your plan, the import adds none of it, so you never end up with half a list.
Worked example
Your workspace on the Free plan, which holds 3 accounts, has one already: Savings pot, savings, in EUR. Your file has five lines:
| Name | Type | Currency | What happens to it |
|---|---|---|---|
| Everyday | Current | EUR | Comes in, as a current account |
| Savings pot | Savings | EUR | Left out: you have it |
| Visa card | Credit card | EUR | Comes in, as a credit card |
| Dollar account | Checking | USD | Comes in, once you pick Current account for Checking on Kinds |
| Everyday | Current | EUR | Left out: the file repeats it |
Take one line out, such as Dollar account, and the other two come in, each at a starting balance of 0.