CSV Column Type Detector Online

Inspect string, boolean, numeric, ISO-date and empty-cell counts for each column. No cell values are converted. Free csv column type detector online, with no installation or account.

Tool capabilities

Input: TXT
Output: TXT · JSON

How to use CSV Column Type Detector

Inspect string, boolean, numeric, ISO-date and empty-cell counts for each column. No cell values are converted. This csv column type detector works directly in your browser and is free to use without an account.

Paste or open your input in the editor.
Run the tool and inspect the output. If the input is invalid, correct the reported error and run it again.
Copy the result or download it to your device.

CSV Column Type Detector · Example

Input

name,team,score
Alex,blue,10
Mina,red,20
Alex,blue,5

Output

[
  {
    "column": 1,
    "name": "name",
    "empty": 0,
    "boolean": 0,
    "numeric": 0,
    "isoDate": 0,
    "string": 3
  },
  {
    "column": 2,
    "name": "team",
    "empty": 0,
    "boolean": 0,
    "numeric": 0,
    "isoDate": 0,
    "string": 3
  },
  {
    "column": 3,
    "name": "score",
    "empty": 0,
    "boolean": 0,
    "numeric": 3,
    "isoDate": 0,
    "string": 0
  }
]

Inspect string, boolean, numeric, ISO-date and empty-cell counts for each column. No cell values are converted.

Usage notes

Inputs and results are processed on this device. Tool content is not sent to a processing server.

CSV Column Type Detector