Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Import deals from CSV: how it works

Turns a CSV file — from an exchange export, an OTC chat log or your own spreadsheet — into draft deals. You map the columns, preview every row with its errors and duplicates, and then create the drafts, which you confirm one by one.

Lesson 2 of 13 · How it works

  • about 3 min
  • Import deals (CSV)

How it works

  1. Choose the «CSV file» or paste the text, then «Preview»; the columns are guessed and can be changed under «Columns» (date, side, asset symbol, network, quantity, rate, value, fee, Tx hash The unique id of a transaction on the blockchain; anyone can look it up in a block explorer. More words in the glossary, wallet, customer, reference).

  2. Tick «The file shows the client's side» when buy means the client bought; the rows are then turned round to the desk's side.

  3. Every row is checked: date, buy / sell, an asset in the catalog, an exact quantity, a rate or value, a valid tx hash and wallet address.

  4. Duplicates are skipped: a tx hash already recorded or twice in the file.

  5. «Create the drafts» saves the valid rows as drafts with source CSV import; nothing is confirmed or posted by the import.

Where to find it

Settings that change it

Checklist

Before you move on, check that you can:

  • Open Import deals (CSV)
  • Choose the CSV file or paste the text, then Preview; the columns are guessed and can be changed under…
  • Tick The file shows the client's side when buy means the client bought; the rows are then turned round to…
  • Every row is checked: date, buy / sell, an asset in the catalog, an exact quantity, a rate or value, a valid…
  • Duplicates are skipped: a tx hash already recorded or twice in the file.

Tips and common mistakes

  • The file may be at most 2 MB; split a long history into several files.
  • Rows with an unknown symbol fail — add the asset with the same network first.