Data Doctor ✦ FLAGSHIP TOOL
Fix messy spreadsheets in seconds. The automated 5-step diagnostic & deterministic repair pipeline for CSV, XLSX, and Excel files. 100% private in-browser execution.
The 5-Step Data Doctor Workflow
Drag & Drop or Sample
Drop any CSV, XLSX, XLS, or TSV file. Files are loaded directly into browser memory buffers with zero server round trips.
Deep Health Diagnosis
Scans for duplicates, ragged rows, whitespace padding, mixed date formats, invalid email addresses, and casing inconsistencies.
Deterministic Repairs
Applies safe fixes automatically: deduplicates rows, normalizes ISO dates, trims whitespace, and flags review-required fields without data loss.
Ask Your Data
Query your clean data locally. Inspect row counts, distributions, numerical summaries, and missing value breakdowns without external AI dependencies.
Instant Blob Export
Download your sanitized dataset in CSV or native Microsoft Excel (.xlsx) format, or copy to your clipboard in a click.
Frequently Asked Questions
How does Data Doctor guarantee 100% privacy?
Data Doctor runs entirely inside your client browser thread using the modern HTML5 File API and JavaScript. Your file data is never transmitted over the internet or sent to any backend servers. You can even disconnect your internet and use it offline.
Does Data Doctor support Excel (.xlsx) spreadsheets?
Yes. Data Doctor natively supports both standard CSV/TSV text files and binary Excel (.xlsx, .xls) files. You can drop an Excel workbook, diagnose and repair all issues, and download the resulting file as clean CSV or Excel.
What is the difference between Safe Repairs and Review Required?
Safe repairs are 100% deterministic transformations where the correct result is mathematically unambiguous (e.g. trimming trailing spaces, removing identical duplicate rows, standardizing dates to ISO format). Potentially ambiguous issues (like an invalid email syntax) are preserved and highlighted with a review tag so you never lose customer data by accident.
How does "Ask Your Data" work without an AI API key?
Data Doctor features a fast local analytical query engine built directly in JavaScript. It parses queries like "how many rows", "department distribution", "missing values", or "salary statistics" locally from in-memory tabular structures. You get instant answers without latency, subscription fees, or data leaks.
Can I connect my own AI API key later?
Yes. The Ask Your Data architecture is designed with an open pluggable provider pattern. If you wish to connect your own OpenAI, Anthropic, or local Ollama endpoint in the future for advanced conversational synthesis, the interface is ready to support it.
What is the maximum file size supported?
Because processing occurs in your computer's RAM rather than a server container, Data Doctor easily handles datasets of up to 100MB+ or several hundred thousand rows on modern hardware.