Help Menu

Extract Filtered Data

The Extract Filtered Rows tool will take the selected columns from a table (or worksheet range) and output them to a new worksheet. It is designed to be used in conjunction with Excel's built-in row filtering tools available when you use Format as Table in Excel. The Extract Filtered data will only extract the visible rows and selected columns to a new worksheet or workbook.

Form Fields

  • Select Source Table: Select the workbook, worksheet, and range where the data is located. The table does not have to be an Excel table - any range will work.
  • Select Columns to Extract: Select the columns that you want included in the output table. At least one column must be selected.
  • Output To: You can output to a new worksheet or to a new workbook.
  • Worksheet name: Optional field to name the output worksheet.