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)
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 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.
Related guides
- / featureCSV Editor
Edit CSV files inline — no spreadsheet bloat.
- / hubCSV Viewer
Open any CSV file instantly in your browser.
- / featureLightweight CSV Editor
Why lightweight beats bloated software.
- / comparisonCSV vs Excel
When to use which format — full breakdown.
- / guideCSV Use Cases
Real-world ways people use CSV files.
- / helpFAQ
Common questions about CSV and OpenCSV.
Open, edit, and share CSVs in seconds.
Free to view, $9.99/mo to edit. 14-day free trial.
Start 14-day free trial