How to Export Website Profiles to CSV
Use ProfileSpider to extract people and company profiles from any public website and export them to CSV. Open the page in Chrome, extract visible profiles, save them to a list, and download a clean CSV, Excel, or JSON file.
Goal
What This Workflow Is For
Turn the profiles on any public web page into a clean CSV you can open in Excel, Google Sheets, or import elsewhere.
Use this workflow when a public website shows people or company profiles, such as a team page, directory, member list, speaker page, or search result, and you want that data as a CSV without copy-pasting or writing code.
ProfileSpider reads the visible page in Chrome, structures the profiles into rows, and lets you export them. You stay in control of which columns you keep and how the file is named.
This page is focused on the export workflow: open the page, extract the profiles, save them to a list, choose your columns, and download a CSV, Excel, or JSON file.
Prerequisites
Before You Start
Confirm the page and tooling match this workflow.
Before you start, make sure you have:
- ProfileSpider installed in Chrome and signed in
- A public web page with visible people or company profiles open in a normal Chrome tab
- Profiles, cards, or rows rendered on the page
- A rough idea of the columns you want in your CSV, such as name, title, company, website, LinkedIn URL, email, and source URL
This workflow works best when the profiles are visible in live HTML. If the data is hidden behind a login, image, or PDF, extraction may be limited.
Fit
Best For / Not Ideal For
Set expectations before you install or run an extract.
Best for
- Company team and leadership pages
- Directory and member listing pages
- Conference speaker and exhibitor pages
- Search result and Google X-Ray pages
- Portfolio, author, and community profile pages
- Any public page with repeated profile cards
Not ideal for
- Pages behind a login you are not authorized to access
- PDFs, screenshots, or scanned tables with no live HTML
- Pages where profile data is embedded only in images
- Single-profile pages with no repeated rows
- Pages where data only appears after complex in-page interactions
Steps
Step-by-Step Workflow
- 1
Open the page with profiles in Chrome
Go to the public page that shows the profiles you want and wait until they are fully loaded and visible in the browser.
ProfileSpider works from the page you can see in Chrome, so make sure the relevant profiles are rendered before extracting.
- 2
Open ProfileSpider
Click the ProfileSpider extension icon. The extension will analyze the current page and prepare the extraction workflow.
- 3
Run the extraction
Start the extraction. ProfileSpider turns the repeated profiles on the page into structured rows. A normal page scrape uses one credit.
- 4
Save the profiles to a list
Save the extracted rows to a new or existing list. Use list names, tags, and notes to keep different pages, sources, or projects organized.
Saving rows, adding tags, and adding notes do not use credits.
- 5
Choose the columns for your CSV
Review the fields you want to keep in the export, such as name, title, company, website, LinkedIn URL, email, location, and source URL. Reusable custom headers help keep your exports consistent.
- 6
Export to CSV, Excel, or JSON
Export the saved list. Use CSV or Excel for spreadsheet workflows, and JSON if you want to move the data into another tool. Exporting saved lists uses 0 credits.
Schema
What ProfileSpider Extracts
Default fields for this workflow. Add or remove columns before you extract.
- NameThe person or company name shown in the profile.
- TitleRole, headline, or job title when available.
- CompanyCompany, organization, or employer associated with the profile.
- WebsiteThe profile or company website linked from the page, when available.
- LinkedIn URLA LinkedIn profile or company page URL if the page links to one.
- EmailAn email address if it is visible on the page. Missing emails can be handled later with email finding where available.
- LocationCity, country, or region when present in the profile.
- Source URLThe URL of the page the profile came from, useful for verification and deduplication.
Output
Example Output
What a downloaded file looks like. Real exports are saved as .csv, .xlsx, or .json.
| Name | Title | Company | Website | Location | Source | ||
|---|---|---|---|---|---|---|---|
| Maria Chen | VP Engineering | Lumen Robotics | lumenrobotics.com | linkedin.com/in/mariachen | maria@lumenrobotics.com | Berlin, Germany | example.com/team |
| James Patel | Head of Sales | Northwind Cloud | northwind.io | linkedin.com/in/jamespatel | London, UK | example.com/team | |
| Aisha Carter | Founder | Cartergrove Labs | cartergrove.com | linkedin.com/in/aishacarter | aisha@cartergrove.com | Amsterdam, Netherlands | example.com/about |
Troubleshooting
Common Problems
The export has empty columns
Empty cells usually mean the field was not visible on the source page. Keep the column empty, enrich the row later, or remove the column before export.
I want a specific column order
Choose and order the columns you want before exporting, and reuse custom headers so future exports stay consistent.
The CSV opens with broken characters in Excel
Export to XLSX directly for the cleanest Excel result, or import the CSV using UTF-8 encoding so names with accents display correctly.
Rows look duplicated
Some pages repeat profiles in featured or hidden sections. Review the list, deduplicate if available, and keep the source URL column for verification.
The page uses pagination or infinite scroll
Extract one page at a time or scroll until profiles load, saving each batch to the same list before exporting once.
Questions