Is there any way to find keywords in multiple sheets in multiple excel files together?

[zhengtianxiang]

Hi everyone,

I am working on a project about keyword search. I have keywords list(.xlsx). I need to search these keywords in multiple excel files with multiple sheets in a folder, to see whether&where these keywords appear. I was stuck on how to read these sheets and search the keywords. I am reaching out to you guys for help.

Thanks.

[binuacs]

@zhengtianxiang With the help of a batch macro extract all the sheet names from the given Excels files then combine all the sheet data into one and use the find and replace tool to search, the below post might be helpful for your use-case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Read-data-from-multiple-excel-...