Cast Column Types in TSV Files Online
Change column data types in TSV files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
How to cast Column Types in TSV files
- Drop your file. Every column is listed with its current type, and each one starts at Keep original.
- For each column you want to change, pick a target type: VARCHAR, INTEGER, BIGINT, FLOAT, DOUBLE, BOOLEAN, DATE or TIMESTAMP.
- Click Apply Casts. The button stays disabled until at least one column has a new type.
- Check the preview for new empty cells. A value that cannot be converted becomes NULL instead of stopping the run.
- Download the result in the same format. Column names and order stay the same.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A property portal's listing feed arrives with loose types. Prices include "POA" (price on application), bathrooms were written as decimals, and the garage flag is free text. An analyst needs clean numbers and a true/false column before building a price model.
Input (TSV)
listing_id price bathrooms has_garage
L-3301 485000 1 yes
L-3302 POA 2 no
L-3303 612500 1.5 Y
L-3304 349000 2.75 n/aSettings
- listing_id: Keep original
- price: INTEGER
- bathrooms: INTEGER
- has_garage: BOOLEAN
Result
| listing_id | price | bathrooms | has_garage |
|---|---|---|---|
| L-3301 | 485000 | 1 | true |
| L-3302 | NULL | 2 | false |
| L-3303 | 612500 | 2 | true |
| L-3304 | 349000 | 3 | NULL |
"POA" is not a number, so that price becomes NULL. Casting a decimal to INTEGER rounds to the nearest whole number, so 1.5 becomes 2 and 2.75 becomes 3. That loses real information here, and DOUBLE would be the better choice for bathrooms. The BOOLEAN cast understands yes, no and Y, but "n/a" becomes NULL.
Frequently Asked Questions
What happens to values that do not fit the new type?
They become NULL. Every changed column is converted with TRY_CAST, so one bad value never stops the run. It also fails silently. Compare null counts before and after, for example with the Validate structure tool, to see how many values were lost.
Does casting a decimal to INTEGER round or truncate?
It rounds to the nearest whole number, so 2.75 becomes 3 and 1.25 becomes 1. Exact halves may round to the even neighbour, so do not rely on how 2.5 is handled. Values above 2,147,483,647 become NULL. Use BIGINT for large IDs.
Which text values become true or false with BOOLEAN?
true, false, t, f, yes, no, y, n, 1 and 0, in any letter case. Anything else, such as "on", "open" or "n/a", becomes NULL.
Related Tools
Fill Empty Values in CSV Files Online
Fill empty and null values in CSV files with a custom replacement value, directly in your browser.
Validate CSV Files Online
Validate CSV file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Aggregate CSV Files Online
Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Cast Column Types in CSV Files Online
Change column data types in CSV files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
Cast Column Types in Excel Files Online
Change column data types in Excel files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
Cast Column Types in Parquet Files Online
Change column data types in Parquet files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
Cast Column Types in JSON Files Online
Change column data types in JSON files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.