View·edit CSV table editor
Open CSV/TSV as an editable table, search it, and save matching rows. Check for possible Excel conversions of leading 0s, long numbers, and date-like values before import.
Compare two Excel or CSV filesOpen CSV
Open the example directly or select a CSV or TSV file to edit in a table.
Table preview
When you open the table, you can search, edit, and save as CSV.
Check before spreadsheet import
Microsoft Excel may automatically convert leading 0s, long numbers, and date-like strings when opening a CSV. This check looks for common patterns and does not change values. No findings do not guarantee that no conversion will occur; check your app’s text import settings for important files.
Cells that can be interpreted as spreadsheet formulas are saved with a protection tab. This tab remains in the value after import. Behavior may vary by spreadsheet app.
Share result
Share the tool link and result text together. No URL is included in the result. Check the below content and then share it.
Compare two Excel or CSV files
Match rows by a unique order or product ID to find additions, removals and changes. The editable public examples work immediately.
Both tables must have the same column names; column order may differ. Keys preserve leading 0s, spaces and case. Blank or duplicate keys are errors.
Files and tables stay in this browser without storage or uploads. Refresh restores public examples.
Compare the tables to see changes here.
| Status | Key | Column | Before table | After table |
|---|
CSV export is limited to 2 MB and contains status, key, column, before and after. Formula-like values receive a protective tab which may remain after import. Spreadsheet behavior varies.
How to open and edit a CSV table
Open CSV/TSV in a browser table to edit and check common patterns spreadsheets may convert from text to numbers or dates during import.
The comparison example starts with 001/Pen/1000 and 002/Note/2000; the revised table contains 001/Pen/1200 and 003/Book/3000. Comparing by id gives one changed, one removed and one added row. Leading 0s in 001 are preserved; row reordering alone is not a change. CSV editing and Excel import-risk checks remain available.
- Check file encoding and delimiter, then select a file or paste into CSV.
- Click Open Table to edit headers and rows, and use Search for Table content to locate the required rows.
- Click Save search results as CSV to include the matching row and full header in a new CSV file.
Supported range and boundaries
Handle commas, line breaks, and double quotes inside double quotes, and fill empty cells based on the widest row for short or long lines. Add protection characters for values that can be executed by formulas to prevent errors when viewed in a spreadsheet. Not all spreadsheets and subsequent data processing will behave identically. The maximum input size is 1MB.
Files and table content are processed on this device and are not included in sharing previews or visit statistics.
Frequently asked questions
Will send CSV content to the server?
No. File decoding, table editing, searching, and saving are handled in the browser. Addresses, analysis events, and sharing previews do not include cell content.
What if Hangul breaks?
Check file encoding. You can choose UTF-8 or EUC-KR·CP949, and encoding is not auto-detected.
Which row appears after saving search results?
Save only rows matching the current search and keep the header. If the search term is empty, save all data rows. Save matching rows that are not visible on the page.
Do you want to change the value in the formula protection tab?
Insert a tab before a cell that can be interpreted by a formula to reduce execution risk when opening in a spreadsheet. This tab may remain in the data after import and varies by app. Do not use this protection file directly in the original data processing. There is no universal CSV protection method for all apps.
How can I keep leading 0s in postal codes in Excel?
If you open a CSV directly, Excel may remove leading 0s from strings that look numeric. Import it using Data > From Text/CSV, then set the column type to Text in Power Query, or choose Text as the column data format in the Text Import Wizard. Behavior can vary by automatic-conversion settings and Excel version. This check only flags patterns and cannot guarantee the import result.
What happens if comparison keys are duplicated?
Blank or duplicate keys cause an error and stop comparison. The two tables must have the same set of column headers, though their order may differ. Case, whitespace and leading 0s are not automatically changed.
Can every Excel file be compared?
Only supported cell values in XLSX are read. XLS, XLSM and encrypted files are unsupported. Formula cells, error cells, styled numbers and merged cells are outside this subset. Check values in Excel and export CSV to compare them. Ordinary numbers are compared as stored values, not display formatting.
Calculation criteria and reference materials
- RFC 4180 — CSV
Comma separation, field quote and newline rules. Spreadsheet formula protection is additional processing by this tool.
- WHATWG — Encoding Standard
UTF-8 text: encoding/decoding.
- Microsoft Support — Automatic data conversions in Excel
Excel may remove leading 0s, limit precision for long numbers, or convert E notation and continuous letter-number strings into scientific notation or dates. Results vary by import path, column type, and automatic-conversion settings; this tool only flags common text patterns.
- OWASP — CSV formula insertion
Explains that protection settings may differ when cells are saved as formulas in Excel. The tool indicates that adding a protection tab allows values to be changed in subsequent programs.
- Microsoft — Retrieve values of cells in a spreadsheet
Reference for XLSX shared strings and stored cell values. Unsupported formulas and formats are rejected; this is not a full Excel calculation engine.
Verification of calculation criteria: · Calculation·verification principles · Report errors