Looking for a web scraper tool to extract entire table out of web pages and put them in different sheets in excel

Question

The first column of this table contains all the links I have to work with: https://www.metabolomicsworkbench.org/data/DRCCStudySummary.php?Mode=StudySummary&SortBy=Analysis&AscDesc=asc&ResultsPerPage=2000

From each of the links I have to download entire tables like this: https://www.metabolomicsworkbench.org/data/show_metabolites_by_study.php?STUDY_ID=ST000886&SORTFIELD=moverz_quant

and put each of the table from each of the links into separate sheets in excel.

I'd highly appreciate if anyone could tell me how to automate the entire process.

P.S.: I can't code...

Answer 1

ParseHub is a tool that is free and powerful web scraper to scrape data from tables. I have used it in the past by following this step by step description:

NO CODING NEEDED.