T78 - Scrape tabular data from web and transfer it to your own application |
Task Description |
Scrape the tabular data from the web and transfer it to your own application.
|
| Solution |
 |
Create a new task
- Click on Tools->Web Recorder
- Specify your website from where you want to scrape the tabular data.
- Click on Import 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.
- See how to create a task
|
Screenshot 1
Screenshot 2 |
 |
Import CSV file to your proprietary application or database
- The imported CSV file would look as shown in Screenshot 2
- Once you have imported the data to a csv file, you can import the CSV file into your application or database for further processing.
|
|
| |
| When you run this task it will extract the tabular data to a CSV file. |
|
 |
| 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 >> |
|
