It may be an inefficient way by using the above method, here, I can create a VBA code for helping you export the filtered data to csv file quickly and conveniently.ġ. Then click Save to save this filtered data, and some warning messages will pop out, please click OK and Yes to close the messages, and then only the filtered data is saved as csv file in your selected directory. Now, you can save this new worksheet as csv file, please click File > Save As, in the Save As dialog box, specify a name and location for this file, and select CVS(Comma delimited) from the Save as type drop down list, see screenshot:Ħ. Then click OK button, and then copy and paste the filtered data to a new worksheet, and only the filtered data has been pasted into the new worksheet.ĥ.
In the Go To Special dialog box, choose Visible cells only option, see screenshot:Ĥ. Then click Home > Find & Select > Go To Special, see screenshot:ģ.
Select the filtered data that you want to save.Ģ. In Excel, you may not save the filtered data to csv file directly, but, you can finish it with a workaround, please do as follows:ġ. Save / Export only filtered data from Excel to csv file Kutools for Excel Save / Export only filtered data from Excel to csv file with VBA code Save / Export only filtered data from Excel to csv file with Copy Visible cells only But, have you ever tried to save only filtered data as csv file? Normally, the Save As feature In Excel will save the whole worksheet data as csv file, in this case, how could you save or export only filtered data from Excel to csv file?
How to save / export only filtered data from Excel to csv file?Īs we all known, it is easy for us to save a worksheet as csv file.
0 kommentar(er)
