List/Table Web Page - Advanced ModeThursday, March 24, 2016 5:14 AM
Extract A List/Table from Webpages
Step 1. Download Octoparse and install it. Register a new account at www.octoparse.com. Or directly click the “Sign up” option the Login interface.
Step 2.Advanced Mode: Go to “Advanced Mode” ➜ “List or Table” ➜ “Start”.
Step 3. Complete basic information. ➜ Click “Continue” ➜ Click “Next”.
Step 4. Enter the target URL in the built-in browser. ➜ Click “Continue”. ➜ “Go” icon to open the webpage.
Step 5. Click "Next" ➜ “Loop click next page”( Note: Create a loop action to process all the web pages. ) The action of pagination has been added to the extraction rule.
Step 6. Click the first highlighted section.
Create a list of sections with similar layout. Click "create a list of items”. ➜ "Add current item to the list". Then the first highlighted section has been added to the list. ➜ Click "Continue to edit the list".
Click the second highlighted section.
Click "Add current item to the list" again. Now we get all the sections with similar layout.
Then click "Finish Creating List".
Click“loop” to process the list for extracting the elements in each section.
Step 7. Extract "music video" and "views" of the first section. ➜ Click these two elements. Select "Extract text".
Step 8. All the content will be selected in Data Fields.
Before executing the extraction rules, drag the second “Loop Item” before "Click to paginate" action in the Workflow Designer so that we can grab all the elements of sections from multiple pages.
Click “Next” ➜ Click “Next”.
Step 9. Click “Local Extraction”. ➜ “OK” to run the task on your computer. Octoparse will automatically extract all the data selected.
The data extracted will be shown in "Data Extracted" pane. Click button to export the results to Excel file, databases or other formats and save the file to your computer.
Happy Data Hunting!
Author: The Octoparse Team
For more information about Octoparse, please click here.
Sign up today.
If this video tutorial is not available for you, you can click hereto see the corresponding graphic tutorial.