Spreadsheet / CSV Editor

The Spreadsheet / CSV Editor is a lightweight, browser-based data editing tool that provides the familiar grid interface of a spreadsheet without the overhead of installing desktop software or creating a cloud account. It is designed for the quick data tasks that come up frequently in professional and personal contexts: cleaning up a CSV file before importing it into a database, transforming a tab-separated dataset into JSON, reviewing survey responses, or performing ad-hoc calculations on a small dataset.

Getting data into the editor is flexible. You can upload a CSV or TSV file from your local filesystem, paste data directly from Excel or Google Sheets (the editor auto-detects comma-separated and tab-separated formats), or start with a blank grid and type your data from scratch. The import process handles quoted fields, escaped characters, and varying column counts gracefully, so even messy real-world data files load correctly.

Once your data is loaded, the editor provides a full set of cell-level editing capabilities. Double-click any cell to edit its contents. Navigate the grid using Tab (move right), Enter (move down), and arrow keys. Add or remove rows and columns as needed. The editing experience is designed to feel natural for anyone who has used a spreadsheet application before, with no learning curve required.

Column sorting is available through column header controls. Click to sort ascending, click again for descending, and a third click to restore the original order. This is useful for quickly identifying the highest or lowest values in a dataset, sorting names alphabetically, or reorganizing dates chronologically.

Find and replace operates across all cells in the grid. Enter a search term and an optional replacement value, and the tool will locate every matching cell. This is invaluable for data cleanup tasks like standardizing capitalization, replacing abbreviations with full names, correcting systematic typos, or normalizing date formats.

Formula support covers the most commonly needed aggregate functions. Enter =SUM(A1:A10) to sum a column, =AVG(A1:A10) for the average, =COUNT(A1:A10) to count non-empty cells, =MIN(A1:A10) for the smallest value, and =MAX(A1:A10) for the largest. These formulas use standard spreadsheet cell references and update automatically when the referenced cells change.

Export options include CSV (comma-separated values), TSV (tab-separated values), JSON (as an array of objects where column headers become keys), and Markdown table format. This variety of export formats makes the editor a versatile data transformation tool — import a CSV, clean it up, and export it in the format your downstream tool or platform requires.

All data processing happens entirely in your browser. No files are uploaded to any server, and no data leaves your device. The editor works offline once the page has loaded, making it reliable for use in environments with limited or no internet connectivity.