Reviewed guide | 2026-10-18
Making exchange CSV exports readable: time zones, fee columns and file names
Trade and transfer exports from Binance, OKX, Bybit and Bitget use different column names, time zones and fee formats. A few cleanup rules make them comparable and much easier to search later.
Multiple exchanges | Russia | RUB | fees, access and account safety
Downloading your history is the easy part. Opening four CSV files side by side shows the problem: one uses UTC timestamps, another uses the time zone set in your account, fees appear in different coins, and the same action is called a trade, a fill or an execution depending on the platform. None of this is wrong, but if you want to answer simple questions later, such as what a position actually cost, you need the files to speak the same language. A one-page set of rules, applied each time you export, solves most of it.
Know where each export lives and what it covers
Each exchange offers history downloads from its orders or assets section, often split by spot trades, derivatives, deposits, withdrawals and internal transfers. Some limit the date range per file, so you may need several downloads for a year. Before exporting, check the time zone setting in your account preferences and note it. Keep the original files untouched in a folder, and do all cleanup on copies, so you can always go back to what the exchange actually produced.
Normalise time and naming first
Add a column with every timestamp converted to one time zone, ideally UTC, and keep the original column beside it. Rename files with a fixed pattern: exchange, data type, start date and end date, for example okx_spot_2026-07-01_2026-09-30. Use the same pattern for every platform. When you return to the folder months later, sorting by name will group files logically and show any gaps in coverage immediately.
Make fees comparable
Fees may be charged in the quote coin, the base coin or a discount token such as BNB or BGB. Add two columns: the fee coin and the fee value converted into one reference currency at the time of the trade. If the export does not include a price for the fee coin, note where you took the price from. Do the same for funding payments on perpetual contracts, which some exchanges export in a separate file from trades.
Keep a short readme with the files
In the same folder, keep a plain text note listing which exchange uses which time zone, how each names its columns and any manual corrections you made. Add the date of each export. This sounds excessive until you need to explain a figure to someone else, or to yourself a year later. Back up the whole folder to a second location, and repeat the export routine at the end of each quarter rather than once a year.
Risk boundary: Russia Crypto Guide
Digital assets are volatile and derivatives can amplify losses. This website has no login, wallet connection, deposit form or customer-support chat. A referral link only records attribution; it does not guarantee access, pricing, rewards, approval or investment results. Availability can differ by residence, legal entity and product, so no regional access is assumed from language or branding alone.
Scenario checkpoint
- Check and note the account time zone before downloading any export.
- Keep untouched originals and work on copies with a fixed file-naming pattern.
- Add a single-time-zone column beside the original timestamps.
- Record fee coin and converted fee value, including funding payments.
- Keep a readme with time zones, column notes and export dates, and back up the folder.
Digital assets are volatile and derivatives can amplify losses. This website has no login, wallet connection, deposit form or customer-support chat.