Safe CSV Import Doctor
Inspect CSV structure, identifiers, dates, formulas, and row widths locally, then export a repaired file and diagnostic report.
What This Tool Does
Safe CSV Import Doctor identifies the silent transformations that commonly damage identifiers, dates, and formulas during spreadsheet or database imports. It preserves raw cell text, repairs only structural defects, and records every warning.
How to Use
- Choose one CSV and review the detected delimiter, row count, and column count.
- Inspect formula, leading-zero, scientific-notation, date, header, and row-width warnings.
- Download the structurally repaired file and the complete JSON diagnostic report.
How the Analysis Works
The parser follows quoted-field and escaped-quote rules, detects common delimiters, and does not coerce values. Repairs make headers unique, fill missing cells, and neutralize spreadsheet-active prefixes on export.
Limits and Responsible Use
Encoding replacement characters may indicate a non-UTF-8 source. The tool does not infer business meaning, validate against a database schema, or automatically choose a date convention.
Examples
Protect product identifiers
SKU 00123, date 01/02/03, value =2+2
Result: Warnings for leading zeros, ambiguous date, and formula-active content; safe export preserves the SKU.
Frequently Asked Questions
Will it change numbers or dates?
No. Cells remain text. Only structural repairs and spreadsheet-formula neutralization are applied on export.
What does a clean result mean?
It means no supported pattern was detected, not that the data is semantically correct or safe for every destination.