Skip to content
ToolsOnDuty - free online tools
Developer Tools

CSV Viewer, Editor & Cleaner

Open, edit, filter, sort and clean CSV or TSV data, then download all rows or only matching rows.

Free browser toolRuns in your browserNo sign-up
Loading your browser workspace...

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

  1. 1Choose the delimiter and whether the first row contains headers, then open a file or load pasted text.
  2. 2Edit the table, filter rows or choose a column for natural ascending or descending sorting.
  3. 3Use the cleanup buttons to transform all rows, not just the current page.
  4. 4Choose header and formula-protection options, then download all rows or the filtered view before closing the tab.

Examples

Clean a team hours export
Input: Name,Department,Hours with repeated and empty rows
Output: A 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.

Open a related tool to prepare your files or refine the finished result.