Step-by-step tutorials for you to get started with web scraping

Download Octoparse
  1. Tutorial
  2. Getting Started
  3. Download data
  4. How to download extracted web data as CSV, XLS, JSON or HTML?

How to download extracted web data as CSV, XLS, JSON or HTML?

Thursday, August 16, 2018

Octoparse supports exporting extracted data as structured formats, such as CSV, Excel, JSON or HTML.  Whether with local extraction  or cloud extraction , the extracted data can be accessed easily from the dashboard.

  • Select "More Actions"
  • Select "View Data" to view "Cloud Data"/ "Local Data"

Web scraping with Octoparse - Export data as structured format 


By clicking on the "Export" button located at the lower right corner, you will be prompted to choose which form at to export the data as also whether you would like to export all available data or just the un-exported ones.

Web scraping with Octoparse - Export data as structured format 

 

Tips!

  • Octoparse provides API access for data retrieval as well as managing the various task parameters (learn more the Octoparse API ).
  • Octoparse also supports data export to various databases, including SqlServer, MySql, and Oracle (learn more about data export to databases ).
  • For local extraction, you can always click on "Export Data" as soon as the extraction's been completed. 

Web scraping with Octoparse - Export data as structured format

  • Data extracted in the cloud can be further scheduled for auto-export to databases (learn more about scheduling data export to databases ).
  • Cloud data is stored for 3 months. After 3 months, data will be removed.
  • Data extracted locally will be cleared as soon as the next run is executed.

 

Related Articles:

What's new in Octoparse 7.X? 

Dealing with AJAX 

Select items in a drop-down menu 

Use lists to extract 

Extract multiple pages through pagination 

 

 

PREVIOUS POST
Run/Schedule web scraping tasks in the cloud <

Download Octoparse to start web scraping or contact us for any
question about web scraping!

Contact Us Download
btn_sidebar_form.png
© 2019 Octopus Data Inc.
btn_sidebar_use.png
btn_sidebar_form.png
© 2019 Octopus Data Inc.