Batch Filter Excel Sheets

Overview

This app allows you to filter sheets in a single Excel file or across multiple files in a specified folder based on your criteria. It exports the filtered data and headers from their original locations, row by row, to a designated folder. This app is ideal for users needing to extract specific data from large Excel files efficiently.

How to Use

1. Download the app from Octoparse AI app store

2. Launch the app in your list.

   

   1. Parameter Description

      

      1. ExcelFilePath: To process a single Excel file, select or enter the absolute file path of the Excel file to be filtered.

      2. FolderPath: To process multiple Excel files, select or enter the absolute file path of the folder containing the Excel files. The app will filter all .xlsx files within this folder.

      3. ContentToFind: Enter the text you want to find. If you need to search within a specific column, use the format "column number:text" (e.g., "2:ID" searches for "ID" in the second column).

      4. ExportFilePath: Select or enter the absolute path where the filtered results will be saved as "BatchFilterResults.xlsx".

      5. MatchingMethod: Choose "equal" or "contains." "Equal" includes only exact matches, while "contains" includes all cells that contain the filter criteria.

   2. Click "Run application"

3. Output

   The application will generate filtered sheets based on your criteria and save them to the specified folder.

   

Notes

• Do not use the mouse or keyboard while the app is running to avoid interruptions.

• The app operates on text-based .xlsx files; please convert any other formats to .xlsx first.

• Multiple criteria are supported and separated by commas (e.g., "Criteria1, Criteria2").

• Please do not fill in both "ExcelFilePath" and "FolderPath" at the same time.

Support

Encounter obstacles but don't know how to resolve them when executing the app?

Please contact our support team at [email protected] to find the way out!