TROUBLESHOOTING

Your Trading CSV Imported Nothing. Here Is Why.

A trade export that produces zero trades is almost never a corrupt file, and almost never a broken journal. It is nearly always the wrong export out of a platform that offers several that look alike. We keep every upload that fails in our own importer, and across those files the same six wrong ones come back over and over. This page shows you how to tell in about ten seconds which one you have, and which export to take instead.

Why traders can try Aurafy safely

Aurafy is a young, independent trading journal. It earns trust by keeping the local app usable without an account, making desktop data exportable, and being clear about which features are free and which require Pro.

Page updated September 2026

Local-first desktop
Your desktop journal works locally; cloud sync is optional.
No lock-in posture
Desktop data lives in SQLite and can be exported/backed up.
~50% off the stack
Aurafy Pro is $48.88/mo, replaces the ~$103/mo stack of journal + screen recording + bar-replay backtester. The backtester chart is free for everyone; Pro unlocks unlimited simulated trades, history jumps, analytics and exports.
Start free, foreverSee Pro · $48.88/moTry the live demo, no signup
Log a trade you actually took. No account, nothing to install.
The result is the number your platform showed you, after commission. That is the whole entry: no fill prices, no CSV, no import.

The ten second check

Open the file in any text editor, or in a spreadsheet, and read the first line. That line is the column names, and it decides everything. You are looking for a column holding the price you got OUT at, named something like Exit price, Close price, Sell price, or a stated Profit. If nothing on that line refers to closing or profit, the file records something other than finished trades, and no importer anywhere will produce trades from it. That single check separates the fixable from the hopeless faster than any error message.

The six files that cannot become trades

Open positions. Has a column with the word unrealized in it. A position still open has no exit yet, so there is nothing finished to journal. Balance history. Has Balance before and Balance after. It records what your money did, not what you traded. An order list with no fill prices. Has a Status column and an empty Avg fill price on the rows that actually moved size. It says what you asked for, never what you paid. A printed statement. Opens with the broker name on the first line, so every column name reads as junk. A PDF. Same problem, with no columns at all. A screenshot. Shows the price but not your entry, exit or size, so there is nothing in it to read.

What people actually upload, counted

Of the failed uploads sitting in our quarantine table, most are files that parse perfectly well and simply hold no closed trades: an open positions list, a balance history, an account snapshot, an order list without fill prices. The next group along is the platform report with a title line above the real table. Genuine parser gaps, where the file held real trades and we could not read them, are the smaller share, and every one found so far has since been fixed. If your import came back empty, the odds strongly favour the export being wrong rather than the file being unreadable.

Find your platform

The specific fix depends on which platform wrote the file, because each one names its exports differently and each one has a different trap. TradeLocker offers three exports that look nearly identical and only one of them holds closed trades. MetaTrader 4 and 5 write a report with three different tables stacked inside one file. NinjaTrader 8 has two grids that both export and only one carries entry and exit on the same row. Tradovate has four downloads under Reports and one of them is an account snapshot with no trades in it at all. If your platform is not listed, the statement versus trade history page covers the general case.

Why an empty import used to say nothing useful

For a long time this failure produced one line: no trades found in this file. That is technically true and practically useless, because it describes our result rather than your file, and it reads like a broken product. The importer now names what it received instead. Upload an open positions export and it says so, and tells you to take the order history. Upload a picture and it says a picture has no trade records in it, and offers to attach the screenshot to a trade you type in by hand. It refuses to guess: on a file it does not recognise it says nothing rather than inventing a reason, because a confident wrong diagnosis costs you more time than no diagnosis at all.

A wrong import is worse than a failed one

The failures worth worrying about are the ones that succeed. A file whose direction column we cannot read imports every short as a long, and the P&L sign flips with it, so the numbers look plausible and nobody reports it for weeks. Aurafy now checks its own work after every import: it compares the profit it calculated against the profit your file states, and checks that no exit lands before its entry. If more than a quarter of the checkable trades disagree, the import is held: the confirm button is disabled until you have compared a few trades yourself and ticked to say so, and your original file is kept and flagged either way. It is the one part of an importer that is worth more than the parser itself.

Frequently Asked Questions

What does a file actually need before it can become a trade?
Six things: which instrument, which direction, how many contracts or lots, the price you got in at, the price you got out at, and when. A stated profit column can stand in for the exit price, and a pair of fills can stand in for a single round trip. If any of the other pieces is missing from every row, no journal can rebuild the trade, and one that appears to has guessed.
The file opens fine in Excel, so why is it not a trade export?
Opening cleanly only proves it is a valid spreadsheet. A balance history, an open positions list and a support ticket log all open perfectly and none of them contains a finished trade. What matters is whether a row carries both an entry and an exit, or a stated profit.
Does opening the file in Excel first break the import?
It changes the timestamps, which used to break it. Excel rewrites a date like 2026-05-13 09:35:00 into 5/13/2026 9:35, dropping the zero padding. That is handled now, on both the single digit hour and the American month first ordering. Saving as .csv from Excel is fine.
My import worked but the numbers are wrong. Is that the same problem?
No, and it is the more serious one. Wrong numbers usually mean fees rather than trades: most order exports carry no commission column, so the journal estimates. Set your real per contract rate on the account and re-cost the existing trades. There is a full walk through of the three causes in the P&L mismatch article.
My file is still not importing. What now?
Send it to support@aurafy.dev and say which platform it came from. You are welcome to delete the account number column first, nothing else is needed. Files that arrive this way are what the parsers get built from, and if yours is a format we can already read, you will get told that instead of being left guessing.

Related Resources

TradeLocker Import Fix
Three exports look alike and only one of them holds closed trades.
MetaTrader Import Fix
The History tab writes a report, not a table. Here is the part that matters.
Statement vs Trade History
Why the file your broker calls a statement will never import.

Ready to try Aurafy?

Aurafy is free to start, no card. Every new account also gets 14 days of full Pro first, so you can see everything unlocked before deciding. Pro itself is $48.88/mo, monthly only, and replaces the ~$103/mo stack of journal + screen recording + bar-replay backtester, with a 30-day money-back guarantee if it isn't for you. The TradingView-powered backtester chart is free for everyone, any symbol, any history; Pro unlocks unlimited simulated trades, history jumps, analytics and exports. Start instantly in your browser at app.aurafy.dev. After the trial, Free keeps going as a complete journal: log and import everything, 12 months of trade history, 1 account.

Start free, forever →See Pro · $48.88/moTry the live demo, no signup