How to open and edit a CSV file
- Click Open File and choose a CSV or Excel file, or just start typing in the empty sheet.
- Double-click a cell to edit it. Use the buttons above the sheet to sort, filter, and add or delete rows and columns.
- Click Download CSV or Download Excel to save your work.
What you can do
- View and edit CSV, TSV, XLSX, XLS and ODS files, including large ones with many thousands of rows.
- Sort the rows by any column and filter them to show only the rows that contain a word or number.
- Calculate with formulas, and see the sum, average, minimum and maximum of any cells you select.
- Fix the layout: add and delete rows and columns, drag a column edge to resize it, and copy and paste to and from Excel or Google Sheets.
- Convert: open a CSV and save it as Excel, or the other way round, and switch between comma, semicolon and tab separators.
Formulas
Start a cell with = to make it a formula. Refer to other cells by column letter and row number, such as B2, and to a block of cells with a colon, such as B2:B10.
| Formula | What it does |
|---|---|
=B2*C2 | Multiplies two cells. Use + - * / and ^ for math. |
=SUM(B2:B10) | Adds up a block of cells |
=AVERAGE(B2:B10) | The average. Also MIN, MAX, MEDIAN and COUNT. |
=IF(C2>100,"High","Low") | Shows one value or another, depending on a test |
=ROUND(D2,2) | Rounds to two decimal places |
=SUMIF(A2:A10,"Snacks",C2:C10) | Adds only the rows that match. Also COUNTIF and AVERAGEIF. |
=VLOOKUP("Pear",A2:D10,4,FALSE) | Finds a row and returns a value from it |
=A2&" "&B2 | Joins text. Also UPPER, LOWER, TRIM, LEFT, RIGHT, MID and LEN. |
To copy a formula down a column, select the cell and the cells below it and click Fill Down. The cell references move with each row. Put a $ in front of a letter or number, as in $B$1, to keep it fixed.
Keyboard shortcuts
| Key | What it does |
|---|---|
| Arrow keys, Tab, Enter | Move between cells |
| Shift + arrow keys | Select several cells |
| F2 or double-click | Edit the cell |
| Delete | Clear the selected cells |
| Ctrl + C / X / V | Copy, cut and paste |
| Ctrl + Z / Y | Undo and redo |
| Ctrl + D | Fill down |
CSV or Excel?
CSV is plain text that almost every program can read, but it holds only values: one sheet, with no formulas or column widths. When you download a CSV, formulas are saved as their results. Excel (XLSX) keeps every sheet, your formulas and column widths. If a CSV will be opened in a country that writes decimals with a comma, choose the semicolon separator.
Need a different format? Try CSV to JSON, JSON to CSV or Excel to CSV.
Private by design
Your file is opened and edited by your own browser. It is never uploaded to a server, so customer lists, exports and financial data stay on your device. Your work is also kept in this browser between visits, unless the file is very large.
Frequently asked questions
How do I open a CSV file online?
Click Open File and choose the file, or drag it onto the sheet. It opens in your browser and is not uploaded anywhere.
Can I open Excel files?
Yes. XLSX, XLS and ODS files open with all of their sheets, and you can save your changes as Excel or CSV.
Is my file uploaded?
No. The file is read and edited on your own device. Nothing is sent to a server.
How large a file can I open?
Files with hundreds of thousands of rows work on most computers. The limit is your device’s memory, since everything happens in your browser.
Why do accented letters look wrong when I open my CSV in Excel?
Excel needs a marker to know that a CSV uses UTF-8. This editor adds that marker automatically when your data has accented or non-English letters.
Are formulas kept when I download?
In an Excel file, yes. A CSV file can only hold values, so formulas are saved as their results.