Import Excel Data and Export to CSV: A Practical Guide

How-to basics · Updated November 21, 2026

To import a worksheet from an Excel workbook in Microsoft Excel for Microsoft 365 on Windows, select Data > Get Data > From File > From Excel Workbook, choose the file, select a sheet or table, and choose Load. To export a sheet as a CSV, select File > Save As, choose CSV UTF-8 (Comma delimited) (*.csv), and save; CSV keeps data from the active sheet, not the workbook’s formulas, formatting, or other sheets.

Importing an Excel workbook into Excel

If the workbook is already open in Excel, you do not need to import it just to view or edit its sheets. Import is useful when you want to bring selected data into another workbook, combine it with other sources, or shape it before loading. Power Query provides a repeatable route for those tasks.

  1. Open the workbook that will receive the data, then select Data > Get Data > From File > From Excel Workbook.
  2. Browse to the source .xlsx or .xls file and select Import.
  3. In the Navigator window, select a worksheet or a named Excel table. A preview helps you identify the intended data.
  4. Choose Load to add the selection to the workbook, or Transform Data to open Power Query Editor and make changes before loading.

Importing a named table is often more reliable than importing a whole worksheet when the source has a defined data range. Tables have clear names and can expand as rows are added. For a one-time transfer, copying a range from one open workbook and pasting it into another may be quicker; Power Query is more useful when you expect to refresh the import later.

In Excel for Mac, available Power Query features and menu wording can differ by Microsoft 365 build. If the Excel-workbook connector is not available, open the source workbook and copy the needed range, or use a Windows version with the connector. Excel for the web also has different import capabilities from the Windows desktop app.

What CSV does—and what it leaves out

CSV stands for comma-separated values. It is a plain-text format for rows and columns: commas separate fields, and line breaks separate records. Many databases, websites, accounting systems, and data tools accept CSV because it is simpler to exchange than a full Excel workbook.

A CSV file does not preserve Excel’s workbook structure. It cannot store multiple worksheets, cell colors, widths, charts, comments, data validation, or formulas as formulas. When a formula cell is exported, the file contains the value shown by the formula rather than the formula itself. Dates, percentages, and numbers may be written in a form influenced by the cells’ display formats and regional settings.

That makes CSV appropriate for transferring a single flat table, but not for archiving an editable workbook. Keep the original .xlsx file if you may need formulas, formatting, multiple sheets, or later edits. Save the CSV under a new name rather than replacing the source workbook.

Prepare the worksheet before exporting

CSV export uses the active worksheet. Before saving, click the tab for the sheet you want and inspect the data. A clean, rectangular table is easiest for another program to read: use one header row, one record per row, and one field per column. Remove report titles, blank spacer rows, subtotals, and notes from the data range if the receiving system expects a simple table.

  • Check that each column has a meaningful heading and that headings are not blank or duplicated.
  • Look for merged cells, stray values outside the table, and completely blank rows or columns.
  • Confirm that dates, decimal values, and identifiers match the format expected by the destination.
  • Decide whether hidden rows or columns should be included; hiding them does not make them a safe way to exclude data from export.
  • Save the workbook as an .xlsx copy first if you want a preserved version with its formulas and formatting.

Pay particular attention to identifiers such as product codes, postal codes, and account numbers. Excel may interpret a value such as 00127 as the number 127, removing the leading zeros. If those zeros are meaningful, store the field as text before exporting and verify the resulting CSV in a text editor or by importing it with the correct data type. Applying a display format alone may not protect an identifier in every workflow.

Export the active sheet to CSV

After preparing the sheet, use this Windows desktop workflow:

  1. Select File > Save As, then choose Browse if Excel shows a list of recent locations.
  2. Choose a folder and enter a filename. Keep the original workbook’s .xlsx name or location if you want to preserve it separately.
  3. Open Save as type and select CSV UTF-8 (Comma delimited) (*.csv). This is generally a good choice when the file includes non-English characters or symbols.
  4. Select Save. If Excel warns that some workbook features cannot be saved in the selected format, confirm that you want to keep using the CSV format.
  5. If prompted that only the active sheet can be saved, confirm the choice after checking that the correct tab is selected.

