Data Type Guesser
Your workspaceProcessed on your device
A few things to know.
Runs on your device and leaves the source values intact. Inspects up to 500,000 input characters, 10,000 rows and 128 columns. Supports commas, semicolons, tabs and pipes for delimited text. JSON rows must be objects and keys must be unique.
- Paste a delimited table with headers or a JSON array of objects. Select the input format and the field separator if using CSV.
- Choose whether quoted CSV fields should count as text. Select Inspect types and compare each suggested type with the counts and examples.
- Check leading zeros, precision risks and blanks before deciding which fields to import as text. Copy or download column-types.json.