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