Check a CSV Before Importing
Find record and field errors before an import fails. Review simple rules, check your CSV or TSV, and download a CSV report showing which fields need attention.
Know which fields to fix before importing
An importer may reject a file without a useful list of fixes. Check your CSV against your own explicit rules first. The report lists the logical record number, field, rule code and error. Your source file stays unchanged.
How to check a CSV
- Choose one CSV or TSV, then review its delimiter and encoding.
- Add field rules or load a saved rules JSON file. Check required columns and values, allowed text values, maximum text length, and string, integer or decimal formats.
- Select Check file to see the counts and error preview.
- Select Download error report to save the complete CSV report. Save your rules to reuse them with another file.
Example: three fields to fix
Suppose Email is required, Status must be exactly Active or Paused, and Qty must be an integer. A sample check finds these three errors:
| Record | Field | Problem |
|---|---|---|
| 1 | Required value is empty | |
| 2 | Status | Value is outside the allowed list |
| 3 | Qty | Value is not an integer |
Use the report to fix your original file or source system, then check again. Record numbers count parsed data records, including records containing quoted newlines. Record 0 identifies a header check.
Questions about CSV checks
Does it automatically repair my CSV?
No. It reports errors against the rules you review. It does not trim text, change case, convert numbers, rewrite source values or modify your uploaded file.
What happens when the file passes?
You see zero errors and can download a valid CSV report containing its column headings. A malformed CSV stops with a parsing error instead of a partial report.
How exact are allowed values and number rules?
Allowed values are case-sensitive text, including spaces. Empty means exactly empty. Integer and decimal rules check explicit text formats. They do not guess dates, locale formats or spreadsheet types.
Where is my file processed?
Your file is uploaded to SuperTool’s servers for processing. The error report identifies fields and errors without copying source cell values. Review the saved report and keep your original file.
Is there a free result?
SuperTool offers one free result. Additional results follow the shared account options shown in the app. Checking the preview does not consume a result, and an identical repeat download does not use another result.
Can I reuse my rules?
Yes. Save and reload the declarative rules JSON. Rules contain data only; arbitrary code and regular expressions are not supported.
More tools
Browse All Tools for CSV and other file tools.