Forum Discussion
Daniel Westerdale
Dec 05, 2017Iron Contributor
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 please.
1 Reply
Sort By
- Mark FitzgeraldIron Contributor
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.