To export selected Excel cells to a CSV file, copy them to a new worksheet, make that worksheet active, and save it as CSV UTF-8. Excel saves the active sheet as CSV, so placing your selection on its own sheet keeps the rest of the workbook out of the export.
These steps use the Excel desktop app. If you need only rows or columns that are visible after filtering or hiding, choose Visible cells only before you copy.
If you want the entire worksheet, you can skip the copying steps: make that sheet active and use Save As > CSV UTF-8 (Comma-delimited) (.csv). Keep the original workbook as .xlsx so its other sheets and formulas remain available.
Step 1: Copy-Paste selected cells
Select the cells you want to export. Include the header row if the destination app expects column names. If your selection has no hidden or filtered cells, copy it now (Ctrl+C on Windows or ⌘+C on macOS). Otherwise, use the next step before copying.
Export only visible cells (without hidden columns)
If you have hidden columns, Excel will add their content to your clipboard. This is not what we want. We want to export only our selected and visible cells.
In the Excel desktop app, select the range, then choose Home > Find & Select > Go To Special > Visible cells only > OK. Copy the selected visible cells after this step. Excel for the web does not provide the same visible-cells-only option for a normal range; open the workbook in the desktop app if hidden values must stay out of the CSV.
This keeps hidden or filtered rows and columns out of the copied range.
Step 2: Create a new sheet and paste your data
Create a new worksheet and select its top-left cell. For a range containing formulas, use Home > Paste > Paste Special > Values so the new sheet receives the calculated results. A normal paste can adjust relative formula references when the range moves, which may change the values you export.
Check the pasted values against the source. Reapply date or number formats if needed, especially for dates, percentages, and identifiers with leading zeros. For a range containing only ordinary values, a normal paste is sufficient. Microsoft's paste options explain the available choices.
Add columns to have CSV headers
CSV files are used to store structured data, and CSV headers add context to know what your CSV contains.
CSV headers are optional. But if you need to import your CSV into another software or clean it with a CSV editor, you better have them.
Just copy - paste the columns from the first sheet or write them directly as the first line in the new sheet.
Step 3: Export sheet to CSV
The last step is to export the new Excel sheet to a CSV file. Once you are on the new sheet, select Save As in the File menu.
Important: Set the active sheet to the sheet to export!
Then choose CSV UTF-8 (Comma-delimited) (.csv) as the file format and select Save. This format helps preserve characters such as accents; see CSV encoding if the saved file displays broken text.
A warning message will pop up with the message "This workbook cannot be saved in the selected file format because it contains multiple sheets.".
Confirm the warning after checking that the new worksheet is active. Excel saves only that sheet in the CSV. The CSV contains text and values, not the workbook's formulas or formatting; Microsoft's CSV export reference explains what is retained.
Before importing the file elsewhere, open it in a text editor or an importer preview and check its headers, row count, dates, and identifiers. Opening it directly in Excel can apply type detection again, so that view alone does not show whether a leading zero was present in the saved CSV.
Edit it with a CSV Editor
If you need to further clean your CSV data, use a CSV Editor such as Datablist.
Datablist provides advanced tools to deduplicate data, consolidate several CSV files, or clean your data.