Skip to content
TurbobullsDocs
DocsReference

Import from anywhere with Generic CSV

Generic CSV takes any CSV file whose first line names its columns, from a broker, a bank or a sheet you keep. You match its columns to what the import needs once, and the next file with the same columns is matched by itself.

A guide7 minutes
Before you start. A CSV file is a plain table saved as text, one line per row, the columns split by commas or semicolons. Most apps and spreadsheets can save one: in Excel, use Save As and pick CSV. The first line must hold the columns' names.

Pick Generic CSV

Open Import. At the end of the list, under Not in the list?, choose Generic CSV: No ready-made import for yours yet? Bring its CSV and match the columns by hand. On the All tab, pick Investments or Bank statement beside it.

ImportNot in the list?Generic CSVInvestments

Add the file

The panel reads Add your CSV file: Any CSV with a header row: you match its columns next. Drop the file, or click to choose it. It is read on your device and never uploaded.

Under the drop zone, What your file can look like shows the layouts a file can have, each with its first lines and Download this example.

Match your file's columns

The Columns step, Match your file's columns, finds most columns by their names. Check each one under What the import needs, and pick any it left for you. A column found by what it holds rather than its name says found by what it holds: check it is right, and a column with nothing in it says This column is empty in your file. With no Type column, a column of letters gets a question, such as Side holds B and S: is it the kind of line? Use it, and say what each letter means on the next screen., with Use Side. A column your file does not have can stay on Not in your file.

Under the list, the first lines are read with your choices, so a line that cannot be read says why, like Line 3 of your file. A split line says left out: splits come from market data. When the file names no broker or account, pick one for every line. With no currency column, Prices and fees are in starts on Each holding's own: each price is in its holding's currency, with fees and tax then in the broker's currency. Pick one currency there only when the whole file is in it.

For a bank statement, From and To can each take A second column, where this one is empty?, read then, where it is empty. Two columns, in and out? reads the money from a Money in and a Money out column, and One column, signed? goes back to one.

Check what it found

On Check, the import shows what the file holds and where it goes. For investments, In your file counts Trades, Dividends or Income, Holdings and Left out, such as 1 split from market data instead. The Kinds of line card shows each word your Type column uses and the kind it is read as: Buy, Sell, Dividend, Interest, Other income, Other expense, Shares moved in, Shares moved out or Split, whose lines are taken from market data instead. A word it does not know says Pick one. You can also choose Leave these lines out.

Review and import

Review before importing lists every line, with those already in your workspace marked Already here and left out. Nothing is saved until you press the button with the count, like Import 4 transactions. Next time a file with the same columns comes, they are matched as now, on this device.

Investments: the columns

ColumnNeededWhat it holds
DateYesThe day of each line.
TypeYesBuy, Sell, Dividend, Interest, Split, or your file's own words. Words like Bought, Kauf or Dividende are understood. Split lines are read, then left out: splits come from market data.
Ticker or ISINOne of themThe asset: its ticker, like ASML, or its ISIN, the 12-character code that names a security, like IE00B4L5Y983.
SharesFor tradesHow many shares were bought, sold or moved.
PriceFor tradesThe price of one share. Without it, give Amount, and each trade's price is its amount over its shares.
AmountFor dividends and interestWhat the line paid. With a Fee column and no Price, you say once whether the amount includes the fee.
BrokerYes, or one for the whole fileThe broker each line is at. Each name is matched to your brokers on Check.
CurrencyNoEach line's currency. Without it, each price is in its holding's own currency, and fees and tax in the broker's, unless you pick one currency for the whole file.
Fee, TaxNoWhat each line cost, and the tax on it.
NotesNoA note on each line.

A line your file calls Deposit, Withdrawal, Fee, Tax, Transfer, Cash in, Cash out or Top up, or the same in German, French, Spanish, Italian, Dutch or Romanian, is left out of an investments file by itself. On the Columns step it says left out unless you name it on the next screen, and on the Check its word is listed as left out under Kinds of line.

