Scrape tabular data from web and transfer it to Excel

Call: 1-888-484-3535

Home > Product > Solutions > Web Data Extraction > T75

T75 - Scrape tabular data from web and transfer it to Excel

Task Description

Scrape the tabular data from the web and transfer it to Excel.

T75.atmn

Solution

	Record a new task Click on Tools->Web Recorder Specify your website from where you want to scrape the tabular data. Click on Extract Table in the toolbar on the bottom right hand corner of the screen. Click on the table that has the data that you want to scrape for e.g. as shown in Screenshot 1. Specify the path of the CSV file where you want to import the data. Click on Stop Recording and save the task.	Screenshot 1 Screenshot 2 Screenshot 3 Screenshot 4
	Import data into Excel To import the data extracted from the import table, into Excel based on certain conditions, you need to edit the recorded task. Select the task in the Task List and click on Edit. Insert ‘Open Spreadsheet’ Excel command to open the excel file where you need to import the extracted data. You can find Excel command under ‘Applications’ command category. Insert a Loop for Each row in an Internet Explorer Table to process all the extracted rows. Insert the condition based on which you want to filter the data. For e.g. Screenshot 2 shows how to avoid importing products that includes ‘AA Standard’ versions. Insert ‘Set Cell’ excel command to set the extracted value in excel. Screenshot 3 Insert ‘Go to Cell’ excel command to go to one cell right or down. The final task will look as shown in Screenshot 4
	How to run the task: In case you do not have Automation Anywhere installed, please download and install it from, http://www.automationanywhere.com/download/freeTrial.htm Save T75.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks Copy Data.xls under C:\ Launch Automation Anywhere and from Task List select T75.atmn and click on RUN button to run the task.

When you run this task it will extract the tabular data and import the data into Excel.

Next Steps

Call 1-888-484-3535

25,000+ Customers

Customer list | Case Studies

I LOVE Automation Anywhere! It's allowed us to stop paying a part-timer to scrape different websites for the data we need, which was a tedious job to begin with. I was also very impressed with the support I received. I had a problem that AA support team was very responsive and helpful with, time and again, until we figured it out. Great product, great support, great company! Thanks

- Joe Brillante
PostBankruptcy Report

Read Customer Testimonies >>

Products Download Purchase Services Support Customers Company Sitemap Trademark