Give it a try with the steps below or continue reading to learn more.
Scraping a table is very easy. We always recommend using our quick Right Click - Get Similar Method. The process is simple, highlight a few rows of the table, right click and then select get similar. This will auto generate a recipe and save it to your My Recipes. You can then later access the recipe and rename it to use it again. See a demo below
Right Click - Get Similar is a great way to quickly extract a single table. However, it does not come with pagination. If your table has multiple pages, you might be better off using a public recipe. To use a public recipe, you must first find the data you want to scrape. Data Miner can only extract data when it's visible in your browser. Next, open up the Data Miner extension and find the recipe that best describes your data. Then click on it. Once the recipe runs, click download and open it in Excel. If there doesn't appear to be any recipes under the public tab, this means no other customers have created any yet and you will have to create your own.
You should always find a few generic recipes on any page. These are designed to extract simple items and should work for any site. Below is the pop up where you'll find the public recipes.
If you're trying to scrape a table with multiple pages and not having any luck with public recipes, you can always easily create your own recipe. Our recipe creator has a smart find tool that allows you to extract data without having to write any code.
The first video above will walk you through the basic process of creating a recipe for a table.
However, if you get stuck below is an example of what your selectors might look like:
Column 1: td:eq(0)
Column 2: td:eq(1)
Column 3: td:eq(2)
and so on...
Next Page: a:contains(Next)
If you'd like to learn more about Data Miner, we'd recommend checking out our advanced features in the Advanced Learning section.