# How to export LinkedIn leads to CSV
> Learn how to extract LinkedIn profiles into a CSV file for your CRM using manual methods, automation, and AI scoring to keep lead quality high.
- HTML: https://getkinlead.com/ai-lead-group-export-csv
- Markdown: https://getkinlead.com/ai-lead-group-export-csv.md

**Short answer:** To export LinkedIn leads to a CSV, you must gather profile URLs using search filters or manual curation. Since LinkedIn doesn't have a native export button for search results, you use a third party tool or a manual spreadsheet to extract the data.

## Identify your target lead list

Don't move data into a spreadsheet until you have a clean source. If you export every person from a broad search, you'll fill your CRM with people who won't buy. That wastes your time when you start outreach.

Define the job titles and company sizes that match your buyer. A founder of a 10 person agency has different budgets than a VP of Marketing at a 500 person firm. Use these details to build your search queries.

You don't need a Sales Navigator seat to build a CSV. The standard search bar and filters give you enough to find the right people. Sales Navigator adds filters, but for a simple export, the free search is enough.

Use quotes around multi-word titles and the word OR to combine two roles. A search for "Head of Growth" OR "VP of Growth" returns both titles in one list.

1. **Run a targeted search.** Use the LinkedIn search bar for a specific title, like "Head of Growth", and add a keyword for their industry.
2. **Apply geography and industry filters.** Filter by location and industry to remove profiles outside your service area.
3. **Manually verify a sample.** Click the first ten profiles to make sure the results actually match your criteria before you export.
4. **Save the search criteria.** Copy the URL of your filtered search page so you can return to the same list for batch exports.

> Export 50 people who match your buyer, not 500 random profiles.

## Manual extraction for small lists

If you only need 20 or 30 high-value prospects, software is overkill. Manual extraction is the safest way to get exactly who you want. It's slower, but it stops you from importing junk leads into your CRM.

Open a Google Sheet or Excel file and create a header row. Copy the data points from the profile and paste them into the cells. Copy only the fields your CRM requires.

Some profiles won't have a company listed or will use a headline instead of a job title. Leave those cells blank rather than guessing. A blank field is easier to fix later than a wrong one.

Save the file as .csv, not .xlsx, before you import. Some CRMs reject Excel files.

| | Column | Data Point | Example Value |
| --- | --- | --- | --- |
| A | Full Name | Sarah Jenkins |
| B | LinkedIn Profile URL | linkedin.com/in/sarahjenkins |
| C | Current Company | Northwind Logistics |
| D | Job Title | Operations Manager |

```
Full Name,LinkedIn URL,Company,Job Title
Sarah Jenkins,https://www.linkedin.com/in/sarahjenkins,Northwind Logistics,Operations Manager
Marcus Lee,https://www.linkedin.com/in/marcuslee,Acme Corp,Head of Growth
```

## Using automation for larger volumes

Manual copying is impossible for hundreds of leads. You'll need a tool that reads the HTML of a LinkedIn search page to extract data into a structured format. These tools scan profiles in your search results and save public information.

Watch the volume of profiles you scrape in one session. LinkedIn monitors account behavior. Pulling a large number of profiles in a short time can trigger a warning. Export in smaller, daily batches to mimic human browsing.

Before you run a scraper on your whole list, test it on five profiles. Check that the CSV columns line up with what you expect. A tool that outputs a single column of text is harder to clean than one that splits name, title, and company.

Check the tool's privacy policy before you paste in a search URL. You're handing over a list of profiles.

1. **Select an extraction tool.** Choose a tool that specializes in LinkedIn data extraction and supports CSV output.
2. **Run the scraper on your filtered list.** Input your filtered search URL and let the tool extract public profile data from the results page.
3. **Audit for duplicates.** Use the "Remove Duplicates" feature in your spreadsheet to ensure you don't have the same person twice.
4. **Save as .csv.** Export the cleaned list as a Comma Separated Values (.csv) file for your CRM import.

