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 files

Open CSV

Open the example directly or select a CSV or TSV file to edit in a table.

File open settings · encoding and separator

Reads in UTF-8 or EUC-KR·CP949. Encoding is not automatically guessed.

Open and save with the selected delimiter. Quotes, commas, and line breaks remain within the cell.

The file is read only in this browser.

The first line is the header. Up to 1MB per UTF-8, up to 10,000 rows including header, 100 columns.

Opened values — edited or added values are not saved or sent. Refresh to return to an example.

Table preview

When you open the table, you can search, edit, and save as CSV.

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.

Before table

After table

File settings and supported formats

CSV: 1 MB; XLSX: 5 MiB. Up to 10,000 rows including headers, 100 columns, 100,000 cells and 10,000 characters per cell and 1,000,000 characters across each table. XLSX: 20 sheets, 200 ZIP entries, 20 MiB expanded total and 5 MiB per entry.

XLSX reads raw values from the selected sheet; the first sheet is the default. Formulas, merged cells, error cells, styled numbers and external links are unsupported. Date, currency and leading-zero display formatting is not applied. Export the desired values as text in CSV instead. XLS, XLSB and XLSM are unsupported.

Files and tables stay in this browser without storage or uploads. Refresh restores public examples.

Compare the tables to see changes here.

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.

  1. Check file encoding and delimiter, then select a file or paste into CSV.
  2. Click Open Table to edit headers and rows, and use Search for Table content to locate the required rows.
  3. 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

Verification of calculation criteria: · Calculation·verification principles · Report errors