Help › CSV import

CSV import

Bring leads into SocialScalr from CSV in under 2 minutes. The 4-step wizard handles column mapping, deduplication, custom field creation, and error reporting. Supports any CSV that includes a LinkedIn URL column.

By · Last updated

The required column

Every imported row needs a LinkedIn URL. Acceptable column header names (auto-detected):

Other column headers can be mapped manually in step 2 of the wizard.

The 4-step wizard

Step 1: Upload

  1. Open Contacts tab → Import CSV.
  2. Drag-and-drop your CSV or click to browse.
  3. SocialScalr parses the file and shows the first 5 rows.

Step 2: Column mapping

Auto-detection handles the common cases. For any column SocialScalr doesn't recognize, you pick from the dropdown:

Step 3: Deduplication preview

SocialScalr checks your existing workspace for LinkedIn URL collisions (and optionally email collisions). The preview shows:

Step 4: Destination

Pick where to put the imported leads:

For 90% of imports, you want "Add to Pipeline only" first - this lets you review the imported leads before triggering any outbound.

Common source CSVs and how to map them

Apollo CSV export

Apollo exports include LinkedIn URL by default. Map: First Name → first_name, Last Name → last_name, Title → title, Company Name → company, Email → email, LinkedIn URL → linkedin_url. Optional: Industry → custom field "Industry"; Annual Revenue → custom field "Revenue".

Clay CSV export

Clay's column naming is configurable. Standard mapping: LinkedIn profile URL → linkedin_url, First Name → first_name, Last Name → last_name, Job Title → title, Company → company. Clay exports often include enriched fields (Twitter handle, GitHub, personal site) - map these as custom fields.

HubSpot contact export

HubSpot exports a custom "linkedinbio" field if you've enabled the LinkedIn integration. Map: linkedinbio → linkedin_url, First Name → first_name, Last Name → last_name, Job Title → title, Company → company, Lifecycle Stage → custom field "HubSpot lifecycle".

Sales Navigator export

Sales Nav doesn't export profiles via CSV directly - use the SocialScalr Sales Nav URL builder + paste URL as a campaign targeting source instead. SocialScalr scrapes the search results into leads automatically.

Error handling

Step 3 preview surfaces problems before import:

After import, the Import history page (Settings → Import history) shows every batch with row count, errors, and a "rollback this import" button (rolls back within 24 hours of import).

Plan limits

Larger imports than the per-file limit: split the CSV and run multiple imports. The dedupe step will catch any overlap.

Related

Frequently asked questions

What CSV formats does SocialScalr import?

Any CSV with a LinkedIn URL column. The import wizard auto-detects common column names (linkedin_url, profile_url, LinkedIn, etc) and lets you manually map otherwise. Tested formats: Apollo export, Clay export, HubSpot contact export, Salesforce report export, Sales Navigator list export, ZoomInfo, Lusha, manual spreadsheet.

How does SocialScalr deduplicate during CSV import?

Deduplication on LinkedIn URL by default. Rows with a LinkedIn URL that already exists in your workspace are flagged in the preview step - you choose whether to skip, update existing, or import as new. Optional email-based dedupe as secondary key.

What is the max CSV file size?

50,000 rows per file on Pro and Agency. 1,000 rows on Starter, 100 on Free. For larger imports, split the file and run multiple times - the dedupe step will catch overlap. We're working on a 200,000-row import path for Q3 2026.