An Interest line with no ticker, such as interest on the broker's cash, is not left out: it stops the Columns step. The line says there is no ticker or ISIN, the footer says so, such as Line 7 cannot be read., and Next stays greyed. Take such lines out of the file, then add them by hand on the Broker tab of Add transaction: interest as Broker income, a fee on its own as Broker expense. Money you sent to a broker comes in through the Wallet, as money from your account to the broker, or as an Outside deposit typed by hand. A bank statement's Generic CSV with From and To columns brings many such deposits at once.

Bank statements: the columns

ColumnNeededWhat it holds
DateYesThe day of each line.
Amount, or Money in and Money outYesOne column with money in above zero and money out below, or two columns, each above zero.
Account, or From and ToYes, or one account for the whole fileThe account each line goes into, or where each line's money left and arrived. With From and To, a line between two of your accounts is a transfer, and one to your broker is a deposit.
CategoryNoMatched to your categories on the review's Categories card, where a category none of yours matches waits for your pick: see Import a bank statement. Without it, a line takes its payee's usual category, or you pick on the review.
PayeeNoWho was paid, or who paid you. A new name becomes a new payee when you import.
DescriptionNoA note on each line.
TagsNoSeveral in one cell, split by commas.
TypeNoAnother app's words, like Expense, Income or Transfer: a transfer's two lines become one move between your accounts.
ReceivedNoWith From and To, what reached To in its own currency: the line is then an exchange.

A bank's own export is often one account per file:

DateDescriptionMoney inMoney out
2026-10-01CARD 4417 LIDL64.20
2026-10-02SALARY ACME LTD3280.00

You pick the account it goes into on the Columns step.

Dates and numbers

Written asRead?
2026-10-18, with or without a timeYes
18/10/2026, 18.10.2026, 18-10-2026 (day first)Yes
10/18/2026 (month first)Yes
18/10/26 (a two-digit year), 18 Oct 2026 (a month in words), a timestampNo
-64.20, 64.20- or (64.20), below zeroYes
1,234.56, 1.234,56 or 1 234,56Yes: the column shows which mark is the decimal one
€64.20, $64.20, 64,20 leiYes: the signs and codes are left out
1,234.56 and 1.234,56 in the same columnNo: the import stops and names the two lines

When no value in a column settles whether the day or the month comes first, like 05/04/2026, your workspace's date format decides. The line about formats on the Columns step has Change, to read it the other way.

Worked example

DateTypeTickerSharesPriceAmountFeeBroker
2026-09-02BuyVWRL10110.002.00Trading 212
2026-09-15KaufASML2650.001.00Trading 212
2026-09-25DividendVWRL4.80Trading 212
2026-10-01SellASML1700.001.00Trading 212
2026-10-02Deposit500.00Trading 212
3 tradesKauf is read as Buy: 10 VWRL for €1,102 with the fee, 2 ASML for €1,301, and 1 ASML sold for €699 after the fee
1 dividend€4.80 from VWRL
Left outThe Deposit line: record that money in the Wallet instead

With no Currency column, each price is read in its holding's own currency, euros for these two, and the fees in Trading 212's. After the import you hold 10 VWRL and 1 ASML at Trading 212.

Good to know

Matched as last time

The next file with the same columns is matched by itself, on this device, and the screen says Matched as last time.

The same file twice is safe

Lines already in your workspace are skipped, so files that overlap bring each line in once.

Splits

You do not need split lines: splits come from market data by themselves. Split lines in your file are read, then left out, and the Check counts them under Left out.

Up to 10,000 lines

A Generic CSV takes 10,000 lines at most; a longer bank statement stops with File exceeds 10,000 row limit. Split a longer history into files of up to 10,000 lines each, and import the oldest first. Ready-made imports have no such limit.

A ready-made import is easier

Check Imports, broker by broker first: a source in the list needs no matching.

Plans

Generic CSV is on every plan. The review checks your plan's limits before anything is saved.

Something missing, or not what you see in the app?Tell us in the community