Export Leads to Excel from ProfileSpider
Use ProfileSpider to export saved lead lists to Excel after extracting people, companies, profiles, and contact data from web pages. Review your columns, clean the list, and download an XLSX, CSV, or JSON file.
Goal
What This Workflow Is For
Turn a saved ProfileSpider list into an Excel file you can clean, share, filter, or use for outreach.
Use this workflow after you have extracted leads, profiles, companies, or contact data with ProfileSpider and want the results in a spreadsheet.
The export step is where ProfileSpider becomes useful outside the extension: you can review your list, keep the columns you need, and download the data as Excel, CSV, or JSON.
This workflow is focused on exporting ProfileSpider lists. If you want a broader explanation of scraping website data into Excel, use the related blog guide. If you want a ready-made spreadsheet structure, use the lead list template.
Prerequisites
Before You Start
Confirm the page and tooling match this workflow.
Before you export, make sure you have:
- ProfileSpider installed in Chrome
- At least one saved list with extracted leads, profiles, companies, or contacts
- Reviewed the rows you want to keep
- Decided which export format you need: Excel, CSV, or JSON
Excel is usually best when you want a normal spreadsheet. CSV is useful for importing into other tools. JSON is useful for developers or structured data workflows.
Fit
Best For / Not Ideal For
Set expectations before you install or run an extract.
Best for
- Exporting extracted leads into a spreadsheet
- Reviewing and cleaning scraped profile or company data
- Sharing lead lists with clients, teammates, or contractors
- Preparing account, prospect, or recruiting lists
- Moving ProfileSpider data into CRM, enrichment, or outreach workflows
- Creating reusable spreadsheet files from website-sourced data
Not ideal for
- Exporting data before reviewing obvious duplicates or empty rows
- Using Excel as a replacement for a CRM when you need full pipeline management
- Exporting private data you are not allowed to collect or process
- Expecting missing fields to appear in Excel if they were not extracted or enriched first
- Large workflows that need direct API integration instead of file export
Steps
Step-by-Step Workflow
- 1
Open your saved ProfileSpider list
Go to the ProfileSpider list that contains the leads, profiles, companies, or contacts you want to export.
This could be a list created from a directory, company team page, social media page, public profile page, or another website source.
- 2
Review the rows before exporting
Check the extracted rows for obvious mistakes, empty values, irrelevant profiles, or duplicated entries.
A quick review before export saves cleanup time later, especially if the source page contained repeated sections, ads, related profiles, or hidden page elements.
- 3
Check your columns
Confirm which fields you want in the export. Common columns include name, title, company, website, LinkedIn URL, email, location, source URL, tags, and notes.
- 4
Choose Excel, CSV, or JSON
Choose the export format that matches your next step. Use Excel for spreadsheet work, CSV for imports, and JSON for structured data workflows.
- 5
Download and use the file
Download the export and open it in Excel, Google Sheets, LibreOffice, your CRM import flow, or another data tool. Keep the source URL column if you want to verify where each row came from.
Schema
What ProfileSpider Extracts
Default fields for this workflow. Add or remove columns before you extract.
- NameThe person, company, profile, vendor, member, or listing name extracted from the source page.
- TitleThe role, job title, function, or listing title when available.
- CompanyThe company, organization, employer, agency, or source account connected to the row.
- WebsiteA website URL found on the source page or added through enrichment where available.
- LinkedIn URLA LinkedIn profile or company URL if found on the page.
- EmailAn email address if visible on the page or added through email finding where available.
- LocationCity, country, region, service area, or other location text when available.
- TagsLabels used to segment rows by campaign, client, source, niche, role, or workflow.
- NotesManual notes added while reviewing or preparing the lead list.
- Source URLThe page URL where the row came from. Useful for verification, deduplication, and later research.
Output
Example Output
What a downloaded file looks like. Real exports are saved as .csv, .xlsx, or .json.
| Name | Title | Company | Website | Tags | Notes | Source | ||
|---|---|---|---|---|---|---|---|---|
| Maria Chen | VP Engineering | Lumen Robotics | lumenrobotics.com | linkedin.com/in/mariachen | maria@lumenrobotics.com | conference-speaker | Good fit for robotics campaign | example-directory.com/robotics |
| James Patel | Head of Sales | Northwind Cloud | northwind.io | linkedin.com/in/jamespatel | saas-lead | Find email before outreach | example-directory.com/cloud | |
| Aisha Carter | Founder | Cartergrove Labs | cartergrove.com | linkedin.com/in/aishacarter | aisha@cartergrove.com | founder | Potential partner lead | example-directory.com/startups |
Troubleshooting
Common Problems
The Excel file has empty cells
Empty cells usually mean the field was not available on the original page or was not added through enrichment. Review the source data, enrich missing fields where possible, or keep the column empty.
The export contains duplicate rows
Some websites repeat the same profile or company in multiple sections. Review duplicates before export, keep the source URL column, and use deduplication where available.
The wrong columns are in the file
Go back to the saved list and check the fields selected for export. Use a lead list template if you want a consistent structure across different sources.
CSV formatting looks strange in Excel
If CSV opens with odd separators or encoding issues, try the Excel/XLSX export instead. XLSX is usually the safest option for normal spreadsheet work.
I need to import the list into another tool
Use CSV for most CRM and outreach-tool imports. Keep predictable column names such as Name, Company, Title, Email, Website, LinkedIn, and Source URL.
Questions