Skip to main content

Import CSV for bulk data extraction

Import a CSV file to automatically extract data from thousands of URLs or input parameters. This feature is perfect for batch processing, deep scraping workflows, and running with different parameters.

M
Written by Melissa Shires

✅ You will need an approved robot in order to automatically extract data from a list of input parameters, or URLs.

💡 Import CSV and the Bulk Run feature on the Run Task tab share the same limit, set by your plan and shown in the upload box.

In Tables you can upload a list of input parameters or URLs to automatically extract data from thousands of web pages.

For example:

  • Scraping large numbers of product detail pages.

  • Extracting data from multiple search results.

  • Performing deep scraping across many pages.

  • Batch processing with different parameters.

How to import a CSV into Tables

Format your CSV file for upload

Your CSV must have column headers matching your robot's input parameters exactly.

This could include:

  • Origin URL column containing full URLs (including https://)

  • Additional columns for any other parameters your robot needs

Make sure to include:

  • Include a header row with column names.

  • Make sure URLs include the full address (including http:// or https://).

  • Avoid special characters in your CSV.

  • Ensure the file is properly encoded (UTF-8 recommended).

💡 You can download a sample file directly from Tables if you're unsure of the correct format. Go to Tables, and select Import CSV. From there, click Download Sample CSV Input to get a template with your robot's input columns.

Import your file to run your bulk task

  1. In your robot's Table, click Import CSV.

  2. Click Click to upload in the sidebar and select your CSV file.

  3. Check the mapping under Map Data and click Start Extracting Data below the table.

  4. Check the credit estimate and click Extract.

Review your Bulk Run progress and results

Your imported tasks will:

  • The run will appear in your Table with a unique Bulk Run identifier.

  • Your Table filters to the new Bulk Run name (BR_ followed by the date and time) so you see only these results. Clear the filter to see every row.

  • The Status column shows each task as Queued, In-progress or Successful.

💡 Depending on the complexity of your robot and the number of tasks you've triggered, it may take a few minutes for your robot to process the full list of tasks.

Deep scraping with CSV import

A common workflow is using one robot's output as another robot's input. For example extracting a list of product details from a category page.

  • Robot A extracts product URLs from category pages.

  • Robot B is trained to extract data from a single product page.

To create a dataset of all product pages from the category pages you would:

  1. Export Robot A's URLs as CSV.

  2. Import to Robot B to automatically extract details from all pages.

💡 You can also do this in the product using our workflows feature.

How to deep scrape with Tables

✅ To use this feature, you need to have a trained robot for:

  • Robot A: trained to extract a list of URLs or input parameters

  • Robot B: trained to extract details on a page using a URL or input parameter.

  1. Export URLs from Robot A's Table

  2. Rename columns to match Robot B's parameters

  3. Keep only the columns Robot B needs

  4. Import to Robot B (up to your plan's bulk-run limit)

Common use cases

E-commerce product monitoring

Import URLs of multiple product pages to extract pricing, features, and availability across competitors.

Real estate property data

After scraping property listings from search results, use Bulk Run to get detailed information about each property.

Content aggregation

Import URLs of articles or blog posts to extract and compile content from multiple sources.

Lead generation

Scrape contact details from a list of company pages or professional profiles.

Did this answer your question?