CSV Delimiter Detect

data utility

CSV delimiter detector

Paste a few CSV rows and compare comma, semicolon, tab, and pipe splits before importing data into a spreadsheet.

csv delimiter detectorcsv semicolon commacsv import wrong columns

quick tool

CSV Delimiter Detect

Change a value to calculate.

before you act

What to check first

  1. Paste only a small safe sample, not private data.
  2. Check which delimiter gives consistent column counts.
  3. Set the delimiter manually during spreadsheet import.

plain answer

When this page helps

This page is for the small moment before a bigger workflow: opening a file, checking a measurement, importing data, ordering material, or explaining a problem to someone else. It keeps the first decision simple and gives you numbers or checks you can copy into the next step.

It does not replace the original software, a professional inspection, or a manufacturer's spec. It is a fast sanity check so you can spot the obvious issue before wasting time.

common mistake

Why people search for this

The usual problem is not a lack of effort. It is a mismatch between the label people see and the detail the next tool needs. A file extension can hide export settings. A measurement can use the wrong unit. A calendar or map file can look correct until one field is read in a different order.

Use the tool above as a first pass. If the result looks strange, check the source value before changing the destination app. Many fixes are simple once the original number, unit, version, or timestamp is written down.

result check

How to use the result

Copy the result into a note with the original input values. That gives you a small audit trail when you compare another viewer, spreadsheet, shop drawing, printer setting, or device spec. If two tools disagree, the saved inputs make the disagreement easier to explain.

For csv delimiter detector comma semicolon tab, the safest next step is to test one small example before applying the same setting to a full project. Batch changes are where small assumptions become expensive.

faq

Common questions

Why is my CSV in one column?

The spreadsheet guessed the wrong delimiter or locale settings expect semicolons.

Is semicolon CSV valid?

Yes. Many locales use semicolons because comma is used as a decimal separator.