If the site is on your local PC, there are two Linux command line utilities, called grep and sed (or Super Sed, ssed, which is even better), that together should be able to do this extraction for you. There are versions of grep and ssed for Windows, also.
What they can do is extract the relevant text from the pages and store it in a separate text file which you can then import into Excel.
The downside is that learning them is not easy. However, if it's a big site, the days you spend figuring out how to use the utilities might still be less time than you'd spend doing the extraction manually, and at the end you'd know how to use two extremely useful text processing tools.