TSV Tools
80 free TSV tools — all run in your browser. No uploads, no account required.
TSV Converters
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.
Convert TSV to Parquet Online
Convert TSV files to Parquet format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to JSON Online
Convert TSV files to JSON format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to NDJSON Online
Convert TSV files to NDJSON format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to Arrow Online
Convert TSV files to Arrow format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to Excel Online
Convert TSV files to Excel format directly in your browser. No upload required — your data never leaves your device.
Convert Arrow to TSV Online
Convert Arrow files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert Excel to TSV Online
Convert Excel files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to YAML Online
Convert TSV files to YAML directly in your browser. Download clean, human-readable YAML — no upload required.
Convert YAML to TSV Online
Convert YAML files to TSV format directly in your browser. No upload required — your data never leaves your device.
Convert TSV to XML Online
Convert TSV files to XML directly in your browser. Download a structured XML document with one element per row — no upload required.
Convert TSV to SQL Online
Convert TSV files to SQL INSERT statements directly in your browser. Copy or download the generated SQL — no upload required.
Convert TSV to Markdown Table Online
Convert TSV files to a Markdown table directly in your browser. Copy the output and paste it into any Markdown document.
Convert TSV to HTML Table Online
Convert TSV files to an HTML table directly in your browser. Copy the markup or download a ready-to-use HTML file.
TSV Operations
Deduplicate TSV Files Online
Remove duplicate rows from TSV files instantly in your browser. No upload, no server — 100% private.
Filter TSV Files Online
Filter rows in TSV files by column value, directly in your browser. Your data stays on your device.
Sort TSV Files Online
Sort TSV files by any column, ascending or descending, directly in your browser.
Split TSV Files Online
Split TSV files into multiple smaller files by row count, directly in your browser.
Sample TSV Files Online
Sample rows from TSV files — first N, last N, or random — directly in your browser.
Manage Columns in TSV Files Online
Drop or select specific columns from TSV files directly in your browser. No upload required.
Rename Columns in TSV Files Online
Rename columns in TSV files instantly in your browser. No upload, no server — your data stays on your device.
Merge TSV Files Online
Merge and concatenate multiple TSV files into one, directly in your browser.
Trim Whitespace in TSV Files Online
Trim leading and trailing whitespace from all text columns in TSV files, directly in your browser. No upload required.
Fill Empty Values in TSV Files Online
Fill empty and null values in TSV files with a custom replacement value, directly in your browser.
Transpose TSV Files Online
Transpose TSV files — flip rows and columns — directly in your browser. No upload, no server.
Change Delimiter in TSV Files Online
Change the delimiter in TSV files — switch from comma to pipe, semicolon, tab, or any custom character — in your browser.
Extract Head of TSV Files Online
Extract the first N rows from TSV files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Extract Tail of TSV Files Online
Extract the last N rows from TSV files directly in your browser. Choose how many rows to keep and download the result — no upload required.
Add Row Numbers to TSV Files Online
Add a row number index column to TSV files directly in your browser. Set the column name and starting number — no upload required.
Validate TSV Files Online
Validate TSV file structure in your browser. Check null counts, distinct values, and data types for every column — no upload required.
Count Values in TSV Files Online
Group and count rows by any column in TSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Extract Unique Values from TSV Files Online
Extract all distinct values from any column in TSV files directly in your browser. Download the unique values list — no upload required.
Compare TSV Files Online
Compare two TSV files directly in your browser. See rows only in file A, only in file B, and rows common to both — no upload required.
Format Timestamps in TSV Files Online
Reformat timestamp and date columns in TSV files directly in your browser. Convert between ISO 8601, Unix epoch, US date, and custom strftime patterns — no upload required.
Find & Replace in TSV Files Online
Find and replace text values in TSV files directly in your browser. Supports plain text and regex patterns across any column — no upload required.
Split Column in TSV Files Online
Split a column into multiple columns by delimiter in TSV files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.
Combine Columns in TSV Files Online
Combine multiple columns into one in TSV files directly in your browser. Merge first name and last name, join address fields, or concatenate any columns with a custom separator — no upload required.
Convert Case in TSV Files Online
Convert text columns to UPPERCASE, lowercase, or Title Case in TSV files directly in your browser. Apply case conversion to any or all text columns at once — no upload required.
Aggregate TSV Files Online
Group and aggregate TSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Round Numbers in TSV Files Online
Round numeric columns in TSV files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Add Conditional Column to TSV Files Online
Add a new column to TSV files based on an if/else condition directly in your browser. Set a value for rows that match and a different value for rows that don't — no upload required.
Extract with Regex from TSV Files Online
Extract text matching a regular expression from TSV files directly in your browser. Pull out emails, URLs, phone numbers, or any pattern into a new column — no upload required.
Parse Dates in TSV Files Online
Parse and convert date columns in TSV files between formats and timezones directly in your browser. Supports ISO 8601, US/EU dates, Unix timestamps, and custom patterns — no upload required.
Compare Schema of TSV Files Online
Compare the schemas of two TSV files directly in your browser. See which columns exist in each file and spot type mismatches — no upload required.
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.
Unpivot TSV Files Online
Reshape TSV files from wide to long format directly in your browser. Melt multiple columns into variable/value pairs — no upload required.
Repair TSV Files Online
Repair malformed TSV files directly in your browser. Fix unbalanced quotes, inconsistent column counts, BOM markers, and mixed line endings — no upload required.
Convert Encoding of TSV Files Online
Detect and convert the character encoding of TSV files directly in your browser. Switch between UTF-8, Latin-1, Windows-1252, and more — no upload required.
Shuffle TSV Files Online
Randomly shuffle the row order of TSV files directly in your browser. Useful for randomising data before sampling or ML train/test splits.
Bin Column in TSV Files Online
Bucket a numeric column in TSV files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
Add Calculated Column to TSV Files Online
Add a new column to TSV files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
Extract JSON Column from TSV Files Online
Extract values from a JSON-encoded column in TSV files into a new flat column using a JSON path expression. Runs in your browser.
Calculate Date Difference in TSV Files Online
Calculate the difference between two date or timestamp columns in TSV files directly in your browser. Output in days, months, years, hours, minutes, or seconds — no upload required.
Normalize Columns in TSV Files Online
Normalize numeric columns in TSV files using min-max scaling (0–1) or z-score standardisation (mean=0, std=1). Adds new columns alongside the originals — no upload required.
Rank Rows in TSV Files Online
Add a rank column to TSV files based on any column's values. Choose RANK, DENSE RANK, or ROW NUMBER, with optional partitioning — runs entirely in your browser.
Add Cumulative Sum to TSV Files Online
Add a running total column to TSV files for any numeric column. Optionally order by a date or sequence column and restart totals per group — no upload required.
Detect Outliers in TSV Files Online
Detect statistical outliers in TSV files directly in your browser. Flag or remove rows where numeric values exceed a chosen number of standard deviations from the mean — no upload required.
Validate Email Addresses in TSV Files Online
Validate email addresses in TSV files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to TSV Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to TSV files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in TSV Files Online
Search for text across all string columns in TSV files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from TSV Files Online
Extract the top N rows per group from TSV files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to TSV Files Online
Add a percentage-of-total column to TSV files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Parse URL Column in TSV Files Online
Parse URL columns in TSV files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.
Add Lag / Lead Column to TSV Files Online
Add a LAG or LEAD column to TSV files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.
Filter by Date Range TSV Files Online
Filter TSV files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Compute Correlation Matrix for TSV Files Online
Compute a Pearson correlation matrix for numeric columns in TSV files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Find Fuzzy Duplicates in TSV Files Online
Find near-duplicate rows in TSV files using Levenshtein edit distance or Jaro-Winkler similarity — all in your browser. Set your own threshold and download the matched pairs as CSV — no upload required.
Hash & Anonymise Columns in TSV Files Online
Anonymise or pseudonymise columns in TSV files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Group Concatenate TSV Files Online
Concatenate text values within each group in TSV files directly in your browser. Group rows by a column and join the values of another column into a single delimited string — no upload required.
Truncate Dates in TSV Files Online
Truncate date and timestamp columns in TSV files to a chosen precision — year, quarter, month, week, day, hour, or minute — directly in your browser. Rounds timestamps down to the start of each period. No upload required.
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.
Add UUID Column to TSV Files Online
Add a UUID column to TSV files directly in your browser. Generate random UUIDv4 or time-ordered UUIDv7 identifiers for every row. Choose the column name and position — no upload required.
Pad Column in TSV Files Online
Left-pad or right-pad a column in TSV files to a fixed width directly in your browser. Zero-pad numeric codes, pad product IDs to a fixed length, or right-pad text fields — no upload required.
Compute Percentiles for TSV Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in TSV files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.
Find Arg Max / Min in TSV Files Online
Find the value of one column at the row where another column is maximum or minimum in TSV files — directly in your browser. Optionally group by a category to get per-group results. 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.
About TSV
TSV (Tab-Separated Values) is a plain-text tabular format that uses tab characters as delimiters instead of commas. It behaves identically to CSV in every other respect — one row per line, first line usually headers — but avoids the quoting complexity that arises when data values contain commas. If your data includes addresses, descriptions, monetary values, or any free-text fields with commas, TSV eliminates an entire class of parsing errors.
Bioinformaticians and genomics researchers use TSV heavily — standard formats like BED, GFF, GTF, VCF, and BLAST output are all tab-delimited. Legacy enterprise systems, certain database export tools, and Unix utilities like cut, awk, and paste also default to tab-delimited output. TSV is the quiet workhorse of scientific computing and legacy data pipelines.
The main limitation of TSV is narrower tool support compared to CSV — many databases and analytics platforms need the delimiter explicitly specified and default to comma if not told otherwise. Our TSV tools let you convert between TSV and CSV, apply the same filtering, sorting, deduplication, and transformation operations available for CSV, and export results in whatever format your downstream tool expects.
Frequently Asked Questions
How is TSV different from CSV?
The only difference is the delimiter character. CSV uses a comma; TSV uses a tab. TSV avoids the need to quote values that contain commas, but values containing tabs still need quoting. In practice, tab characters appear far less often in real-world data than commas, which is why TSV is preferred for data that includes addresses, descriptions, or any free-text content.
Can I open a TSV file in Excel?
Yes. Excel recognises .tsv files and imports them with the tab delimiter automatically. For .txt files with tab delimiters, you may need to use Excel's Import Wizard and specify the tab delimiter. Alternatively, convert to CSV first using the TSV to CSV tool here, and Excel will open it directly.
What bioinformatics formats use TSV?
BED (Browser Extensible Data), GFF/GTF (General Feature Format), VCF (Variant Call Format), SAM (Sequence Alignment Map), BLAST tabular output, and many other standard bioinformatics formats are tab-delimited. DuckDB can query these files directly via the SQL Query tool if you specify the tab delimiter in your query.