What CSV is and why you might need it
A CSV file (comma-separated values) is a plain-text format that stores data in rows and columns, separated by commas. Excel reads and writes CSV files, but CSV is simpler than Excel's native format — it strips out colors, formulas, charts, and multiple sheets. When you convert an .xls or .xlsx file to CSV, you get a file that almost any program can open: Google Sheets, Numbers on a Mac, older versions of Excel, database software, or even a text editor.
You might need CSV when you're moving data between different programs, sharing a spreadsheet with someone who doesn't have Excel, or preparing data for import into accounting software, a website, or a cloud service. CSV is also a safer backup format because it's not dependent on any single company's software.
Key Takeaways
- Open your Excel file, click File, then Save As, and choose CSV (Comma delimited) from the file type dropdown.
- Excel will warn you that some formatting will be lost — this is normal and expected when converting to CSV.
- If your spreadsheet has multiple sheets, Excel saves only the sheet you're currently viewing as CSV; you'll need to repeat the process for each sheet if you want all of them.
- CSV files open in any spreadsheet program and in text editors, making them the most portable format for sharing data.
How to save a single sheet as CSV in Excel
Open the Excel file you want to convert. Click on the sheet tab at the bottom if you have multiple sheets — you can only save one sheet at a time as CSV, so make sure you're on the sheet you want to convert.
Click the File menu in the top left corner. Select Save As. A dialog box will open showing your current file name and location. In the "Save as type" dropdown (on Windows) or "File Format" dropdown (on Mac), scroll down and select "CSV (Comma delimited)" or sometimes listed as "Comma Separated Values (.csv)". The exact name varies slightly by Excel version, but it will contain the word CSV.
Change the file name if you want — the name you type here is what the file will be called. Excel will automatically add the .csv extension. Click Save. Excel will show a warning that says the file may contain features not compatible with CSV format. Click Yes or Continue. Your file is now saved as CSV.
What happens to your data when you convert
CSV keeps your actual data — text, numbers, and dates — intact. What it removes is everything else: cell colors, bold or italic formatting, merged cells, formulas (it saves only the results the formulas produced), charts, images, and multiple sheets. If your spreadsheet is mostly data with minimal formatting, you'll see almost no difference. If it's heavily formatted or uses formulas, the CSV version will look plainer.
If you have formulas in your Excel file, the CSV will contain only the numbers or text those formulas calculated, not the formulas themselves. For example, if cell C1 contains =A1+B1 and shows 5, the CSV will contain just 5. This is usually fine for sharing or backup, but if someone needs to edit the formulas, they'll need the original Excel file.
Handling spreadsheets with multiple sheets
Excel can save only one sheet as CSV at a time. If your file has three sheets and you want all three as CSV, you'll repeat the Save As process three times — once for each sheet. Click on the first sheet tab, go to File > Save As, choose CSV, and give it a name like "Sheet1.csv". Then click on the second sheet tab, go to File > Save As again, and save it as "Sheet2.csv", and so on.
If you want to keep all your data in one CSV file, you'll need to copy all the sheets into a single sheet first, then save that as CSV. Select all the data in sheet two, copy it, go to sheet one, click below your existing data, and paste. Repeat for any additional sheets. Then save the combined sheet as CSV once.
Opening and checking your CSV file
After you save, your CSV file appears in the same folder as your original Excel file. You can open it by double-clicking it — it will open in Excel by default on most computers. You can also right-click the file, select "Open with", and choose Google Sheets, Numbers, or any other spreadsheet program you have installed.
Open your CSV file and scan a few rows to make sure the data looks right. Check that numbers haven't shifted into the wrong columns and that text with commas in it (like "Smith, John") didn't break into separate columns. If something looks wrong, go back to your original Excel file, check the data there, and save as CSV again.
Saving CSV files without losing your original Excel file
When you use Save As and choose CSV, Excel saves a new file in CSV format but keeps your original .xlsx or .xls file untouched. Both files exist in the same folder. You can open either one — the Excel file still has all its formatting and formulas, and the CSV file has the plain-text version.
If you want to be extra careful, save your Excel file first (Ctrl+S or Cmd+S), then use Save As to create the CSV version. This way you know your original is backed up before you create the CSV copy.
CSV file size and compatibility
CSV files are usually smaller than Excel files because they don't store formatting information. A spreadsheet with 10,000 rows might be 2 MB as .xlsx but only 500 KB as .csv. This makes CSV useful for email attachments or uploading to websites that have file size limits.
CSV works with almost every program that handles data: accounting software, email marketing platforms, website builders, database programs, and statistical software. If you're moving data from Excel into another program and that program asks for a CSV file, this is the format it wants. If a program asks for .xls or .xlsx specifically, you'll need to keep the Excel format instead.
Frequently Asked Questions
Will converting to CSV delete my original Excel file?
No. Save As creates a new file in CSV format while leaving your original Excel file unchanged. Both files exist in the same folder. You can delete either one without affecting the other.
What if my data has commas in it?
CSV handles this automatically. If a cell contains text with a comma — like "Acme, Inc." — Excel wraps that cell in quotation marks in the CSV file so the comma doesn't split the data into separate columns. When you open the CSV file, the data appears correctly.
Can I convert a CSV file back to Excel?
Yes. Open the CSV file in Excel, then use File > Save As and choose Excel Workbook (.xlsx) or Excel 97-2003 Workbook (.xls) from the file type dropdown. The data converts back, though any formatting you added to the CSV version will be lost if you switch formats again.
Why does Excel keep asking me to confirm the format when I save as CSV?
Excel is warning you that CSV doesn't support everything Excel does — no colors, formulas, or multiple sheets. Click Yes or Continue to proceed. This warning is normal and doesn't mean something is wrong.
What's the difference between CSV and other file types like TSV?
CSV uses commas to separate columns. TSV (tab-separated values) uses tabs instead. Most programs accept both, but CSV is more common. Excel's Save As menu offers both options — look for "CSV (Comma delimited)" or "Text (Tab delimited)" depending on what you need.