How to Automate Copy and Paste from Website to Excel

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.

Dataset for automate copy and paste from website to excel

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.

copy and paste from website to excel

  • Then, press CTRL+V to paste the dataset.
  • A message box will appear. Click OK.

  • Excel will paste the data from the website.

copy and paste from website to excel

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.

PowerQuery feature to copy and paste from website to excel

  • 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.

PowerQuery feature to copy and paste from website to excel

  • Excel will load the dataset in a new worksheet.

PowerQuery feature to copy and paste from website to excel

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

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo