Skip to main content
Workexe

Data Import Guide

Upload CSV or Excel files, map fields, and run a dry-run before final import. Supports up to 250k rows per file with automatic deduplication and validation.

October 29, 20252 min read

Data Import Guide

Supported file formats

Workexe accepts the formats your existing tools already export. No conversion required for 95% of cases.

  • .csv (UTF-8, comma or semicolon delimited)
  • .xlsx and .xls (Excel 2007+)
  • .tsv (tab-separated)
  • .json (array of objects, max 50MB)
  • Google Sheets via direct paste-link

Field mapping wizard

After upload, the importer auto-detects 80% of column headers based on common names. Unmapped columns prompt you to pick a target field from a dropdown.

  • Auto-detection for keyword, position, volume, URL, domain
  • Save mapping as a preset for repeated imports
  • Required vs optional field visual indicators
  • Custom field support for project-specific data

Dry-run validation

Before committing, the importer runs every row through validation and shows you a preview report. Nothing writes to your project until you click Confirm.

  • Format errors flagged with row number and reason
  • Duplicate detection across rows and against existing project data
  • Quota check: shows how much of your monthly quota the import will consume
  • Sample preview of first 20 rows as they'll appear after import

Limits and performance

Imports run in the background so you can keep working. Email notification fires on completion or failure.

  • Max file size: 100MB per upload
  • Max rows per file: 250,000
  • Concurrent imports: 5 per workspace
  • Processing speed: ~10k rows/minute

Common gotchas

Most import failures trace back to 3 issues. Check these before contacting support.

  • Date format mismatch: use ISO 8601 (YYYY-MM-DD) for reliability
  • Encoding: save CSV as UTF-8, not Windows-1252 or MacRoman
  • Numeric columns with thousand separators: strip commas before upload
  • URL columns must include protocol (https://...)
data import guide setup
  1. 1
    Open Project

    Launch the data import guide module from your project panel.

  2. 2
    Connect Sources

    Add GSC, GA4 and any required CSV imports.

  3. 3
    Set Scope

    Choose location, language, device and alert thresholds.

  4. 4
    Validate

    Confirm the first scan against a known page or query.

Frequently Asked Questions