Type Converter
Upload a dataset to begin
Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv
Sign in for free for unlimited files, no payment required.
About Type Converter
Force convert columns to Numbers, Dates, or Text.
Every column is scanned against your chosen target type using strict parsing rules: numeric strings with currency symbols, thousands separators, or trailing units are stripped and coerced to floats; date strings are matched against a list of common formats (ISO, US, EU) and normalized; anything else falls back to plain text. Values that fail to parse are flagged rather than silently dropped, so you can decide row by row whether to null them out, zero them, or leave the original text.
Category: Transformation & LogicCommon Use Cases
- Fixing a "quantity" column imported as text with values like "1,200 units" into a clean number
- Converting inconsistent date strings ("03/04/2024", "2024-04-03") from a merged export into a single date type
- Forcing an ID column that Excel auto-converted to scientific notation back into plain text
Key Features
- Per-column target type selection (Number, Date, Text)
- Configurable fallback for unparseable values (null, zero, keep original)
- Multi-format date pattern matching
- Strips currency symbols and thousands separators before numeric conversion
Run Schema Detect first to see which columns are mistyped, then use Type Converter to fix them before exporting with CSV to JSON, which relies on correctly typed numbers and dates to produce valid JSON values.
Frequently Asked Questions
You control the conversion, so you can review and handle any values that don't cleanly convert to the type you chose.
Numbers, dates, and text are the core supported target types.
Built for analysts and developers who need a dataset with dependable, strictly-typed columns before it hits a database or API.
Read the related guide →