Consistent
- name age\nAda 30 -> 2 rows, 2 cols
format validator
TSV Validator
Check TSV files for consistent columns before imports or uploads—client-side only.
Results
Processing…- Status
- Processing...
- Details
- Processing...
- Rows
- Processing...
- Columns
- Processing...
How to use this validator
- Paste TSV with header and rows.
- Run validate to parse and count columns by tab.
- If mismatches appear, fix the flagged rows (missing tabs) and re-validate.
Rules & checks
Checks each row for consistent column counts.
Ignores blank lines; trims trailing whitespace.
Runs entirely in-browser; TSV is not stored or sent.
Inputs explained
TSV content
Paste tab-separated text. Keep payload modest for quick parsing.
When to use it
- Validate TSV exports before importing to CRM/BI tools
- Check user-uploaded TSVs for shape issues
- Spot column drift between environments or versions
Common errors
- Row has fewer/more columns than header
- Tabs missing due to copy/paste or spaces
- Blank trailing lines counted as rows
Limitations
- Structural check only—does not enforce data types or business rules.
- Assumes tabs as separators; not a full parser for quoted tabs inside fields.
Tips
- Trim blank rows to reduce false mismatches
- If data contains tabs inside fields, use CSV with quotes instead
Examples
Mismatch
- name age\nAda -> Flags missing column
Deep dive
This TSV validator checks column counts and trims blank lines entirely in your browser to catch shape issues before imports.
Use it to QA TSV exports and uploads; switch to CSV/quotes if your data contains tabs inside fields.
FAQs
- Do you support quoted fields with tabs?
- This check targets column counts in tab-delimited data. Use the CSV validator when fields contain tabs.
- Does it handle CSV?
- Use the CSV validator for comma-separated data; this tool is for tabs.
Related validators
All parsing happens in your browser. No data is sent, logged, or stored.
Lightweight structural check; not a full TSV parser for embedded tabs or quotes.