How to use this office tool
- Choose a CSV or TSV file and confirm the header row.
- Run the inference and review type, confidence, blank count, and examples.
- Download the XLSX profile before changing any source schema.
#241 · CSV & Delimited Files Tool
CSV Column Type Inference
Profile a CSV or TSV file and infer whether each column mainly contains text, numbers, dates, booleans, blanks, or mixed values—all inside your browser.
Office File Tool
One CSV or TSV filerow
rows
Ad space
What this tool does
This tool samples every populated value, classifies it with conservative rules, and creates an XLSX report with inferred types, confidence, null counts, and examples.
Delimited rows → per-value classification → column type and confidence report
Type inference is a recommendation. Identifiers, leading-zero codes, and ambiguous dates should stay as text unless you confirm otherwise.
Supported formats
Files are processed locally. XLSX and XLS workbooks are read with SheetJS; CSV and TSV files are parsed with delimiter-aware handling. Advanced Excel features may not be preserved in generated files.
| Format | Support |
|---|---|
| XLSX / XLS | Read workbook values and formulas |
| CSV / TSV | Read delimited rows |
| Output | New downloadable file or report |
Tips for better results
- Work from a backup when the source workbook is important.
- Keep identifiers such as ZIP codes and account codes stored as text.
- Review the bounded preview and downloaded result before replacing any business workflow.
FAQ
How does CSV column type inference work?
Each nonblank value is tested against conservative boolean, number, and ISO-style date patterns, then the dominant type and confidence are reported.
Will leading-zero IDs be treated as numbers?
Values with meaningful leading zeros are classified as text so codes such as 00123 are not silently shortened.
Does the tool inspect the entire CSV file?
It profiles all parsed rows up to the page safety limit rather than relying only on the visible preview.
What does a mixed column mean?
A mixed column contains substantial values from more than one type, so automatic conversion could be risky.
Can I use TSV files too?
Yes. TSV input is parsed with a tab delimiter and receives the same column profiling report.
Related office tools
Processing details
| Stage | Action |
|---|---|
| Input | One CSV or TSV file |
| Privacy | Local browser processing |
| Result | New downloadable output |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all