How to scrape data from any website to Excel
Tags: tutorial, webscraping
Published: 2023-10-12 08:14:05

---
title: How to scrape data from any website to Excel
published: true
date: 2023-07-03 22:00:00 UTC
tags: tutorial, webscraping
canonical_url: https://blog.apify.com/how-to-scrape-data-from-any-website-to-excel-in-3-easy-steps/
---

 **Hi, we're** [**Apify**](https://apify.it/platform-pricing) **. The Apify platform gives you access to 1,500+ tools to extract data from popular websites.** [**Check us out**](https://apify.it/platform-pricing) **.**

[Attracting over 750 million users worldwide](https://www.investintech.com/resources/blog/archives/5718-experts-predict-the-future-of-excel-in-business-intelligence.html#:~:text=With%20over%20750%20million%20users,for%20presenting%20and%20analyzing%20data.), Microsoft Excel is one of the most popular applications for organizing, formatting and calculating data. Excel files are a great example of [structured data](https://blog.apify.com/when-data-gets-too-big-why-you-need-structured-data/), allowing users to easily manipulate datasets and gain insight into gathered data thanks to tables, graphs, and other visualizations.

But if you use Excel a lot, sooner or later, youre probably gonna come across online data that youd like to feed to your table. In this article, well show you four ways you can import any website into a structured Excel file.

- Manual copy and pasting

- Implementing web queries

- Excels VBA language

- Using web scraping tools

![illustration of a file on one laptop turned to an Excel file on another](https://blog.apify.com/content/images/2022/07/title-1.jpg)

_There are multiple ways of turning a website into an Excel table, some more complicated than others_

## **Manual copy and pasting**

Depending on the amount and format of the data you want to pull into Excel, manual copying and pasting is always an option - although often a lengthy and tedious one. It is still used in areas such as [manual product mapping](https://blog.apify.com/product-matching-ai-pricing-intelligence-web-scraping/#%F0%9F%92%AA-what-about-manual-mapping), which require further interaction and input from the user. It can also be useful when the data you want to extract is already in a table format: for instance, here we simply copy and paste the HTML table from our [Python libraries](https://apify.hashnode.dev/what-are-the-best-python-web-scraping-libraries) blog article. But keep in mind that the [vast majority of online data is unstructured](https://blog.apify.com/when-data-gets-too-big-why-you-need-structured-data/#what-is-big-data-and-why-structured-data-matters), so this method will probably be irrelevant for most use cases.

![screenshot of a HTML table being copied into Excel](https://blog.apify.com/content/images/2023/07/excel_copypaste.png)

_Copy and pasting is only effective when the data is already structured_

## **Implementing web queries**

If youre using Windows, you can use Microsofts [Power Query](https://powerquery.microsoft.com/en-us/) feature set to get automated structured data straight to your Excel sheet. Simply go to the Data tab, select From Web, and input the URL of the website youd like to export data from. The software will then process the page and find any usable tables that it can pull from the page. After you have the data, you can refresh the query at any time, updating your sheet at the click of a button. While this method is useful for keeping your dataset up to date, it can also only work with data thats already structured. Another disadvantage is that Power Querys ability to get web data is [limited to the Windows operating system](https://answers.microsoft.com/en-us/msoffice/forum/all/copying-and-pasting-web-tables-into-excel/2f88969c-49ab-4e91-8cb3-4a125c2a9486), so Mac and other OS users are out of luck here.

![screenshot of Excel with the cursor pointing to From Web in the Data section](https://blog.apify.com/content/images/2023/07/excel_webqueries.png)

_source:_ [_Microsoft Support_](https://support.microsoft.com/en-au/office/import-data-from-the-web-b13eed81-33fe-410d-9247-1747269c28e4)

## **Excels VBA language**

Microsofts VBA ([Visual Basic for Applications](https://learn.microsoft.com/en-us/office/vba/library-reference/concepts/getting-started-with-vba-in-office)) is an implementation of the event-driven programming language Visual Basic into the Office ecosystem. It allows users to access functions beyond what is available in Microsoft Office, letting them automate processes, create macros, custom forms or customize applications to fit their specific business needs. But implementing data extraction into your Excel sheet with VBA requires advanced programming and web scraping knowledge. You will also need to install libraries such as [Selenium](https://blog.apify.com/web-scraping-with-selenium-and-python/#what-is-selenium) or Microsoft XML HTTP based on if you want to [extract data from a webpage that runs scripts](https://www.youtube.com/watch?v=E3u_1e3wg74&t=75s). Since using this method is fundamentally the same as [web scraping](https://apify.com/web-scraping), it might be better to use data extraction tools outside of Microsofts ecosystem for a more flexible workflow with more in-depth documentation.

## **Using web scraping tools**

[Web scraping](https://blog.apify.com/what-is-web-scraping-and-web-scraping-tools/) lets you automate the process of data extraction, minimizing the effort put into gathering web data in bulk. Unlike the first two methods, you can scrape any unstructured data from the website, be it product names, prices, headings, descriptions, and so on. This data is then stored in a structured format, and depending on the API youre using to scrape the web, it can also be exported into machine-readable formats such as XLS (Microsoft Excel).

You can build your own web scraper with [Node.js](https://blog.apify.com/web-scraping-javascript-nodejs/#http-clients) or [Python libraries](https://blog.apify.com/what-are-the-best-python-web-scraping-libraries/) such as Requests, HTTPX, Selenium, or Playwright, or use pre-made tools where you simply input your desired URL or search query. Apify is a full-stack platform that lets you do both - you can build ([or import](https://docs.apify.com/platform/actors/development/source-code)) your own scraper with our [web scraping templates](https://apify.com/templates) or use a ready-made Actor from [Apify Store](https://apify.com/store) to get the job done.

So, lets take a look at how you can get data from any website in 3 simple steps using APIs found on Apify Store:

### **Step 1. Find the right tool**

Apify Store works just like any other app store: just search for an Actor youd like to use based on the website you want to scrape. Most scrapers are free, although you may come across some paid ones - no need to worry; even these offer a free trial without the need for a credit card. After you find your scraper, click the _Try for free_ button. For this example, were going to be using [Twitter Scraper](https://apify.com/vdrmota/twitter-scraper?ref=blog.apify.com).

![screenshot of Actors on Apify Store](https://blog.apify.com/content/images/2023/07/step1.png)

_Find a suitable Actor on_ [_Apify Store_](https://apify.com/store)

> 🤔 [Cant find the right Actor for your use case? Try out the universal Web scraper, which can extract data from any website after a little bit of setting up](https://apify.com/apify/web-scraper)

Youll then be prompted to sign in or make an account if you dont already have one. You can speed up the process by signing in through your Google or GitHub profile.

![Screenshot of Apify Console's sign up page](https://blog.apify.com/content/images/2023/07/step2.png)

_Sign in or make an account to access_ [_Apify Console_](https://console.apify.com/)

### **Step 2. Choose the data you want to scrape**

Now, fill in the input schema to tell your Actor what data you want from the website of your choice. With Twitter Scraper, we decided to scrape the top 30 results from the handle [@apify](https://twitter.com/apify?ref=blog.apify.com) (yup, were also on Twitter, so dont forget to give us a follow). This feature is especially relevant if you know [how to use mail merge](https://mailtrap.io/blog/mail-merge-explained/) and want to gather data that helps you tailor outreach or PR messages, for instance.

If youre not sure what the individual inputs mean, hover your mouse over the question mark next to them to get an explanation. The Actor readme (you can find this on the Actors page in Apify Store) can also be of great help if you feel lost when filling out the schema.

![Screenshot of the input schema for Twitter Scraper](https://blog.apify.com/content/images/2023/07/step2a.png)

_Fill out the Actor's input schema_

### **Step 3. Run the scraper and download your results in Excel**

After youre done filling out the input, hit **Save & Start** to kick off the Actor run. Now just wait for the scrape to finish.

![Screenshot of an Apify Actor running](https://blog.apify.com/content/images/2023/07/step3.png)

_You can watch your results load in the Output tab_

As soon your run is finished, you can hit the **Export results** button at the bottom of the UI. Here you can choose your desired output format (in our case Excel) and which fields from the table you want (or dont want) to export.

![Screenshot of the Export dataset pop-up on Apify Console](https://blog.apify.com/content/images/2023/07/step4.png)

_Download your data in an Excel format_

> Tip: Not every scraper has the _Output_ / _Overview_ tab. If thats the case, go to _Storage_ to get the full data in Excel.

* * *

And thats it! Now that you have your data, its time to explore the world of web scraping with a bigger pool of Actors: Interested in social media? Try our [Instagram](https://apify.com/jaroslavhejlek/instagram-scraper?ref=blog.apify.com), [TikTok](https://apify.com/clockworks/tiktok-scraper), or [Reddit](https://apify.com/comchat/reddit-api-scraper) scrapers. If youd prefer to scrape product listings and their sellers, give the [Amazon](https://apify.com/vaclavrut/amazon-crawler?ref=blog.apify.com), [eBay](https://apify.com/dtrungtin/ebay-items-scraper?ref=blog.apify.com), or [AliExpress](https://apify.com/epcsht/aliexpress-scraper?ref=blog.apify.com) scrapers a go. Looking for new hires? Scrape job listings from [Indeed](https://apify.com/misceres/indeed-scraper) or [Glassdoor](https://apify.com/alexey/glassdoor-jobs-scraper?ref=blog.apify.com). You can even further [integrate](https://apify.com/integrations) these tools with other platforms, to bring your web scraping workflow to the next level 🚀

Missing an Actor in Apify Store? You can contribute by [monetizing your own code](https://apify.com/partners/actor-developers) or [publishing an idea](https://apify.com/ideas) as an inspiration for our developer community. And if you need any advice from web scraping and automation enthusiasts, theres always our [Discord channel](https://discord.com/invite/crawlee-apify-801163717915574323).