How to Export a CSV File in Excel Without Losing Data

How-to basics · Updated November 18, 2026

To export a CSV from Excel for Microsoft 365 on Windows, open the workbook, select the worksheet you want to export, then choose File > Save As > Browse. Set Save as type to CSV UTF-8 (Comma delimited) (*.csv), choose a file name and location, and select Save. CSV saves the active worksheet’s data as plain text, not the workbook’s formatting or other sheets, so keep an .xlsx copy if you may need those later.

What You’ll Need

  • An Excel workbook containing the data you want to export. Check that the worksheet you intend to save is the active sheet.
  • A folder where you can find the exported file, plus a file name that ends in .csv. Excel adds the extension when you choose the CSV file type.
  • If the original workbook matters, a separate .xlsx copy. CSV does not preserve multiple worksheets, formulas as formulas, formatting, charts, or other workbook features.
  • If another application will import the file, its requirements for character encoding and field delimiter. UTF-8 is a good general choice, but the receiving system may specify a different format.

Step-by-Step

  1. Open the workbook and choose the sheet. Open the Excel file, then click the worksheet tab containing the data to export. Excel writes only the active worksheet to a CSV file; it does not combine every tab. If the workbook has several sheets, repeat the export separately for each one, using a clear file name for each sheet. Make sure the selected sheet is the one you want before continuing.
  2. Review the data before saving. Check the column headings, rows, and values you expect to include. Remove unwanted temporary notes or blank rows if they should not be part of the export. If you only want a portion of a sheet, copy that range to a new worksheet and export the new sheet; saving as CSV exports the sheet’s data rather than just the cells you happen to have selected. Also check that formulas display the results you intend to send.
  3. Keep an editable workbook copy. If you might need the original formulas, formatting, or other sheets later, save or retain a separate Excel workbook in .xlsx format. You can use File > Save As to make a copy before exporting, or save the CSV under a different name and location. Treat the CSV as a delivery or interchange copy, not as a replacement for a feature-rich workbook.
  4. Open the Save As dialog. In Excel for Microsoft 365 on Windows, select File > Save As > Browse. Choose the folder where the CSV should go. In the Save As window, enter a name in File name, then open the Save as type list. Avoid simply changing the file name extension to .csv while leaving the file type as an Excel workbook; select an actual CSV format from the type list.
  5. Select the CSV format. Choose CSV UTF-8 (Comma delimited) (*.csv) when available, particularly if the sheet contains accented letters, non-Latin characters, or symbols. This format uses UTF-8 text encoding. If a receiving system specifically requires a different encoding or delimiter, follow its instructions and choose the corresponding format if Excel offers it. Do not choose PDF or a tab-delimited text format when the destination expects comma-separated data.
  6. Save the file and respond to Excel’s warning. Select Save. Excel may warn that some workbook features are not compatible with CSV. This is expected: CSV keeps the active sheet’s cell contents as text values, but not workbook features such as formatting or multiple tabs. If you have retained an .xlsx copy and want the CSV, choose the option to continue using the CSV format. If you did not mean to convert or replace a file, cancel and save a separate copy instead.
  7. Check the exported file. Find the .csv in the folder you chose. Open it in Excel or a plain-text editor to confirm that the expected rows, columns, characters, and separators are present. Reopening it in Excel may apply automatic interpretation to values such as dates or long numbers, so a text editor can help confirm the literal saved characters. If another program will import the file, use its import preview or test a small copy before sending the full dataset.

On Mac: The names and placement of commands can vary slightly by Excel version. Use File > Save As, then choose CSV UTF-8 or a CSV option from the file-format menu before saving. Excel may show a compatibility warning; keep an .xlsx copy and confirm the CSV choice if that is the format you want. In Excel for the web: CSV export options can differ from the desktop app and may not be available for every account or workbook. If you cannot select CSV, open the workbook in the Excel desktop app and follow the Windows or Mac steps above.

Common Mistakes

Assuming every worksheet is included: A CSV file represents one sheet, not an entire workbook. If there are separate tabs for different months, departments, or records, export each one individually. Give the files names that make their contents clear, such as orders-january.csv, rather than saving several files with the same generic name.

Overwriting the only useful copy: CSV cannot retain formulas, cell formatting, charts, tables, or additional sheets as workbook features. It is easy to save the CSV and later discover that the original workbook is no longer available. Preserve an .xlsx version before converting, especially when the workbook is used for ongoing work.

Expecting displayed formatting to travel with the values: A cell that displays a date as 02-Nov-2026 may be written as a different date representation, and currency symbols or decimal display settings are not guaranteed to carry over as formatting. CSV stores text values, not Excel’s visual presentation. Confirm what the destination expects for dates, decimal places, and currency before you export important data.

Ignoring leading zeros and long identifiers: Values such as 00127, product codes, and long account-like identifiers can be interpreted as numbers when a CSV is opened in Excel or imported by another application. That can remove leading zeros or alter digits. Preserve identifiers as text in the source workbook and, when importing the CSV, use the destination application’s text or column-format controls rather than relying on automatic detection.

