CSV & Tabular Data Tools
Convert, check and summarize spreadsheet data in forms that are easier to work with.
TSV to CSV Converter
Convert TSV to CSV or CSV to TSV with automatic delimiter detection. Save UTF-8 with BOM for Excel.
Duplicate Row Finder
Find duplicate rows in CSV, TSV or list data. Show duplicates only, get a deduplicated list, and count how often each row appears.
CSV Schema Generator
Detects each CSV column's type and drafts CREATE TABLE statements for MySQL, PostgreSQL, and SQLite.
Markdown Table Fixer
Fix uneven columns, missing separator rows, and ASCII borders in tables. Export to Markdown, CSV, TSV, or HTML.
CSV Delimiter Converter
Auto-detect and convert CSV and TSV delimiters, or format data for pasting into Excel.
A1 to R1C1 Converter
Convert cell references between A1 and R1C1, and column letters to numbers.
TSV to CSV Converter
Convert TSV to CSV or CSV to TSV with automatic delimiter detection. Save UTF-8 with BOM for Excel.
Duplicate Row Finder
Find duplicate rows in CSV, TSV or list data. Show duplicates only, get a deduplicated list, and count how often each row appears.
CSV Schema Generator
Detects each CSV column's type and drafts CREATE TABLE statements for MySQL, PostgreSQL, and SQLite.
Markdown Table Fixer
Fix uneven columns, missing separator rows, and ASCII borders in tables. Export to Markdown, CSV, TSV, or HTML.
CSV Delimiter Converter
Auto-detect and convert CSV and TSV delimiters, or format data for pasting into Excel.
A1 to R1C1 Converter
Convert cell references between A1 and R1C1, and column letters to numbers.
Category Overview
What CSV & Tabular Data tools can do for you
6 tools listed
The CSV and table data tools focus on converting and checking data in rows and columns. Convert between CSV and JSON, TSV and CSV, detect and change delimiters, turn Excel files (xlsx and xls) into CSV, TSV or JSON, and translate between A1 and R1C1 references and column numbers and letters.
To put tables in documents or on the web, convert between spreadsheet data and Markdown or HTML tables and repair broken Markdown tables. You can also paste a table to make bar, line or pie charts.
For data quality, validate that every row has the same number of columns, extract and count duplicate rows, find near-duplicates despite spelling differences, compare old and new CSV or JSON files and infer column types to suggest a table schema. Large files are processed in your browser.
Handy when you need to
- ✓ Convert an Excel sheet to JSON or CSV for another system
- ✓ Turn spreadsheet data into a Markdown or HTML table
- ✓ Find broken columns or duplicate rows before importing
- ✓ See exactly what was added, removed or changed between two files
Pro tip
When sharing a CSV with personal data, the column masking tool in Privacy & Anonymization helps. For cleaning up text itself, see Text Formatting & Conversion.
CSV & Tabular Data: frequently asked questions
- Q. Can I convert an Excel file without uploading it?
- A. Yes. The Excel converter runs in your browser, so your file is never uploaded.
- Q. What if my CSV shows garbled characters?
- A. That is usually a character encoding problem. The text repair tool and the encoding converter in Developer Utilities can help.