Mine your own LinkedIn data

LinkedIn hands you your entire history as one file, and almost nobody opens it. Turn that export into a lead list with Claude.

FreeBeginner-friendly3 min read

Mine your own LinkedIn data

The first thing mine showed me was how many warm conversations I had let quietly die. People who asked to work together, then it went quiet. "Let's catch up" that never happened. Deals I let go cold without even noticing. All of it was sitting in a file LinkedIn had been holding for me the whole time. Here is how to open it.

1. What is sitting in that file

LinkedIn lets you export almost everything it knows about you, and almost no one ever does. In my own archive: every connection with the date I made it, over 70,000 messages, every reaction I had ever given, and every search I had ever typed. It is your network, your history, and your warmest relationships, all in one place.

You already earned this data. The reason it does nothing for you is that it arrives as a stack of plain CSV files almost nobody opens. That is the only thing standing between you and a lead list you did not have to buy.

2. Download it in three clicks

You do this on the LinkedIn desktop site, not the app.

  1. Go to Settings → Data Privacy.
  2. Click Get a copy of your data.
  3. Choose the full archive and request it.

The complete export can take up to a day to arrive, and LinkedIn emails you when it is ready. Ask for the full archive, not the "fast" one. The fast file is a thin slice. The complete one is the goldmine, with the connections and messages that make this whole thing work.

3. Hand the boring CSVs to Claude

Open Claude, upload the file, and let it read the CSVs for you. This is the moment the export stops being a backup and starts being a lead list. You are not going to scroll 7,500 rows. Claude will, in seconds, and answer questions about them in plain language.

Two files do most of the work. Connections.csv is who you know, with names, companies, roles, and the date you connected. messages.csv is every conversation you have ever had. The prompts below point Claude at those two files with a clear job.

4. Find new pipeline from your connections

Start with the people you already know. The goal is to surface the ones who match who you sell to, then sort them so you know where to start. The brief to Claude is always the same shape: define your ideal customer, then ask it to filter and rank.

For example: "Filter my connections to my ideal customers and rank them by seniority." Or: "Show every company where I know three or more people." Or the one that stings: "Show people who fit my ideal customer that I have NEVER messaged."

That last one is usually a list you did not know you were sitting on. The exact, ready-to-run version of all three, with the slot to describe your ideal customer, is in the unlock below.

5. Revive the warm leads in your messages

Your connections are the cold-but-relevant list. Your messages are the warm one. Every deal you let go quiet is still written down in there, word for word. So point Claude at messages.csv and ask it to find the threads worth reopening.

For example: "Find threads where they asked about working together, then went quiet." Or: "Where did we say 'let's catch up' and never did?" These are not strangers. They are people who already raised a hand. The full set of revival prompts is in the unlock.

6. One honest caveat

The export is a SNAPSHOT. It is brilliant for segmenting your network and digging up cold conversations, but it cannot tell you who viewed your profile, who engaged with your latest post, or who just changed jobs. That is live data, and the file does not have it.

So use the two for different jobs. Use the export to BUILD the list. Use live signals to TIME the outreach.

Your data already knows who your next conversation should be with. Download it, hand it to Claude, and reopen one thread you let go cold.

Unlock, free

Get the exact prompt

You have the method. Sign up to copy the exact prompt and run it yourself.

The prompt
Locked
Sign up free to unlockOne email. No payment. Unlocks every prompt and skill on One Big Guide.