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.
Excel – Saving filtered results from an Excel workbook to a CSV file
csvmicrosoft excel
Related Solutions
In this question, you will find Excel indeed does not preserve unicode characters when saving as csv. Their solution is to save as unicode tab separated text
To save with Unicode encoding in Excel,
Save as, choose text, then next to the save button, you see "tools" menu. Choose web options, then encoding tab, then select the encoding you like. I would suggest to save everything in UTF8, but that is your choice. Note this is in Excel 2007 or above.
Go to the Data tab and select text to columns under data tools then select delimited and hit next. Then select comma as the delimiter and hit finish
Best Answer
Use an advanced filter to filter and paste the results as values into a new worksheet in one go which at least saves a step and is probably more reproducable in fewer clicks every time after the first. You can also select only the columns you want and in any order.
Debra's site is probably the best resource for examples on this:
[www.contextures.com][1]
[1]: http:// www.contextures.com