Coalesce Columns in TSV Files Online
Fill null values in TSV files from other columns — return the first non-null value across up to 8 columns in priority order. Add the result as a new column. Runs entirely in your browser.
Drop your .tsv file here
or click to browse — max 50 MB
About this tool
Add a new column to a TSV file containing the first non-null value from an ordered list of up to 8 columns. This is a direct implementation of SQL's COALESCE function. Common uses include building a "best available" value (e.g. use the mobile number if present, otherwise the landline, otherwise the email), merging split address fields, and resolving overlapping data from two sources. The priority order matters — earlier columns take precedence over later ones. Runs entirely in your browser — no upload required.
Frequently Asked Questions
What is the difference between coalesce columns and fill nulls for TSV files?
Fill nulls replaces null values with a static constant (e.g., "0" or "unknown"). Coalesce columns replaces nulls with the value from another column — the first column in your list that is not null. Use coalesce when you want to build a fallback chain across multiple columns.
Does the order of columns matter in the coalesce tool for TSV files?
Yes — order is critical. COALESCE returns the first non-null value in the list. Column 1 is checked first, then Column 2, and so on. If Column 1 has a value it is always used, even if Column 2 also has a value.
What happens if all selected columns are null for a row in a TSV file?
If every column in the coalesce chain is null for a particular row, the result column will also be null for that row. There is no default fallback unless you add a constant as the last column using the Calculate Column tool first.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Convert CSV to TSV Online
Convert CSV files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert Parquet to TSV Online
Convert Parquet files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert JSON to TSV Online
Convert JSON files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert NDJSON to TSV Online
Convert NDJSON files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to CSV Online
Convert TSV files to CSV format directly in your browser. No upload required — your data never leaves your device.