How to scrape any website to an Excel spreadsheet

Excel can be a powerful tool for keeping track of scraped data. 

You can perform simple tasks like filtering, sorting, using pivot tables, and creating charts based on your data.

But… How can we efficiently extract data from the web and export it to Excel for further processing?

In this tutorial, we will walk you through how to use Hexomatic to scrape data from any website and export it to an Excel spreadsheet.

Step 1: Create a new scraping recipe

To get started, create a blank scraping recipe.

Step 2: Add the web page URL

Add the web page URL and click Preview.

Step 3: Choose the elements to scrape

Now, you can select all the elements that you want to scrape.

In this case, we are going to scrape headings and descriptions of articles in the Lifestyle category.

To select all the existing elements of the same category, you should click on the element, then choose the select all option. 

Then, click Save.

Step 4: Create a new workflow

To run the scraping recipe, you need to create a blank workflow and add the scraping recipe to it.

Create a new workflow, then choose Data automation as your starting point.

Step 5: Add the web page URLs

Next, add the copied URLs using the Manual paste/list of inputs option.

Please, note that the pages need to share the same HTML structure. 

Step 6: Add your scraping recipe

To automatically scrape data from the inerted web pages, you need to add your previously created scraping recipe to the workflow, selecting data input as the source. 

Step 7: Run the workflow

Run your workflow to get the results.

Step 8: View and save the results

Once the workflow has finished running, you can view the results and export them to CSV or Google sheets. 

In this case, we will export the results to a CSV file. 

---

Automate & scale time-consuming tasks like never before