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.
2 Suitable Ways to Automate Copy and Paste from Website to Excel
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.
Read More: All Paste Options in Excel with Time Saving Shortcuts
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 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 them. You can add more columns or merge columns and so much stuff like that.
Steps:
- First of all, open a new Excel
- Then, go to the Data
- 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.
Read More: Exchange (Copy, Import, Export) Data Between Excel and Access
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. Please visit Exceldemy for more useful articles like this.
Related Articles
- VBA Paste Special to Copy Values and Formats in Excel (9 Examples)
- Macro to Copy Data from One Workbook to Another Based on Criteria
- Excel Formula to Copy Cell value to Another Cell
- How to Copy the Same Value in Multiple Cells in Excel (4 Methods)
- Copy Data from One Cell to Another in Excel Automatically
- Excel VBA: Copy Cell Value and Paste to Another Cell
- How to Copy Multiple Cells to Another Sheet in Excel (9 Methods)