Is it safe to open confidential or financial CSV files here?

Yes, 100% safe. All file parsing, rendering, cell editing, and conversion takes place entirely inside your browser's local memory. Your data is never uploaded, transferred, or stored on any external server.

What delimiter characters are supported?

The tool automatically detects and supports commas (,), semicolons (;), tabs ( ), and pipes (|). You can also override the auto-detection by selecting your delimiter manually in the settings toolbar.

Can I convert my CSV to JSON or Markdown?

Yes. Once your CSV is loaded or edited, switch to the 'Export & Convert' tab or use the export buttons to view and copy your data as a JSON array of objects, a Markdown table, or clean HTML code.

Does this tool protect against CSV formula injection?

Yes. When exporting to CSV, cells starting with executable formula symbols (=, +, -, @) are handled securely to prevent malicious spreadsheet formula execution when opened in Microsoft Excel.

⚡ 100% Private In-Browser Spreadsheet, Table Editor & Converter

CSV Viewer and Editor Online: Edit, Sort & Convert CSV Files

Open, edit, sort, and filter CSV, TSV, and delimiter-separated tables directly in your browser. Double-click to edit cells, add rows and columns, and export to JSON, Markdown, or HTML with zero server uploads.

📊

Drop your CSV, TSV, or text file here or click to browse

100% Client-Side Privacy: No data is uploaded or stored on any server

How to View & Edit CSV Files in 3 Steps

Load or Drop Your File

Drag and drop your .csv or .tsv file into the browser, or click "Load Sample CSV" to test the editor immediately.

Edit Cells, Sort & Filter

Click any cell to modify values inline. Add or delete rows and columns, search text, or click column headers to sort numbers and text.

Download or Convert

Export your modified data back to sanitized CSV format, or convert directly to JSON objects, Markdown tables, or HTML code.

The Complete Guide to CSV Formats, RFC 4180 & Data Security

Comma-Separated Values (CSV) remains the global standard for tabular data interchange between databases, spreadsheets (Excel, Google Sheets), and software pipelines.

Why In-Browser Client-Side Processing Protects Privacy

CSV files frequently contain sensitive customer databases, payroll records, product pricing, and business metrics. Uploading these files to remote third-party servers creates severe data leak and GDPR compliance risks.

CSV Viewer and Editor 1io runs 100% locally inside your browser's JavaScript engine using the HTML5 File API. Disconnecting your internet connection does not interrupt the tool, ensuring zero data retention.

Understanding RFC 4180 Standards & Escaped Quotes

Common issues with basic CSV viewers involve unescaped quotes and line breaks within fields. The Internet Engineering Task Force (IETF) RFC 4180 standard establishes strict rules:

Embedded Delimiters: If a field contains a comma (such as "Los Angeles, CA"), the entire field must be enclosed in double quotes.
Escaped Quotes: If a double quote occurs inside a field (such as 12" Screen), it must be escaped with an additional quote: "12"" Screen".
Line Endings: Standard records are terminated with CRLF (\r\n), though Unix LF (\n) is supported seamlessly.

Preventing CSV Formula Injection (DDE Attacks)

When opening untrusted CSV files in Microsoft Excel, cells starting with =, +, -, or @ can trigger dynamic data exchange (DDE) formula execution. Our editor sanitizes these cells upon export to ensure safe spreadsheet handling.

Tabular Data Formats Comparison Matrix

Reference guide for comparing common data interchange formats:

Format	Delimiter	Best Used For	Human Readability
CSV (Comma-Separated)	Comma (`,`)	Spreadsheets, SQL database dumps, bulk imports	High
TSV (Tab-Separated)	Tab (`\t`)	Copy-pasting from Excel, bioinformatics data	Very High
JSON (Array of Objects)	Colons & Braces	REST APIs, web applications, NoSQL databases	Structured
Markdown Table	Pipes (`\|`)	GitHub READMEs, technical documentation	Monospace Visual
HTML Table	`<table>` Tags	Web pages, email newsletters, reports	Browser Rendered

Frequently Asked Questions

How do I edit cell values in the table?

Click directly on any cell to edit its text. When finished, press Enter or click outside the cell. The underlying dataset and export views update immediately.

What is the maximum file size I can load?

Because the tool runs entirely inside your browser's 64-bit memory, it easily handles files with tens of thousands of rows and multiple megabytes without lag.

How do I sort by a specific column?

Click on the header title or the sort arrows (⇅) of any column. Clicking once sorts ascending (A-Z or lowest number first), clicking again sorts descending (Z-A).

Can I convert my CSV into a GitHub Markdown table?

Yes. Switch to the 🔄 Export & Convert tab and click Markdown. You can copy the pipe-delimited table code directly into your GitHub README or documentation.