Home » Questions » Computers [ Ask a new question ]

Saving filtered results from an Excel workbook to a CSV file

Saving filtered results from an Excel workbook to a CSV file

I have an Excel workbook with a lot of rows in it. I filter it using the values of one column and then I want to save the filtered results to a CSV file. When I do "Save as..." I get all the rows. I can copy paste the filtered results to another sheet and save from there but I'd rather not. It's Excel 2003 primarily.

Asked by: Guest | Views: 72
Total answers/comments: 1
Guest [Entry]

Use a pivot table. Click on any location in your table, Click Insert, select Pivot Table, then set up the columns you want to keep. You can filter a Pivot table then save as CSV or text (tab delimited). It saves only the filtered pivot table.