A file will not import
Most files that will not import are the wrong file, not a broken one, such as a summary instead of the full history, a PDF, or a file from another source. The import says what is wrong, and Generic CSV reads almost any CSV when nothing else does.
What the import says, and what to do
| The import says | What it means, and what to do |
|---|---|
| Could not parse the file as a Trading 212 export. Try Generic CSV, or pick a different source. | The file is not one this source reads. Check the source you picked. When another source knows the file, a note says which source it looks like, with a Switch to button. |
| No rows were extracted from this file. | The file is not the export the source needs. The reason follows, such as "DEGIRO: this is the Transactions export, which lists trades only." Export the file it names. |
| The first line of your file should name its columns, and it names none. | A Generic CSV needs a header row. Export the file again with its column names. |
| Your file names its columns but has no lines under them. | The export is empty. Export it again, with your transactions. |
| ASML would go below zero, so nothing can be imported yet | A line sells or moves out more than you held that day. The file usually starts after your first purchases. Import from the start, or add the earlier purchases first. When an order that filled at several prices came in as separate lines, the review names that as the likely cause: see A transaction shows twice. |
| File exceeds 10,000 row limit | A Generic CSV takes 10,000 lines at most. Split the file into parts of up to 10,000 lines and import the oldest first: see Generic CSV. |
| This import adds 80 portfolio transactions, and your plan has room for 30 more. Upgrade to import it. | The file does not fit your plan. See plans, in place of Import, shows the plans that hold it. |
| Nothing new to import: it is all here already, or left out. | Not an error. Everything in the file is already in your workspace, or you left it out. |
| An error has occurred. Check your internet connection and reload the page. | Reload the page and try again. The code at the end helps if you ask for help. |
The wrong file from your broker
Most brokers offer several exports. The import needs the full history of your transactions, not a summary, a list of positions or a tax report. The card How to get it, under the drop zone, gives the steps for your broker. The first time, export your whole history.
Upload the file as your broker wrote it. Opened and saved again in a spreadsheet app, a file can change how it writes its dates and numbers. The one exception is a workbook from ING Bank Romania, Raiffeisen Bank Romania or XTB that the app cannot open: it says so, such as We couldn't read this ING workbook directly., and asks you to open it in Excel or LibreOffice, save it as a new .xlsx file and upload that one.
Files a source turns away
When the file is not the one a source reads, the File step says No rows were extracted from this file., followed by the source's reason. The reason names what the file is, and what to export instead:
| The reason starts | Export instead |
|---|---|
| Bitvavo: this is the export Bitvavo wrote until mid-2022, which splits each trade over two rows with no price. | The transaction history again: Bitvavo writes your whole history in today's layout. |
| eToro: this statement is in a layout eToro stopped using in 2022, without the number of units bought. | The account statement again: today it covers the same dates in the current layout. |
| eToro: this statement is in another language. | Switch the eToro site to English, then download the statement again. |
| This Swissquote file is in a language this import does not read yet. | Set Swissquote's display language to English and export again, or bring the file in with Generic CSV. |
| Charles Schwab: this is the Equity Awards history, which this import does not read. | The brokerage account's history, where vested shares show as Stock Plan Activity. |
| Charles Schwab: this is a bank account history, which this import does not read. | The brokerage account's history; the bank account goes into the Wallet with Generic CSV. |
| Charles Schwab: this is not a brokerage account's transaction history | The brokerage account's history, from Accounts, then History, then Export: positions and realized gain and loss are other files. |
| Coinbase: this is a Coinbase Pro report (fills or account), which this import does not read yet. | The transaction history from accounts.coinbase.com/statements. |
| Crypto.com: this is the Cash Wallet's history., or the card's | The Token Wallet's history: it has every coin you bought or sold, with a card or the Cash Wallet too. |
| Revolut: this is not the investment account's statement | The investment account's Account statement, as Excel. A bank statement goes into the Wallet; the profit and loss statement is another file. |
| Tastytrade: this is not the transaction history | Activity, then Transactions: the Year-To-Date export and the tax worksheet are other files. |
| Trade Republic: this looks like a file from pytr, not from Trade Republic. | The Transaction export from Trade Republic itself. |
| This is a CSV export from Portfolio Performance, which this import does not read | All transactions (JSON), from the export button of All transactions. |
| Investimental: this is ArenaXT's and the report's name | The Trades report (Tranzactii), the Activity report (Activitate) or the Orders Daily Log (Istoric Ordine). |
| BCR: this is George's transaction history export (Istoric tranzactii), not the account statement this import reads. | The account statement, from Extrase de cont, as CSV. |
| Wise: this is the list of transfers (Transactions, download), not a statement | A statement, from Statements and reports, one currency at a time. |
| YNAB: this is the plan's monthly budget alone. | The export's ZIP as it is. |
| OFX: this is an investment account statement, not a bank or card statement. | The bank or card account's file. Investments come in with your broker's own file. |
| Wise: this is a ZIP of statements. Unzip it and import each currency's file. | Each currency's file from the ZIP, one at a time. |
| OFX: this is a QIF file, an older Quicken format. | OFX, which banks also call Money (.ofx) or Quicken Web Connect (QFX). |
| OFX: this is an OFC file, the format OFX replaced. | OFX, QFX or QBO. |
| CAMT: this ZIP could not be opened., or the same for OFX | The file again, downloaded afresh from your bank. |
| OFX: the file holds the bank's error instead of transactions | The transactions again. |
| No transactions could be read from this IBKR Flex Query. | The Flex Query again, with Select All ticked in each section. |
| Salt Bank: this file has no Amount column, so none of its lines can be read. | The statement as the Salt app writes it, with its Amount (RON) or Amount (EUR) column. |
The steps for the right file are under How to get it for each source, and in Imports, broker by broker.
A PDF
The import does not read PDF statements. The drop zone names the file types a source takes, such as CSV, Excel, OFX or XML. Your broker or bank almost always offers one of those beside the PDF.
The wrong source
Each source reads its own broker's or bank's files. Picked the wrong one? Press Back and choose again. A bank statement goes under Bank statements, into the Wallet, and an investment account's file under Investments.
Plan limits
Every plan can import, and you always see what a file brings before anything is saved. The import checks the file against your plan, and says when it does not fit. On the Free plan that is 50 portfolio transactions, 120 wallet transactions, 10 assets, 10 categories and 10 tags in all, and an account or a broker the import adds must fit within 3 accounts and 2 brokers.
When nothing else works
Choose Generic CSV at the bottom of the list, under Not in the list?. You say whether the file holds investments or a bank statement, then match its columns by hand: for investments, the date, type, ticker, shares, price, amount and broker.
Good to know
The file is read on your device, and no line is saved until you press Import on the review.
Lines a reader could not use are listed under Notes on your file, with the reason. The rest can still come in. What each note means: The notes on your file.
The error box links to the community. Name the broker and the file type, never paste the file or amounts.