#45 · CSV & Delimited Files Tool

CSV Delimiter Detector

Work out whether an unfamiliar text export uses commas, tabs, semicolons, or pipes. The detector samples quoted records so separators inside quoted text do not inflate the score.

Office File Tool

Local browser processing
Ad space

How to use this office tool

  1. Choose the workbook and enter the requested options.
  2. Select CSV Delimiter Detector and review the limited preview and counts.
  3. Download the new delimiter analysis output. Keep the source file until you have checked the result.

What this tool does

This tool performs a focused delimiter analysis in local browser memory. It creates a separate downloadable result rather than presenting the original upload as processed.

Processing rule: parse the selected data, apply the delimiter analysis rule, limit the on-page preview, then serialize a new output file.

Complex Excel features such as VBA, external links, charts, and advanced formatting may not survive browser-based workbook rewriting. Use a copy of important files.

Supported formats

Files are parsed locally. Support is intentionally limited to the formats shown below and advanced workbook features may not be preserved.

InputOutput
XLSX, XLS, CSV, or TSV as applicableXLSX, CSV, HTML, or TXT as described

Tips for better results

  • Keep a backup of the original file.
  • Check headers, identifiers, dates, and leading zeros in the preview.
  • Open the downloaded result and verify a few representative rows before using it downstream.

FAQ

Which CSV delimiters can it detect?

It evaluates comma, tab, semicolon, and pipe delimiters.

Does it handle separators inside quotes?

Yes. Quoted sections are ignored while candidate separators are counted.

How is confidence estimated?

Confidence reflects how consistently a candidate creates multiple columns across sampled non-empty lines.

Will it modify my CSV file?

No. It creates a text report describing the detection result.

Can unusual multi-character delimiters be detected?

No. The detector is limited to four common single-character delimiters.

Processing limits

AreaLimit
Preview20 rows
ProcessingBrowser memory

Browse more office tools

Office tool hubs