CSV Viewer, Editor & Cleaner
Open, edit, filter, sort and clean CSV or TSV data, then download all rows or only matching rows.
About the CSV Viewer, Editor & Cleaner
CSV Workspace brings common spreadsheet cleanup tasks into one browser tool. Upload UTF-8 CSV or TSV, paste delimited data, or try the example, then edit headers and cells in a paginated table. Quoted delimiters, embedded newlines and escaped quotes are supported. Malformed quoting is reported without replacing your existing table.
Filter across all cells, naturally sort a column, trim whitespace and remove empty or exact duplicate rows. Cleaning and sorting operate on the complete dataset; the filter changes the view. Separate downloads make it explicit whether you want the complete table or only matching rows.
Input is limited to 5 MiB, 10,000 data rows, 100 columns and 200,000 cells. Ragged rows are padded, trailing blank rows are ignored, and data remains in memory until downloaded. Exports retain the detected delimiter and use UTF-8 with a BOM and CRLF line endings.
Key features
- CSV, TSV and semicolon import with optional headers
- Editable cells and column headers with 25-row pagination
- Whole-table natural sorting and live row filtering
- Whitespace, blank-row and duplicate-row cleanup
- Complete or filtered downloads
- Spreadsheet formula protection enabled by default
How to use
- 1Choose the delimiter and whether the first row contains headers, then open a file or load pasted text.
- 2Edit the table, filter rows or choose a column for natural ascending or descending sorting.
- 3Use the cleanup buttons to transform all rows, not just the current page.
- 4Choose header and formula-protection options, then download all rows or the filtered view before closing the tab.
Examples
Name,Department,Hours with repeated and empty rowsA deduplicated CSV with trimmed cells and the selected sort order.Frequently asked questions
- Are CSV files uploaded?
- No. Files are decoded and edited in your browser. The workspace does not send their contents to a server.
- Does removing duplicates use every column?
- Yes. Rows must have identical cell strings in every column. Trim whitespace first if surrounding whitespace should not distinguish rows.
- Are spreadsheet formulas executed?
- No. Cells are plain text. Download protection prefixes formula-like text with an apostrophe to reduce spreadsheet injection risk; signed numeric values are preserved. Disable protection only for trusted data.
- Can I recover edits after reloading?
- No. This workspace does not autosave. Download your cleaned data before navigating away or closing the tab.
Continue your workflow
Open a related tool to prepare your files or refine the finished result.
- ConvertersJSON to CSV Converter
Convert JSON to CSV and CSV back to JSON.
Open tool - ConvertersCSV to Markdown Table Converter
Convert CSV to a Markdown table and back.
Open tool - Business & MarketingImage to Spreadsheet Studio
Extract a photographed table locally, compare it with the source image, correct individual cells and export a reviewed Excel workbook.
Open tool
