Interactive Brokers CSV Import Guide
Export an Interactive Brokers Flex Query or activity statement as CSV, then import in your browser. Step-by-step guide β no uploads.
Not IBKR login β CSV import guide
Export IBKR trades in 3 steps (Flex Query or Activity Statement)
- In IBKR Client Portal β Performance & Reports β Flex Queries (or download an Activity Statement CSV).
- Include columns:
Symbol,Quantity,T.Price,Proceeds,Comm/Fee(orCommission). - Drop the CSV below β parsing runs in your browser; your ledger is not uploaded to our servers.
Common Flex Query issues (expand)
- Use CSV output β PDF/HTML statements will not parse.
- Multi-currency accounts: keep the
Currencycolumn so FX legs stay correct. - If the file opens blank in Excel, re-export with UTF-8 / comma delimiter from Flex Queries.
- Still stuck? Try the sample CSV above, confirm the dropzone turns green, then swap in your export.
Drop your Interactive Brokers CSV here
Parsed on-device. No server upload of your ledger. Sign-in optional for Drive sync later.
No export yet? Download a sample IBKR Flex CSV and drop it here to verify the importer.
Tired of Wrestling with CSVs?
Stop manual exports. Sync your Interactive Brokers data directly to Google Drive with Sovereign Sync.
About Interactive Brokers
Interactive Brokers exports vary by report type. Import your IBKR CSV in your browser, normalize trades, and keep your ledger on your device β no server uploads.
Required CSV Columns
Your Interactive Brokers CSV export must include these columns:
SymbolQuantityT.PriceProceedsComm/Fee
Sample CSV Format
Symbol,Quantity,T.Price,Proceeds,Comm/Fee AAPL,100,150.00,15000.00,1.00
Step-by-Step Import Guide
Step 1: Export Your Data
Log into your Interactive Brokers account and navigate to the export or account statement section. Download your trading history or account statement as a CSV file.
Step 2: Verify Required Columns
Ensure your CSV contains the required columns listed above. If any columns are missing or named differently, you may need to rename them or export a different report from Interactive Brokers.
Step 3: Sign In to Pocket Portfolio
Sign in to Pocket Portfolio using your Google account to access the CSV import feature. No registration required - just click "Sign in with Google".
Step 4: Upload Your CSV
Navigate to the dashboard and use the "Import CSV" feature to upload your exported data. Pocket Portfolio will automatically detect the Interactive Brokers format and map the columns.
Step 5: Verify Import
Review your imported trades and positions to ensure everything looks correct. You can edit or delete individual trades if needed.
Tips & Troubleshooting
- Use the Flex Query feature for detailed reports
- Include all transaction fees
- Export in CSV format for best compatibility
Ready to Import Your Interactive Brokers Data?
Sign in to Pocket Portfolio and import your Interactive Brokers trading data in minutes.