Forum Discussion

Iron Contributor

Dec 05, 2017

Exporting filtered data to .CSV

hi I want to quickly export only the visible data in a filtered Excel 2016 view to a .CSV file . This is proving quite tricky as I seem to keep picking up the other rows. Any advice pleas...

excel

Mark Fitzgerald

Iron Contributor

Dec 06, 2017

Copy the filtered data to a new workbook and paste as values. This should only paste the visible cells. Save the new workbook in csv format.