Profile the file
See row count, column coverage, likely types, and basic value patterns.
Open CSV Profiler
CSV and tabular data
Find the problems before the import does.
Use these working browser tools to understand a file's columns, missing values, identifiers, dates, and duplicate candidates before it enters a database, CRM, dashboard, or analysis.
- Input
- Your CSV or delimited text.
- Processing
- Runs in this browser; the file is not uploaded.
- Output
- Inspect findings and download the result.
Recommended order
Six checks for a safer handoff.
Start broad, then inspect the fields most likely to break an import or distort analysis. Each link opens the named executor with example inputs and a direct run action.
Inspect missing values
Measure blanks by column so missingness is visible before mapping or analysis.
Analyze missing dataInfer a schema
Review likely field types and structures instead of guessing at an import contract.
Infer the schemaFind identifier candidates
Check uniqueness and completeness before treating a field as a primary key.
Find key candidatesReview dates
Detect mixed date patterns before sorting, grouping, or calculating elapsed time.
Detect date formatsFind duplicate candidates
Locate likely repeated records without silently deleting anything.
Find near duplicatesUse the findings
Turn the checks into an import decision.
The tools identify candidates and measurable conditions. A person still decides which fields are authoritative and which transformations are acceptable.
Before a CRM import
Confirm email, company, identifier, and date fields are present and consistent before records are merged into the live customer system.
Before joining datasets
Check key coverage and duplicates before relying on a field to connect two tables.
Before recurring delivery
Use the results to define a repeatable schema, rejection rules, and a quality threshold for each future file.
Need the same checks on every file?
Elkwai can turn this sequence into a scheduled validation step, exception report, API response, or managed data-quality workflow.
Compare two exports privately.
Start with the free CSV comparison tool or download the CSV import checklist. Data Workbench turns two CSV files into a reusable reconciliation report. Choose the offline browser app or developer kit, each $49 once.