Assuming the comma in the format name guarantees commas: Excel may use the Windows regional list-separator setting when it writes delimited text. Depending on system settings, a CSV that appears to be comma-delimited in its format name may use semicolons. Check the actual file or ask the recipient which delimiter is required instead of assuming every system will produce the same result.

Tips

  • Use CSV UTF-8 for broad character support. It is generally the safer choice for names and text containing accents, Asian characters, or symbols. Still, follow the recipient’s specification if it requires a particular encoding.
  • Use simple, consistent headings. Clear column names on the first row make it easier for other tools and people to understand the file. Avoid merged heading cells and decorative title rows if the receiving system expects the first row to contain field names.
  • Decide what should happen to formulas. The CSV contains the cell results, not editable Excel formulas. Before saving, check that formula results have recalculated and are current. If you need to share the formulas themselves, send an .xlsx file instead of relying on CSV.
  • Check blank cells and embedded punctuation. Commas, quotation marks, and line breaks inside a text value may be enclosed or escaped by the CSV writer so the value stays in the correct field. Do not edit these characters by hand unless you understand the format; a spreadsheet or import tool can parse them correctly.
  • Give the export a useful name. Include a date, report type, or version where it helps identify the file, while avoiding characters the operating system does not allow in file names. Keep a predictable naming pattern if you export the same report regularly.
  • Test the handoff. If the CSV is for a database, website, or reporting system, ask for a sample template or import instructions. Check field order, delimiter, encoding, date format, and whether headings should be included. A small trial export can reveal requirements before you deliver a large file.

Troubleshooting

The CSV option is missing: In the desktop app, open File > Save As > Browse and inspect the Save as type list. If you are in Excel for the web, the available download formats may be limited; open the workbook in the desktop app. On Mac, look for the file-format menu in the Save As dialog. Also check that the workbook is not open in a read-only location or restricted by permissions.

The recipient sees semicolons instead of commas: First inspect the file in a plain-text editor to identify the delimiter actually written. On Windows, Excel can follow the system’s regional list-separator setting. If the recipient requires commas, coordinate a suitable Windows regional setting or use an import/export tool that lets you choose the delimiter explicitly. Do not globally change regional settings without considering their effect on other applications.

Letters or symbols look wrong: Export again using CSV UTF-8 (Comma delimited) if the option is available. Then check that the receiving program imports the file as UTF-8 rather than guessing another encoding. Some applications provide an import wizard or an encoding selector; use that rather than opening the file in a way that automatically assumes a legacy character set.

Zeros disappear or numbers change: The CSV may contain the original text correctly, while Excel changes how it displays a value when reopening the file. Inspect the CSV in a text editor to see the saved characters. For a reliable import, use the receiving application’s text-import options and set identifier columns to text. If the source cell was already stored as a number and Excel discarded leading zeros before export, restore them in the source data and export again.

Columns appear in one field: The file’s delimiter may not match the importer’s setting. Check whether it uses commas, semicolons, or another separator, and choose the matching delimiter in the import dialog. Also check whether a text value contains commas and whether the receiving program correctly recognizes quoted fields. If you open the CSV by double-clicking, try importing it through the application’s data-import feature instead.

Some rows or results look unexpected: Confirm that you exported the intended active worksheet and that filters or hidden rows have not confused your review. Check formula results in the workbook before exporting, then compare the CSV’s row and column counts with what the recipient expects. If you need a subset, make a clean worksheet containing only that data and export that sheet.

Frequently Asked Questions

Does exporting to CSV change my Excel workbook?

Saving a CSV creates a text-format file, but it does not preserve workbook features in that file. Keep an .xlsx copy if you need formulas, formatting, charts, or other worksheets. Saving the CSV with a different name also helps avoid confusing it with the editable workbook.

Can I export multiple Excel sheets into one CSV?

No. A standard CSV file contains one worksheet’s data. Select a sheet and export it, then repeat for each additional sheet. If the recipient needs data combined, arrange it on one worksheet first or ask whether another format is acceptable.

Are Excel formulas included in a CSV?

No. CSV stores the displayed or calculated cell results as text values rather than preserving formulas that can be edited or recalculated. Check that the workbook has current results before exporting. Use .xlsx if the recipient needs to inspect or change formulas.

Which CSV option should I choose?

Choose CSV UTF-8 (Comma delimited) (*.csv) for most general exports, especially when the data contains non-English characters. Use another CSV or text option only when the destination requires a particular encoding or separator. Confirm the recipient’s import requirements when the format matters.

Why does my CSV open in Excel with dates or codes changed?

Excel may automatically interpret text as dates or numbers when it opens a CSV. The file may still contain the intended characters, so inspect it in a plain-text editor. For accurate imports, use the application’s import controls and specify text for columns containing codes, leading zeros, or long identifiers.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.