Simple. Fast. Useful.

Choose your tool

CONVERTERS TOOL

Delimited Text Separator Detector

Compare comma, semicolon, tab and pipe parsing for consistent column counts.

◇ Browser only
0 lines · 0 characters
Ready when you are
Your results will appear here.
Copy or download your result below.

Your text stays on this device.

Favorites
Recently used
LESS BUSYWORK, MORE DONE

Three steps. That’s it.

A useful toolkit for text, data, images and calculations.

  1. 01

    Add your input

    Choose a tool, enter values or select a file.

  2. 02

    Make it yours

    Adjust the options and run the action.

  3. 03

    Take the result

    Copy the result or download its file.

CSV delimiter detector online

Compare comma, semicolon, tab and pipe parsing for consistent column counts. Use this for the specific transformation described above. Start with the fixed sample and compare its result before replacing it with your own representative input.

How to use it

Paste the multi-line input in the format shown below. Choose Run tool. Review the output, then copy or download it.

Worked examples

Use this for the specific transformation described above. Start with the fixed sample and compare its result before replacing it with your own representative input.

Reproducible worked example

Settings: No additional settings.

Input:

name;city;age
Anna;Tirana;30
Ben;Rome;25

With the input and settings above, the tool produces:

Output:

{
  "bestCandidate": ";",
  "candidates": [
    {
      "delimiter": ";",
      "rows": 3,
      "columns": 3,
      "consistent": true,
      "score": 3
    },
    {
      "delimiter": ",",
      "rows": 3,
      "columns": 1,
      "consistent": true,
      "score": 0
    },
    {
      "delimiter": "TAB",
      "rows": 3,
      "columns": 1,
      "consistent": true,
      "score": 0
    },
    {
      "delimiter": "|",
      "rows": 3,
      "columns": 1,
      "consistent": true,
      "score": 0
    }
  ]
}

The example returns an object with 2 top-level fields. The fields “bestCandidate”, “candidates” identify the returned values or sections.

Limitations and common mistakes

  • Heuristic detection only. Multiple candidates may tie; inspect quoted fields and manually choose the correct separator.
  • Combined input is bounded to 150,000 characters; output text is bounded to 1.2 million characters. Some algorithms impose smaller limits, stated in their error messages.

Frequently asked questions

What format should I enter?

Paste the multi-line input in the format shown below. The worked example shows the supported structure and actual output.

How can I compare comma, semicolon, tab and pipe parsing for consistent column counts in CSV data online?

Paste the multi-line input in the format shown below. Choose Run tool. Review the output, then copy or download it.

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.

Useful next tools

Explore other tools

Open a tool below, use the search, or choose a category to browse its full collection.