How to Import Web Data Into Excel

Ready to start saving hours of work? Try RPA CLOUD now!

While it’s true that various methods on how to import web data into Excel, the real challenge lies in the manual effort involved.You often find yourself opening web pages, Excel files, or clicking the refresh button repeatedly.

What if there was a way to automate all of this?

Enter RPA CLOUD – your solution to seamless and effortless data importation. Let’s explore the incredible efficiency that RPA CLOUD brings to importing data from the web to Excel!

Import Web Data into Excel manually

Method 1: Import Data from Web

  1. Open Excel: Open Microsoft Excel on your computer.
  2. Go to the Data Tab: Navigate to the “Data” tab on the Excel ribbon.
  3. From Web: Click on “From Web” in the “Get External Data” or “Get Data” group.
  4. Enter URL: Enter the URL of the website from which you want to import data and click “OK.”
  5. Navigate and Select Data: Excel will open a new window where you can navigate the website. Click on the data you want to import. You’ll see a yellow arrow next to the data you’ve selected.
  6. Import Data: Click on the yellow arrow, and then click “Import.” Choose the location where you want to place the data (e.g., a new worksheet) and click “OK.”

Method 2: Copy and Paste

  1. Open Web Page: Open the web page containing the data you want to import.
  2. Select and Copy Data: Highlight the data you want to import, right-click, and choose “Copy” or use Ctrl+C (Windows) or Command+C (Mac).
  3. Open Excel: Open Excel and go to the worksheet where you want to paste the data.
  4. Paste Data: Right-click on the cell where you want to start the data, and choose “Paste” or use Ctrl+V (Windows) or Command+V (Mac).

Method 3: Web Query

  1. Open Excel: Open Excel and go to the “Data” tab.
  2. New Query: Click on “Get Data” or “New Query” and select “From Other Sources,” then choose “From Web.”
  3. Enter URL: Enter the URL of the website and click “OK.”
  4. Navigate and Select Data: Excel will open a new window. Navigate to the data you want, and select it. Click “Load” to import the data.

These steps are a general guide, and the exact options and steps might differ slightly based on your version of Excel. Always check the Excel version you are using for any variations in the steps.

Using RPA CLOUD to automatically import data into Excel

  1. Open Browser: Choose “Open Browser” to access your desired website.
  2. Extract Data From Table: Copy the CSS Selector of the table on the web from which you want to extract data. If you’re unsure about CSS Selector and how to obtain it, please refer to this article.
  3. Create New File excel: Utilize this step to generate an Excel file for inputting the data obtained in step 2.
  4. Select Sheet Excel: Pick the sheet where you wish to input the data. The default sheet name is “Sheet,” but feel free to customize it.
  5. Write range: Finally, opt for the “Write Range” step to input the data obtained in step
Using RPA CLOUD to automatically import data into Excel

Now, with just five straightforward steps, you can observe the following results:

The result after the robot has executed.
The result after the robot has executed.
The Excel file after being filled with data from the web.
The Excel file after being filled with data from the web.

After ensuring that your robot has executed correctly, you can set a schedule for the robot to run at your preferred time.

Experience the unmatched power of automation with RPA CLOUD. Unlock efficiency, save time, and boost productivity—all at an incredibly affordable price you won’t find anywhere else. Join hands with our dedicated and supportive team to make your automation journey seamless. Don’t wait; seize the opportunity. Use RPA CLOUD now and transform the way you work!

logo-rpa-centre

RPA CLOUD automate repetitive tasks for you!

logo-rpa-centre

RPA CLOUD
Automation Bot

I'm Neo, an RPA expert with over 10 years of experience. I have successfully implemented many complex RPA projects for large global enterprises, with extensive knowledge of leading technologies such as RPA CLOUD. My mission is to optimize performance and enhance automation in enterprise environments, delivering the most value to customers and helping them adapt and thrive in an increasingly competitive business world.