Forum Discussion

Daniel Westerdale's avatar
Daniel Westerdale
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 please.

 

 

 

 

excel

1 Reply

Sort By
  • Mark Fitzgerald's avatar
    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.

Resources