Validate CSV Files Before
Your ERP Import
ImportCheck is a free CSV import validator that scans every row of your product catalog and flags every error — before you import into Sage, Odoo or WooCommerce.
Missing headers, duplicate SKUs, invalid prices, wrong VAT rates — caught in under 30 seconds. No ERP access required.
No credit card · Results in <30 seconds · Files deleted on request
Why CSV imports fail in ERP systems
ERP catalog importers are strict. A single malformed cell can block the entire file — or worse, silently corrupt existing product records.
🚫
Hard import failures
The ERP rejects the entire file on the first error. Your team spends hours guessing which row is wrong.
👻
Silent row skipping
Some importers skip invalid rows without logging them. You end up with a partially updated catalog and no audit trail.
♻️
Repeated fix cycles
Without a complete error list, teams fix one error at a time, re-import, fail again. A 20-row fix becomes a full day.
The most common CSV import errors — detected automatically
ImportCheck's CSV import validator catches the errors that ERP importers reject most often.
sku;name;price;tva;stock REF-001;Wireless Keyboard;49,90;20;150 ;USB-C Hub;;15;85 REF-001;Laptop Stand;34.90;15;-5 REF-003;Monitor Arm;89.90;20;
sku;name;price;vat_rate;stock REF-001;Wireless Keyboard;49.90;20;150 REF-002;USB-C Hub;29.90;20;85 REF-003;Laptop Stand;34.90;20;0 REF-004;Monitor Arm;89.90;20;12
MISSING_HEADERHeaderColumn "vat_rate" not found. A column named "tva" was detected — rename it to "vat_rate".
EMPTY_SKURow 3The sku column is empty. Every product must have a unique, non-empty reference.
EMPTY_PRICERow 3The price column is empty. Provide a positive numeric value.
DUPLICATE_SKURow 4"REF-001" already appears on row 2. SKUs must be unique across the entire file.
INVALID_VATRow 4VAT rate "15" is not an authorised value. Use one of: 0, 2.1, 5.5, 10, 20.
INVALID_STOCKRow 4Stock value "-5" must be a non-negative integer.
How ImportCheck prevents CSV import failures
Three steps between your spreadsheet and a successful ERP import.
Upload your CSV
Drop any CSV file. The validator auto-detects the separator (comma, semicolon, tab) and encoding (UTF-8, latin-1).
Get the full error list
Every row is checked against all rules simultaneously. You receive a complete list of errors with row numbers and fix suggestions — not just the first failure.
Fix once, import cleanly
Download the Excel error report, fix all flagged rows in your source, re-validate until 0 errors, then import into your ERP.
CSV validator features
Built for operations teams and ERP integrators who need a reliable, fast and easy-to-share validation tool.
Auto-detected separator & encoding
No configuration needed. The engine reads comma, semicolon and tab-separated files, and handles UTF-8, UTF-8 BOM, latin-1 and Windows-1252 encoding automatically.
Complete error coverage
All rows are scanned in a single pass. You get every error — not just the first — so you can fix everything in one go rather than in repeated rounds.
Row-level precision
Each violation points to the exact row number, column name, the raw cell value and a human-readable fix suggestion.
Downloadable Excel report
Export the full error list as a colour-coded Excel file. Share it with your supplier or data team without any further formatting.
ERP-ready rules
Validation rules match the constraints of Sage 100, Sage X3, Odoo and WooCommerce catalog importers: VAT rates, SKU uniqueness, numeric formats.
REST API access
Pro plan users can integrate the validator into their CI pipeline or data workflow. Submit a file, retrieve the JSON error list, automate the fix loop.
The impact of validating CSV files before import
Teams that validate before importing report fewer failed imports, faster go-live dates and more confidence in their data quality.
< 30s
Validation time
For any CSV file up to 10,000 rows.
100%
Row coverage
Every row checked, no sampling.
0
ERP access needed
Validate before touching production.
1x
Import attempts
Fix all errors, import once.
CSV import validator — FAQ
What CSV formats does the validator support?
Any standard CSV file with a header row. The separator (comma, semicolon or tab) and encoding (UTF-8, latin-1, Windows-1252) are detected automatically. Maximum file size is 20 MB.
Which CSV columns are required?
A valid product catalog CSV must contain: sku, name, price, vat_rate and stock. Column names are case-insensitive. Extra columns are allowed and ignored.
What CSV errors does ImportCheck detect?
Missing or misspelled column headers, empty or duplicate SKUs, empty product names, non-numeric or negative prices, unrecognised VAT rates (only 0, 2.1, 5.5, 10 and 20% are valid), negative or non-numeric stock values, and CSV parse errors caused by unquoted values.
Can I validate a CSV exported directly from Sage or Odoo?
Yes. Files exported from Sage 100, Sage X3 and Odoo 16/17 are directly supported. Sage typically uses semicolons; Odoo uses commas. Both are detected automatically.
Is my CSV data secure?
Your files are stored in an isolated, per-user bucket and are never shared with third parties. All transfers are encrypted via HTTPS. You can delete any file at any time from the dashboard.
Can I use the CSV validator via API?
Yes, on the Pro plan. Submit a CSV file, retrieve the error list as JSON and automate the validation step in your data pipeline or CI workflow.
Validate your CSV file now
Upload your product catalog CSV and get a full error report in under 30 seconds. No ERP access, no installation, no credit card.
Used by ERP project managers, operations teams and data integrators before every catalog import.
Start validating for free14-day free trial · No credit card required · Cancel anytime