Are my files uploaded to a server?

No. The validator runs entirely in your browser with JavaScript. The CSV never leaves your device; there is no upload endpoint.

Which CSV formats are supported?

Comma-separated 7-column files (Timestamp, Open, High, Low, Close, TickVolume, Spread) and semicolon-separated 5-column files (Time; Open; High; Low; Close) are both supported. UTF-8 and UTF-16 encodings are detected automatically.

How are weekend gaps handled?

Select the asset profile first. Forex, metals, indices and energy treat weekend and daily maintenance gaps as expected and only flag unexpected gaps inside trading hours. Crypto is treated as 24/7, so any gap larger than one bar is flagged.

Does the cleaned CSV fix bad OHLC rows?

No. The cleaned file removes duplicate timestamps and sorts rows chronologically. OHLC violations and outliers are reported but never silently rewritten, so your research stays honest.

Why does the validator ask for a timeframe?

The timeframe is auto-detected from the timestamp spacing. You can override it when a file has missing bars that make the automatic detection unreliable.

100% Browser-Based · No Upload

MT5 CSV Validator — Free OHLC Data Quality Check

Drop any MT5, broker or vendor CSV and get a full quality report in seconds: duplicate timestamps, OHLC violations, unexpected gaps, weekend and maintenance classification, outliers, spread anomalies, timestamp alignment and a transparent quality score. Then download a cleaned CSV and a JSON report.

Duplicate timestampsOHLC violationsGap classificationOutliersSpread checksCleaned CSV export

1. Choose a CSV file

Drop CSV here or click Comma or semicolon · 5–7 columns · UTF-8/UTF-16

2. Asset profile (gap rules) Timeframe (auto if empty) Date order for ambiguous dates

3. Run

Your file is parsed locally. Nothing is uploaded, stored or logged.

Results appear here

Load a file or click Load sample to see the full report: score, errors, warnings, gap classification, duplicates and a cleaned CSV.

77datasets supported

2CSV formats

0files uploaded

0—

0rows

-date range

-timeframe

0duplicates

0errors

0warnings

Cleaned CSV = duplicates removed (first kept) + chronological sort. OHLC errors are reported, never rewritten.

What the validator checks

Duplicate timestamps

Exact duplicates are listed with the first row number. Cleaned CSV keeps the first occurrence.

OHLC consistency

High must be ≥ Open/Close, Low ≤ Open/Close, High ≥ Low. Negative prices are allowed (WTI 2020) and reported as info.

Gap classification

Weekend, daily maintenance, session gaps and real data gaps are separated using the selected asset profile.

Outliers & flat bars

Ranges above 20× the median and O=H=L=C bars are flagged for review.

Spread anomalies

Negative spreads are errors; spreads above 5× the median are warnings.

Timestamp alignment

Seconds and minute alignment are checked against the detected timeframe.

Supported CSV formats

Source	Delimiter	Columns
AlgoSpecial crypto / indices / energy ZIPs	,	Timestamp, Open, High, Low, Close, TickVolume, Spread
AlgoSpecial forex ZIPs	;	Time; Open; High; Low; Close
Generic MT5 exports	, or ;	5 to 7 columns, header optional

Encoding is detected automatically: UTF-8, UTF-8 with BOM and UTF-16 LE. Quoted fields and CRLF line endings are handled.

FAQ

Are my files uploaded?

No. Everything runs in your browser; the file never leaves your device.

Which asset profile should I choose?

Forex/metals/indices/energy expect weekend and daily maintenance gaps. Crypto is 24/7, so any gap above one bar is flagged.

Does it fix bad data?

It removes duplicates and sorts rows. OHLC violations are reported but never silently rewritten.

What is the quality score?

A transparent formula: 100 − 0.7×errorRate − 0.3×warningRate, clamped to 0–100. Rates are relative to row count.

Related tools & data

Continue Your Build

Turn the calculation into an EA

If the tool exposed a profitable or risky condition, convert it into a coded rule with testing and guardrails.

Build MT5 EA Hire Developer

Trust Client Reviews See verified feedback before hiring a solo MT4/MT5 developer. Proof Case Studies Review dashboards, backtests, overlays and market-structure builds. Tools Free Calculators Check pip value, lot size, drawdown, spread, swap and prop-firm risk. Build EA Development Turn the idea into MQL4/MQL5 code with source and testing.

Technical reading path

Go deeper before you build, download or automate

Hand-picked engineering articles, indicator breakdowns and trading-system tools so visitors keep exploring instead of leaving after one page.

Conversion Architecture

Pine Script to MT4/MT5 Conversion Planner

Analyze Pine strategies, repainting risk, TradingView alert bridges, MTF synchronization and the correct MQL4/MQL5 build path before paying for conversion.

Open planner

Source-Code Bundle

3-in-1 MT5 Indicator Bundle

12H Bias Engine, Smart Money Institutional Flow Dashboard and D1/H1 pending-signal logic with MQ5 + EX5 source included via Etsy.

Free Indicator

MT5 Bank Orders Institutional Flow Dashboard

Supply/demand zones, BOS/CHoCH, liquidity levels, FVG, equal highs/lows and confirmed trade-plan logic explained with EX5 download.

Session Liquidity

MT5 Asia London NY Liquidity Engine

Asia range, London raid and New York continuation/reversal planning with internal session backtest stats and entry/SL/TP dashboard.

Python Trading App

Interactive Brokers RSI Pair Trader

Tkinter desktop trading workflow, TWS API connection handling, RSI pair logic, risk controls and custom IBKR development positioning.

Historical Data

XAUUSD M30 CSV Data For Backtesting

Use clean MT5 historical data for Python backtests, strategy validation, spread checks and realistic gold EA research workflows.