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

Download Octoparse

Lesson 8: Export data extracted

Thursday, August 16, 2018

Octoparse supports data export to various output formats, including XLS, JSON, CSV, and HTML. Alternatively, you can also export the extracted data to your local database. Better yet, have the data delivered to your own applications by connecting to the Octoparse API. 

See our API documentation for details: http://dataapi.octoparse.com/help

 

1. Output file formats supported

    · Excel 2007(xlsx)

    · Excel 2003(xlsx)

    · JSON (New in Octoparse 7.X!)

    · CSV

    · HTML

Tips!

We've added a new output format – JSON in Octoparse 7.X version!

 

2. Local databases supported

    · SQL Server

    · My SQL

    · Oracle

Tips!

Currently, Octoparse does not support cloud databases like AWS database, Azure, Cloud SQL database, etc.

 

3. Download local data

There are two ways to download data extracted locally:

1. Once a local run has finished or been stopped,

  • Click on  to export the data
  • Select your preferred format to export the data as
  • Click "Export data"

2. Data extracted in the current local run is saved temporarily as local data 

    · Click "More action" on the dashboard

    · Select "View data"

    · Select "Local data"

    · Click on  and pick an output format, click "Export data"

 

Tips!

1. Data extracted locally can only be exported after the extraction completes. 

2. All extracted data would be deleted after a new run starts.


4. Download cloud data

Data extracted in the Cloud is automatically stored on the Octoparse cloud platform and is accessible from any machine. To retrieve and download Cloud data:

  • Click "More action" on the dashboard
  • Select "View data"
  • Select "Cloud data"
  • Click on  to select an output format
  • Click "Export data"

 

 

Unlike local data, cloud data can be exported as soon as it gets extracted during the extraction process. You can select "Export all" to export all data or select "Export unexported data" to get data that has not been exported.

 

Tips!

1. Cloud data will be stored in the Cloud for only 3 months after which it will be deleted permanently. Please export the cloud data in a timely manner. 

2. Data extracted in the Cloud can be auto-export to a designated local database on a pre-set schedule (see more details here )

 

Congrats! You’ve finished all introductory lessons for Octoparse 7.X! Are you pumped up for data hunting?

Feel free to let us know if you have any question or need our assistance. Contact us here !

 

 

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

Contact us Download
btn_sidebar_use.png
btn_sidebar_form.png