Core Features / Export Options

Export Options

Export your scraped data in multiple formats or stream directly to Google Sheets.

Available Formats

Choose the export format that best fits your workflow.

CSV

CSV (Comma-Separated Values)

Universal format compatible with all spreadsheet applications.

  • Opens in Excel, Google Sheets, Numbers
  • Lightweight file size
  • Easy to import into databases
  • Best for: data analysis, sharing with teams
JSON

JSON (JavaScript Object Notation)

Structured data format for developers and APIs.

  • Preserves data types and structure
  • Easy to parse in any programming language
  • Supports nested data
  • Best for: API integration, data processing
XLSX

Excel (.xlsx)

Native Microsoft Excel format with full formatting support.

  • Supports multiple sheets
  • Preserves column widths and formatting
  • Compatible with Excel, LibreOffice, Google Sheets
  • Best for: reports, formatted data presentation
GSheets

Google Sheets

Stream data directly to a Google Sheets spreadsheet.

  • Real-time data streaming during scraping
  • Auto-creates new spreadsheet
  • Share with your team instantly
  • Best for: collaboration, live monitoring

Google Sheets Integration

Stream scraped data directly to Google Sheets in real-time.

Prerequisites

To use Google Sheets export, you need to connect your Google account to ScraperQ. This is a one-time setup.
1

Connect Google Account

First-time setup for Google Sheets:

  1. Open ScraperQ panel and go to Settings
  2. Click "Connect Google Account"
  3. Authorize ScraperQ to access Google Sheets
  4. Your account is now connected

Google account setup

Replace with actual extension screenshot

Connect your Google account
2

Select Google Sheets Export

When creating or running a template, select "Google Sheets" as the export option.

Export selection

Replace with actual extension screenshot

Select Google Sheets
3

Choose Destination

ScraperQ will either:

  • Create a new spreadsheet — ScraperQ creates a new Google Sheet automatically
  • Use existing spreadsheet — paste a Google Sheets URL to add data to an existing sheet
4

Monitor Live Data

As the scraping job runs, data appears in your Google Sheet in real-time. You can watch the data populate row by row.

Pro Tip

Share the Google Sheet with your team so they can monitor the scraping job progress live, even if they don't have ScraperQ installed.

Export Settings

Configure export behavior for your templates.

Deduplication

Enable deduplication to avoid duplicate entries in your export:

  • Choose a field to check for duplicates (e.g., URL, product ID)
  • ScraperQ automatically skips duplicate entries
  • Works across multiple pages

Column Mapping

Customize column names in your export file:

  • Rename fields to match your naming conventions
  • Reorder columns by dragging
  • Exclude fields you don't need in the export

Test Case: Export to Multiple Formats

Verify export functionality across different formats.

Scenario: Export Product Data to CSV and Google Sheets

  1. Run a product scraping job with CSV export
  2. Download the CSV file
  3. Open in Excel and verify data integrity
  4. Run the same job with Google Sheets export
  5. Verify data appears in the Google Sheet
  6. Compare CSV and Google Sheets data for consistency

Expected Result: Both exports contain identical data. CSV opens correctly in Excel. Google Sheet updates in real-time during scraping.

← Repair Broken Selectors Advanced Features →