#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 file
row
rows
Ad space

How to use this office tool

  1. Choose a CSV or TSV file and confirm the header row.
  2. Run the inference and review type, confidence, blank count, and examples.
  3. Download the XLSX profile before changing any source schema.

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.

FormatSupport
XLSX / XLSRead workbook values and formulas
CSV / TSVRead delimited rows
OutputNew 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.

Processing details

StageAction
InputOne CSV or TSV file
PrivacyLocal browser processing
ResultNew downloadable output

Browse more office tools

Office tool hubs