/ how to

How to edit a CSV file (the simple way)

Editing a CSV file should take 30 seconds. Here's how to fix typos, add or remove rows, clean up an export, and save the file back — without firing up Excel.

Step 1 — Open the file

Go to opencsv.io and either drag your CSV file onto the page or click 'Open' in the toolbar to pick a file. The file loads entirely in your browser; nothing is uploaded.

Step 2 — Make your edits

Edit a cell

Click any cell. Type the new value. Press Enter or Tab to move to the next cell.

Add a row

Click 'Row' in the toolbar to add a new blank row at the bottom.

Add a column

Click 'Column' in the toolbar. Edit the header to give it a name.

Delete a row or column

Each row has a small trash icon at the right. Each column header has one too. One click, gone.

Search inside the file

Use the search box to filter rows in real-time — useful for finding records to edit or rows you want to delete.

Step 3 — Save

When you're done, you have two options:

  • Click 'Download' to save the edited CSV to your device
  • Click 'Save' to put it in your private cloud library (paid users)
Both options preserve your column order, headers, and quoting exactly as they should be — so the file is ready to import into other tools.

Common edits people make

  • Fix a typo in a customer name or email
  • Remove duplicate rows from an export
  • Add a new product to a Shopify import
  • Update prices across an inventory list
  • Strip out a column you don't want shared
  • Add a header row to a file someone forgot to label

What to avoid

Don't open CSV files in Excel just to edit them — Excel often reformats data on save (drops leading zeros, converts dates, mangles long numbers). If you need to edit data without changing it, a dedicated CSV editor like OpenCSV is safer.

/ frequently asked

Frequently Asked Questions

  • A CSV file is a plain text file used to store tabular data in rows and columns, with values separated by commas. CSV stands for Comma-Separated Values. It's one of the simplest and most widely supported data formats in the world.

Open, edit, and share CSVs in seconds.

Free to view, $9.99/mo to edit. 14-day free trial.

Start 14-day free trial
/ desktop app

Make CSVs open in OpenCSV.

Install OpenCSV as a desktop app and it'll show up in your right-click "Open with…" menu for every CSV.