Automation Anywhere Call: 1-888-484-3535   

 
Automation Anywhere
  Home > Product > Solutions > Web Data Extraction > T79  
T79 - Scrape unstructured data from the web and transfer it to Excel
Task Description
Scrape unstructured data from the web and transfer it to Excel.

Solution
Open the web page

  • Start Internet Explorer and specify the URL of the webpage from which you want to extract data.

Screenshot 1


Screenshot 2



Screenshot 3
Create a new task

  • Click on Tools->Task Editor
  • Specify the command to select (Ctrl + a) and copy (Ctrl + c) the entire webpage.
  • Add the command to paste the contents copied into Notepad (Ctrl + v).
Find the information required

  • Specify the command to find the information required (Ctrl + f).
  • In the Find window specify the information you want, for example Firstname and press Enter. This command will find the word Firstname in the data copied.
  • Now we need to add the command to move to the beginning of the data to be extracted (Right Arrow).
  • Add the actual command to select (Shift + End) and copy (Ctrl + c) the data from notepad.
Import date into Excel

  • Insert the actual Keystrokes (Ctrl + v) to import the data into Excel.
  • The above commands will extract and transfer the data for a single field. If you want to do the same for all the fields you need to insert a Loop List Variable command. The final task will look as shown in Screenshot 2
  • See how to create the task.
 
When you run this task, it will copy the information required from the web page and paste it into the an Excel worksheet.
Automation Anywhere

Next Steps
Buy Now Buy now
Download Free Trial Download free trial
Compare versions Compare versions
Watch a flash demo Watch a flash demo
Contact me Contact me
Ask the Expert Ask the Expert
Request live demo Request live demo

Call 1-888-484-3535

Our Customers
ibounce

Wow! This program is fantastic. I was given the task to figure out how to get a list of over 1000 contacts off of a website and into Excel. I was trying to write some kind of macro for days through Excel's VB extension and was making no progress. So I went online and found Automation Anywhere, it took me only minutes to write a macro to copy the addresses. I owe Tethys Solutions hours of my life that I was prepared to spend copying and pasting. Thank you so much Tethys"
- Ben Kinney, Monterey media

Read Customer Testimonies >>
  Products     Download     Purchase     Services     Support     Customers     Company     Sitemap     Trademark © Tethys Solutions 2008 Privacy Policy
View Demo View Demo