HandyTools Hub

CSV Viewer & Editor

View, edit, sort, and export CSV data in a table format

Paste CSV data or upload a file to get started

Back to Tools

View, edit, sort, and convert CSV files without opening a spreadsheet program. Paste CSV text or upload a file, fix values in the table, sort any column, then export back to CSV or JSON. Everything runs in your browser β€” a safe way to inspect datasets that should not be uploaded anywhere.

How to Use

  • Load your data: Paste CSV text or upload a .csv file.
  • Check the parse: The tool auto-detects the delimiter (comma, semicolon, or tab).
  • Edit cells: Click any cell to change it; add or remove rows and columns from the toolbar.
  • Sort: Click a column header for ascending, again for descending.
  • Export: Download as CSV or convert to JSON.

Features

  • Automatic delimiter detection (comma, semicolon, tab)
  • Handles quoted fields, embedded commas, and multi-line cells
  • In-place cell editing plus row/column insertion and deletion
  • Smart sorting β€” numeric columns by value, text columns alphabetically
  • One-click export to CSV or JSON, including your edits
  • 100% client-side processing for privacy

What is CSV, Anyway?

CSV β€” Comma-Separated Values β€” is one of the oldest data formats still in daily use, and its staying power comes from simplicity: each line is a row, values are separated by a delimiter, and any program can read it. The simplicity hides subtleties, though. Values containing commas must be wrapped in double quotes, a quote inside a value is written as two quotes, and quoted fields may span multiple lines β€” rules formalized in RFC 4180. Files also vary by region: European spreadsheets often use semicolons because the comma is the decimal mark there, and many databases export tab-separated values β€” which is why the viewer sniffs the delimiter automatically.

Use Cases

  • Quick inspection: Peek at an export before importing it elsewhere.
  • Data cleanup: Fix typos, remove bad rows, or drop irrelevant columns.
  • Format conversion: Turn CSV into JSON for a web app or API prototype.
  • Sensitive data: Review financial or personal datasets without uploading them.

Tips for Working with CSV Files

If a file opens as one long column, the delimiter guess went wrong β€” check for semicolons or tabs. Before sorting a numeric-looking column, scan it for stray text like β€œN/A”: one non-numeric value switches the whole column to alphabetical order, where β€œ100” comes before β€œ20”. For Excel, watch values starting with ”=” or leading zeros like ZIP codes β€” Excel may treat them as formulas or strip the zeros. For heavy analysis, use a real spreadsheet; this viewer shines at quick edits, validation, and conversion.

Frequently Asked Questions

How do I edit CSV data?

Simply click on any cell in the parsed data table to enter edit mode. Type your new value and click away or press Enter to save. You can also add and delete entire rows and columns using the toolbar buttons above the table.

Can I sort columns?

Yes, click any column header to sort the data. The first click sorts in ascending order (A to Z or smallest to largest), and a second click sorts in descending order. Numeric columns are sorted by value, and text columns are sorted alphabetically.

What export formats are supported?

You can export your table data in two formats: CSV (comma-separated values) for spreadsheet compatibility, and JSON (JavaScript Object Notation) for use in web applications and APIs. Both exports include any edits you have made to the data.

Is my CSV data secure?

Absolutely. All parsing, editing, and exporting happens entirely within your browser. No data is ever sent to any server, ensuring complete privacy and security for your data.