To export filtered rows in Excel, apply your filters, select the results, copy the visible cells to a new workbook, and save that workbook as an Excel file or CSV. If by “filter list” you mean the choices inside a column’s filter dropdown, export the source column’s distinct values instead; both tasks are covered below. Start with a saved copy of your workbook so the original data stays safe.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the data you want to filter.
- A clearly labeled header row and a consistent data range. Remove completely blank rows or columns inside the range if they could split the data.
- A destination workbook or folder where you can save the exported results.
- If you need the dropdown choices rather than filtered records, access to the original column containing those choices.
Step-by-Step
- Decide what the export should contain. Most people mean the records left on screen after applying one or more filters. For example, a sales table might be filtered to show one region and dates in a selected quarter. The export will contain the rows that meet those criteria. If you instead need the list of available region names shown in the filter dropdown, skip to step 7; those are distinct source values, not the filtered records.
- Check the source data before filtering. Confirm that each column has a header, such as Date, Region, or Order ID, and that each row represents one record. Click a cell in the data. If it is already an Excel table, filter arrows usually appear in the header row. If it is a regular range, select a cell in it and choose Data > Filter. Excel adds dropdown arrows to the headers. Avoid selecting only one column when you intend to filter entire records, because the other columns must stay aligned with their rows.
- Apply the criteria you want to export. Select a header’s dropdown arrow and choose the values or conditions to keep. Depending on the column, you can select specific items or use options such as Text Filters, Number Filters, or Date Filters. For example, select the Region arrow, clear Select All, select West, and choose OK. Then filter the Date column if you also need a date range. Multiple filters work together: a row remains visible only when it meets all the active criteria.
- Review the visible results. Check the status bar or the worksheet to confirm that the displayed records make sense. Make sure the header row is included in the range you plan to copy, and look for unexpected blank values or totals rows. If the result is empty, loosen or clear a criterion and try again. Do not rely on the number of rows alone; confirm that the visible records match your intended selection.
- Select the full filtered range, including headers. Drag across the data and its header row, or click inside the table and use the selection tools to include all required columns. To avoid accidentally copying hidden rows, choose Home > Find & Select > Go To Special, select Visible cells only, and click OK. This explicit selection is useful when the range includes manually hidden rows as well as filtered-out rows. On Windows, you can also use Ctrl+G, choose Special, select Visible cells only, and click OK. On Mac, use the ribbon path; the keyboard shortcuts can differ.
- Copy the visible cells into a new workbook. Press Ctrl+C on Windows, create a new workbook with Ctrl+N, click cell A1, and press Ctrl+V. The copied results should include the header and the visible records, without the rows removed by the filter. If you want to place the export on a new worksheet in the original file instead, click the new sheet’s A1 cell and paste there. On Mac, use Command+C and Command+N; on either platform, use the ribbon’s Copy and Paste commands if you prefer not to use shortcuts.
- Export the choices in a filter dropdown, if that is what you meant. Clear or leave the original filter as needed, then copy the source column, including its header, to a separate worksheet. Select the copied values and choose Data > Remove Duplicates. Confirm that only the intended column is selected in the dialog and click OK. Excel keeps one instance of each value in the copied list. If you have Microsoft 365, you can instead create a sorted, distinct list. With source values in A2:A1000 and the formula entered in C2, use
=SORT(UNIQUE(FILTER(A2:A1000,A2:A1000<>""))). It returns the nonblank values once each, sorted alphabetically or numerically, and spills the results below C2. This formula requires Microsoft 365 or Excel 2021 for these functions; if your Excel version does not support them, use Remove Duplicates. - Check the pasted export and save it. Compare several rows and columns with the filtered source to confirm that the right records transferred and that the headers are present. Choose File > Save As, select a location, enter a file name, and choose Excel Workbook (.xlsx) if you want to preserve multiple sheets and workbook features. Choose CSV UTF-8 (.csv) if you need a plain-text file for another system. Excel may warn that CSV keeps only the active sheet and does not retain formulas, formatting, tables, or filters. Confirm the format only if that is acceptable.
Excel for the web uses a different interface in places, so the desktop Go To Special route may not match exactly. If you are working in a browser, apply the filters, copy the displayed results into a new workbook or sheet, and inspect the pasted rows carefully. For a dependable export that specifically excludes hidden rows, use the desktop app and select Visible cells only before copying.
Common Mistakes
- Copying the full range without checking hidden rows. A filtered display can make the selection look like a simple block. Explicitly selecting Visible cells only helps prevent hidden records from appearing in the export.
- Filtering just one column’s cells. Sorting or copying a single column separately can detach values from their original records. Apply filters to the complete table or data range, and export all the columns that belong together.
- Leaving out the headers. The exported values may be difficult to interpret or import without field names. Include one header row, but avoid copying extra title lines or report notes as if they were data headers.
- Saving as CSV when you need a workbook. CSV is useful for data exchange, but it does not preserve formatting, formulas, multiple worksheets, or filter settings. Keep an .xlsx copy when you need those features.
- Assuming a dropdown list is the same as filtered results. A filter result is a set of rows that meets criteria; the dropdown choices are distinct values from a source column. Choose the export method that matches what you actually need.
Tips
- Turn the source range into a table with Insert > Table if it is not already one. Tables keep headers associated with data and make filtering easier, especially when new rows are added.
- Use a new workbook for a shareable export. It keeps the original data and its filters separate from the delivered file, and makes it easier to remove confidential columns before sharing.
- If you only need a one-time export, paste the results as values using Home > Paste > Values or the paste options after copying. This avoids carrying formulas that might change or break when the source workbook is closed.
- Give the exported file a descriptive name that records the subject and date, such as West_Orders_2026-10.xlsx. Include the filter criteria in the file name or a note when recipients may need to know how the list was produced.
- For repeat exports, document the filters and check them each time. If the source table changes, a previously saved export does not automatically update unless you rebuild it or use a connected data workflow.
Troubleshooting
Hidden rows appear in the copy. Return to the filtered source, select the intended range, and use Home > Find & Select > Go To Special > Visible cells only before copying. Check that the selected range starts at the header and includes every required column. Copy and paste again into a clean destination.
The export is blank or missing expected records. Inspect each active filter arrow for selected values or conditions. Several filters combine, so a restrictive date condition and a region condition can leave no matching rows. Clear one filter at a time using the dropdown’s Clear Filter option, then reapply the correct criteria. Also check for leading or trailing spaces and inconsistent date or number formats in the source.
Only one column appears, or columns no longer match. Undo the paste if possible, then return to the source and select the entire data range rather than a single field. Ensure each record’s fields are in the same row and that no blank separator column divided the original range. Paste into a blank worksheet so existing content does not interfere.
Remove Duplicates removed values you wanted to keep. It changes the selected copied range, so use it on a duplicate of the source column, not on the original data. In the dialog, confirm that the correct column is selected and that My data has headers is checked when you included a header. If the list still looks wrong, check whether values differ by spaces, spelling, or number formatting; Excel may treat some apparently similar entries as distinct.
The CSV looks different when opened. CSV stores plain text values for one active sheet, not the workbook’s visual formatting or multiple tabs. Reopen the .xlsx copy if you need the original layout. If the receiving application expects a particular delimiter or encoding, check its import instructions and choose an appropriate CSV option, such as CSV UTF-8, when saving.
Frequently Asked Questions
Does Excel export only the rows that are visible after filtering?
Copying a filtered range generally copies the displayed rows, but selecting Visible cells only first is the clearest way to avoid including hidden rows. Review the pasted result before saving.
Can I export a filter list without changing the original workbook?
Yes. Copy the filtered results or source values into a new workbook, then save the new file. For a distinct dropdown-choice list, run Remove Duplicates on the copied column rather than the original one.
How do I export every available choice in a filter dropdown?
Copy the filter field’s source column to a separate worksheet and remove duplicates. The dropdown shows distinct values present in its data; blank entries may also appear if the source contains blanks.
Will the exported file keep the filters?
An .xlsx file can retain filters if you copy the table or set up filtering in the destination. A CSV file does not store filter controls. If the purpose is to deliver a fixed result, you can save the rows without active filters.
Can I repeat this export automatically?
For occasional use, repeat the filter and copy steps. For recurring reports, consider a PivotTable or a Power Query workflow, but verify that the refresh process and criteria match your reporting needs before relying on the output.
Related
- Enter Serial Numbers in Excel: Manual and Automatic Methods
- How to Enable Word Wrap in Excel and Adjust Cell Text
- How to Enable Wrap Text in Excel and Adjust Row Height
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Trim Excel Column Values and Remove Extra SpacesTo trim values in an Excel column, enter =TRIM(A2) in a blank column beside the first value, fill…
- Excel Formula: Capitalize Only the First Letter in TextTo capitalize the first character in a cell and make the remaining characters lowercase, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))), assuming the…
- Concatenate Excel Formula With Comma: ExamplesTo concatenate two cells with a comma and a space between them, use =A2&", "&B2. For example, if…
- How to Filter in Excel to Find the Exact Data You NeedTo filter in Excel, click a cell in your data, then choose Data > Filter; use the arrow…
- SUMPRODUCT Excel: Calculate a Weighted AverageIn Excel, calculate a weighted average with =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5), assuming A2:A5 contains the values and B2:B5 contains their weights.…
- Excel Function to Check If a Cell Contains TextTo check whether a cell contains a particular word or phrase, use =ISNUMBER(SEARCH("text",A2)), replacing “text” with the text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.