On Excel for Mac, use File > Save As and choose the CSV option in the File Format control; exact labels vary by version. If you see a UTF-8 CSV option, choose it for broader character compatibility. After saving, Excel may leave the file open in CSV form. Close it without saving additional changes if you intend to keep the original workbook untouched, or reopen the .xlsx copy for workbook features.

Encoding, separators, and regional settings

Text encoding determines how characters are represented in a file. A CSV saved with UTF-8 can handle a wide range of writing systems and symbols. If a recipient opens a file and sees replacement characters or garbled accents, the issue may be how the file was encoded or how the receiving program opened it. Excel’s CSV UTF-8 option helps, but the recipient’s import settings still matter.

Although CSV conventionally uses commas between fields, software and regional settings can affect the separator Excel uses. In regions where a comma is used as the decimal mark, Excel may use a semicolon as the list separator when saving a CSV. If an application puts an entire row into one column, the delimiter may not match what it expects. Check the destination’s import instructions, and, when possible, use its import dialog to choose the delimiter rather than relying on a double-click to open the file.

Fields containing commas, quotation marks, or line breaks need to be represented in a way the receiving program recognizes. CSV writers generally enclose such fields in quotation marks and escape embedded quotation marks. Avoid editing a CSV by manually deleting punctuation or adding separators unless you understand the file’s quoting rules; a seemingly small edit can shift data into the wrong columns.

Verify the exported file

Do not assume a successful Save means the receiving system will interpret every field as intended. Check the exported file before uploading or sending it. A plain-text editor can show the separators and characters directly, while importing the CSV into a fresh worksheet lets you check the resulting columns and rows.

  • Confirm the file has the expected number of records and the correct header row.
  • Check a few dates, decimal values, long numbers, leading-zero identifiers, and non-English characters.
  • Look for unexpected blank columns, missing text, or values that appear to have shifted.
  • Make sure you exported the intended worksheet and did not include report material outside the table.

When opening a CSV by double-clicking, Excel may automatically guess data types. That can change how values appear—for example, a code with leading zeros may be treated as a number. This does not necessarily mean the original CSV stored the value incorrectly. To control interpretation, import it through Data > From Text/CSV, review the preview, and set the relevant column’s data type before loading. This is especially important when checking identifiers or dates.

Common problems and practical fixes

Only one sheet appears in the CSV: that is expected. CSV is a single-table text format, so export each required sheet separately, using a distinct filename for each, or use an .xlsx workbook if the recipient needs several sheets together.

Formulas have disappeared: CSV stores the formula results as values, not editable formulas. Keep the workbook as .xlsx when the recipient needs to recalculate or inspect formulas.

Columns are not separated correctly: confirm whether the destination expects commas, semicolons, or another delimiter. Use its import wizard or settings to select the correct one.

Characters look wrong: export as CSV UTF-8 when available, then ask the receiving application to import the file as UTF-8. Merely changing the filename extension does not change the file’s encoding.

Leading zeros or long numbers change: check whether Excel or the destination is converting the field to a number. Preserve code-like values as text and verify them through an import preview. Long numeric identifiers should generally not be treated as quantities.

The wrong data was saved: CSV saves the active sheet, so select the intended sheet before exporting. Also check the file’s folder and timestamp; it is easy to inspect an older export by mistake.

Frequently Asked Questions

Can I export all Excel sheets into one CSV file?
No. A CSV file represents one flat table, so Excel exports the active worksheet rather than combining a workbook’s sheets. Save each sheet as a separate CSV, or keep the data in an Excel workbook if multiple sheets must travel together.

Will exporting to CSV keep my formulas?
No. The CSV records formula results as values and does not retain the formulas or workbook formatting. Keep an .xlsx copy when you need to edit formulas or preserve the workbook.

Should I choose CSV or CSV UTF-8?
Choose CSV UTF-8 when the option is available, particularly if the data includes accented characters, non-Latin scripts, or symbols. If a destination system specifies a different encoding, follow its requirements and verify the imported text.

How do I import a CSV without losing leading zeros?
In Excel for Windows, use Data > From Text/CSV, inspect the preview, and set the identifier column to Text before loading. Opening a CSV directly can trigger automatic type detection, which may remove leading zeros from values treated as numbers.

Can I import only part of an Excel workbook?
Yes. With Data > Get Data > From File > From Excel Workbook, select the relevant sheet or named table in Navigator. Choose Transform Data if you need to filter or reshape the selection before loading it.

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.