Skip to content

CSV lead list format: the columns to use

One column of LinkedIn profile links is enough. Name, headline, company and notes are optional. What is skipped and what happens next.

Updated

The one column you need

A column of LinkedIn profile links, named linkedin_url. The names url, profile and linkedin work too. Each cell is a link such as https://www.linkedin.com/in/someone/.

Optional columns

ColumnUsed for
nameThe {name} placeholder in notes and messages
headlineThe {headline} placeholder, and the AI note
companyThe {company} placeholder, and the AI note
notesAnything you know about the person. The AI note reads it

Leave out what you don't have. Profile Scraper fills in name, headline, company and location from the person's profile afterwards.

An example file

linkedin_urlnamecompanynotes
https://www.linkedin.com/in/example-one/AshaExample CoMet at the Pune meetup
https://www.linkedin.com/in/example-two/

Sample rows, not real people. The second row is fine as it is: a link alone is enough.

What gets skipped

  • Duplicate links within the file.
  • Links that aren't LinkedIn profile links, such as company pages or posts.
  • People already in your lead list.

The upload tells you how many rows it took and how many it skipped.

After the upload

Run Profile Scraper once. It reads each profile from your own cloud browser, through the same internal web API LinkedIn's own site uses, and fills in name, headline, company and location, pausing 4 to 12 seconds between profiles. It handles up to 2,000 leads a run and, by default, only leads with missing data. It also marks anyone who is already a first-degree connection as accepted, so Message Sender can find them.

Auto Liker needs this step for uploaded leads: it recognises people by profile ID, which the scraper fills in. Leads from the lead finder already have it.

Moving a list from another tool

Export from the old tool as a CSV, open it in a spreadsheet, rename the profile link column to linkedin_url, delete columns you don't need, and upload. Pause the old tool first so two tools never act on the same account.

Leads carry no history across. The app doesn't know who the old tool already invited, so trim the file to people it hadn't reached, or expect Auto Connect to skip anyone who turns out to be a connection already.

Where lists come from

  • An export from the tool you're leaving. Most will give you a CSV with profile links.
  • A spreadsheet of people you've met: events, calls, introductions. Add a notes column with where you met; the AI note reads it.
  • LinkedIn's own data export, under Settings and Data privacy, which can include your connections with their profile links. Useful for messaging people you're already connected with.
  • A list someone sent you. Check it has profile links, not just names; names alone can't be uploaded.

File format

A plain CSV: one header row, commas between columns, saved as UTF-8 so names with accents survive. From Excel or Google Sheets, use Save as or Download and pick CSV. Columns are matched by name, not position, so extra columns are ignored and the order doesn't matter.

Check the upload

Open the Leads page after uploading and spot-check a few rows: the link opens the right person, the name is a name and not a company. Fix the file and upload again if something is off; duplicates are skipped, so a second upload adds only what was missing.

One thing you can't do

Export the list back out. There is no CSV export of leads today. Keep your own copy of the file you uploaded.

Something not covered here?