Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will explain 2 easy ways to automate copy and paste from website to Excel.
Automate Copy and Paste from Website to Excel: 2 Suitable Ways
This is the dataset of today’s article. It’s the career statistics of a footballer available on Wikipedia.
I will copy and paste this dataset from the website to Excel.
1. Use Copy and Paste Feature to Copy and Paste from Website to Excel
The first method is the use of the Copy and Paste feature. This is a simple method.
Steps:
- First of all, copy the dataset from the website.
- Then, copy it by pressing CTRL+C.
- After that, open a new Excel.
- Then, select the entire sheet by clicking the icon at the top left.
- Then, press CTRL+V to paste the dataset.
- A message box will appear. Click OK.
- Excel will paste the data from the website.
2. Apply PowerQuery Feature to Copy and Paste from Website to Excel
The next step is to use the PowerQuery feature to automate copy and paste from the website to Excel. Power Query is a very powerful tool in Microsoft Excel 2010 and later. It can clean up and automate data in Excel. The Power Query is also known as “Get & Transform Data”. So, the primary purpose of the Power Query can be divided into two main categories,
- Get Data &
- Transform Data
Get Data: You can retrieve data from anywhere into Excel such as Databases, other Excel files, or web pages. This is a powerful feature to input raw data into the Excel sheet.
Transform Data: After importing data, you can use this tool to clean up your data by rearranging it. You can add more columns or merge columns and so much stuff like that.
Steps:
- First of all, open a new Excel file.
- Then, go to the Data tab.
- After that, select From Web.
- A window will open. Paste the URL of the webpage.
- Then, click OK.
- After that, another box will appear. Click Connect from the box.
- Now, from the Navigator field, choose the dataset you want to transfer.
- Then, click Load.
- Excel will load the dataset in a new worksheet.
Things to Remember
The format of the copied data may not be the way you want it to be. So, you can format it later.
Conclusion
In this article, I have explained 2 ways to automate copy and paste from website to Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.