How to Save an Excel File as CSV: A Simple Guide

Learning how to save an Excel file as CSV is one of the most useful data skills you can have. A CSV (Comma-Separated Values) file is your data's passport to the rest of the digital world — clean, lightweight, and understood by almost every database, app, and business tool out there.

After you scrape data from a website into Excel, converting it to CSV is the next step to make it usable in CRMs, databases, and automation tools. This guide covers Windows, Mac, and cloud-based methods — plus a troubleshooting section for the most common conversion problems.

Get Clean, Structured Data — Ready for CSV Export

Clura scrapes any public website and delivers your data as a perfectly formatted CSV — no manual Excel conversion needed. Skip straight from web data to your CRM.

Add Clura to Chrome — Free →

Excel vs. CSV: What's the Difference?

An Excel (.xlsx) file is a complex workbook with formulas, charts, and multiple sheets; a CSV is a plain-text file storing only raw values — universally compatible with almost every application and database.

Feature	Excel (.xlsx)	CSV (.csv)
Structure	Multi-sheet workbook with complex formatting	Single plain-text file
Data Types	Stores numbers, text, formulas, charts, images	Stores only raw text and numbers
Compatibility	Best within the Microsoft Office ecosystem	Universally compatible with almost all applications
File Size	Larger due to formatting and extra features	Extremely lightweight and small
Best For	Data analysis, calculations, visualization	Data transfer, importing/exporting, storage

A CSV file is like a universal adapter for your data. It guarantees you can plug your information into almost any system without frustrating compatibility issues.

How to Save as CSV on Windows

On Windows, save an Excel file as CSV by going to File → Save As, then selecting 'CSV UTF-8 (Comma delimited)' from the 'Save as type' dropdown — the UTF-8 option handles special characters correctly.

Open your Excel workbook and click the File tab in the top-left corner.
Click Save As and choose a destination folder.
Open the 'Save as type' dropdown menu.
Select CSV UTF-8 (Comma delimited) — not the basic 'CSV (Comma delimited)' option.
Click Save. Excel will warn that only the active sheet will be saved — click OK.

[ Add screenshot here ]

Suggested file: /public/images/blog/excel-save-as-csv-windows-dialog.webp

Alt: Excel Save As dialog box on Windows showing CSV UTF-8 file type selection

Think of UTF-8 as the universal language for your data. It guarantees that a name like 'José' or a symbol like '€' transfers perfectly — avoiding messy import errors.

How to Save Excel Files as CSV on a Mac

On Mac, save an Excel file as CSV by going to File → Save As, then choosing 'CSV UTF-8 (Comma delimited) (.csv)' from the File Format dropdown — always prefer UTF-8 for maximum compatibility.

Click File in the top menu bar, then Save As.
Open the File Format dropdown menu.
Select CSV UTF-8 (Comma delimited) (.csv) — the safest option for all languages and symbols.
Click Save and confirm the active-sheet-only warning.

CSV UTF-8: Go-to option — handles accented letters, currency symbols, and emojis.
CSV (Comma delimited): Older basic version — will corrupt special characters.
Windows Comma Separated: Only for legacy Windows systems.
MS-DOS Comma Separated: A relic — you'll almost never need this.

How to Export CSV Files from Cloud Spreadsheets

Excel Online requires a two-step process (download .xlsx then Save As CSV), while Google Sheets exports directly via File → Download → Comma-separated values (.csv) in a single step.

Excel Online

Click File → hover over Save As → select Download a Copy.
Open the downloaded .xlsx in desktop Excel.
Use the standard Save As method to save as CSV UTF-8.

Google Sheets

Go to File → Download.
Choose Comma-separated values (.csv).
Your browser immediately downloads the active sheet as a perfectly formatted CSV.

Sales teams using the best data extraction software to gather leads can use this cloud-first approach to keep everyone on the same page with the most current data.

How to Solve Common CSV Conversion Problems

The most common CSV conversion problems are: only one sheet saving (CSV is single-sheet by design), leading zeros vanishing (format column as Text before saving), formulas disappearing (expected behavior — CSVs store values, not functions), and semicolons used as delimiters (regional settings issue — change system list separator).

Problem	Cause	Solution
Only One Worksheet Saved	CSV format limitation — cannot hold multiple sheets	Save each worksheet as its own separate CSV file
Leading Zeros Vanished	Excel's default number formatting removes them	Before saving, format the column as Text in 'Format Cells'
Formulas Replaced with Values	CSVs are plain-text and only store raw data, not functions	Expected behavior — keep a master .xlsx file to preserve formulas
Semicolons Used as Delimiters	Regional settings use comma as decimal separator	Change system list separator to comma, or find-replace semicolons

Skip the Excel Conversion Entirely

Clura delivers your scraped data as a perfectly formatted CSV automatically — no manual Excel export, no encoding headaches, no leading-zero problems.

Add to Chrome — Free →

[ Add screenshot here ]

Suggested file: /public/images/blog/excel-csv-conversion-troubleshooting.webp

Alt: Diagram showing Excel file conversion to CSV via Excel Online and Google Sheets cloud export

Frequently Asked Questions

Why can't I save all my sheets into a single CSV?

CSV files are simple flat text files — they have no concept of multiple sheets, tabs, or formulas. Unlike .xlsx files, a CSV can only hold a single grid of data. If you need to export an entire workbook, save each sheet individually as its own separate CSV file.

How do I save special characters correctly in a CSV?

Always choose 'CSV UTF-8' from the dropdown menu when saving. UTF-8 is the modern universal standard that handles almost any character — from accented letters like 'Renée' to currency symbols and emojis. The older 'CSV (Comma delimited)' option will corrupt special characters.

Why did my formulas disappear after saving as CSV?

CSVs are designed to store raw data values, not the formulas that calculate them. When you save as CSV, Excel converts all formulas to their final calculated values. This is expected behavior — always keep a master .xlsx copy of your file to preserve the original formulas.

How do I fix leading zeros disappearing in a CSV?

Before saving as CSV, select the column with ZIP codes or phone numbers, right-click and choose 'Format Cells,' then select 'Text' under the Number tab. This forces Excel to treat those numbers as text and preserve every character — including leading zeros.

What is 'CSV (MS-DOS)' and should I ever use it?

CSV (MS-DOS) is an ancient format left over from the early days of computing with severe limitations. Unless a legacy machine specifically demands it, never use this option. Stick with CSV UTF-8 for any modern use case.

Conclusion

Knowing how to save an Excel file as CSV is a foundational data skill — one that unlocks compatibility with CRMs, databases, and every business tool out there. The key rule: always use CSV UTF-8 to avoid encoding problems, and save each sheet separately since CSV only supports one grid at a time.

Keep a master .xlsx file for your formulas and formatting, and treat the CSV as your export format for sharing and transferring data to other systems.

Explore related guides:

Scrape Data from Website into Excel — collect structured web data and export it directly to a spreadsheet
Best Data Extraction Software — top tools for automating data collection and CSV export
How to Scrape the Web — a complete guide to automated web data collection

Get Clean CSV Data from Any Website — Automatically

Tired of manually exporting files every time you need fresh data? Clura scrapes structured data from any website and delivers it as a perfectly formatted CSV — automatically.

Add to Chrome — Free →