- **you:** I need to get 300 leads from that search into HubSpot. Any shortcut besides copying each profile?
- **them:** Use a scraper that outputs CSV. Run it on the filtered search URL, then clean the file before you import.
- **you:** Will LinkedIn flag my account?
- **them:** It can if you pull thousands at once. Break it into daily batches of a few hundred and you're less likely to trip anything.

## Cleaning your CSV for CRM import

Raw exports from LinkedIn are often messy. You'll find names with extra characters or titles with internal company codes. If you import this, your CRM looks unprofessional and your emails look like they came from a bot.

Clean the data before importing. Use 'Find and Replace' to remove unwanted characters. If a cell has both a company name and a job title, use 'Split Text to Columns' in your spreadsheet tool.

Company names cause the most duplicates. 'Acme Corp' and 'Acme Corporation' are the same account. Use Find and Replace to standardize the most common variations before you import.

Use the TRIM function to remove extra spaces at the start and end of cells.

**Raw export data**

- Name: John Doe (he/him)
- Title: VP Sales | Expert in SaaS | 10x Growth
- Company: Acme Corp (Global)

**CRM ready data**

- Name: John Doe
- Title: VP Sales
- Company: Acme Corp

> Keep a backup of the original raw CSV before cleaning it in case you delete a column by mistake.

## Mapping CSV columns to your CRM

Your CRM has its own field names. A column called 'Full Name' might need to go into 'Lead Name'. A column called 'LinkedIn Profile URL' might need to go into a custom field called 'LinkedIn URL'. If you don't map these correctly, your import will fail or create duplicate records.

Most CRMs show a mapping screen during import. Match each CSV column to the corresponding CRM field. For fields that don't exist, create a custom field first. For fields you don't need, skip them.

Import five rows first. Check that the data landed in the right fields and that no duplicates were created. Once that works, import the rest.

Export a sample of five rows from your CRM after import to confirm the data matches.

| | CSV column | CRM field | Notes |
| --- | --- | --- | --- |
| Full Name | Lead Name | Required |
| LinkedIn URL | LinkedIn URL (custom) | Create this field first |
| Company | Account Name | Matches existing accounts |
| Job Title | Title | Optional |

> If your CRM doesn't have a LinkedIn URL field, create one before you import. You'll need it to match leads later.

## Doing this with Kinlead

You can avoid manual cleaning by using Kinlead to qualify leads before they hit your CSV. You describe your ideal customer or provide your website. The system scores each lead from 0 to 100 based on fit, and it discards leads below your fit line.

Qualified leads are kept in [lead groups](/features/lead-groups-and-scoring). You can export a specific group to a CSV for your CRM, so every row in your spreadsheet is a high-quality prospect.

1. **Define your buyer profile.** Provide your website or a description of your ideal customer to set scoring criteria.
2. **Score and filter leads.** Let the system find LinkedIn profiles and score them; only the ones that match your profile are kept.
3. **Organize into groups.** Sort qualified leads into specific lead groups based on industry or role.
4. **Export to CSV.** Download the lead group as a CSV file to import into your CRM.

## Related

- [AI lead scoring fit line](https://getkinlead.com/ai-lead-scoring-fit-line-setup.md)
- [Lead groups and scoring](https://getkinlead.com/features/lead-groups-and-scoring.md)
- [Pricing plans](https://getkinlead.com/pricing.md)

## Common questions

**Does LinkedIn allow exporting leads to CSV?**

LinkedIn doesn't have a built-in feature to export search results or connections to a CSV. You have to use manual copying or third party tools.

**Can I export my entire connection list to a spreadsheet?**

You can request a data archive from LinkedIn settings. This includes your connections, but the list usually has less information than a full profile scrape.

**How do I map LinkedIn CSV columns to my CRM fields?**

Use the mapping screen during the CRM import. Match the 'Full Name' column to the 'Lead Name' field and 'Profile URL' to the 'LinkedIn URL' custom field.

[Create a Kinlead account](https://getkinlead.com/signup) or [book a call](https://getkinlead.com/demo) to talk through pricing and setup.
