Your LinkedIn connections are a contact list you built over years, and LinkedIn keeps it behind a scrolling page. If you want it in Google Sheets to tag by industry, plan outreach to your own network, or back it up, you have two ordinary options. You can request your data archive from LinkedIn and wait, or you can copy names off the page by hand.
This guide shows a third way: export your connections to Google Sheets with the free LinkedIn Connections Exporter and the Lection Chrome extension, with no code. It covers what the export contains, how to import it, and what the tool does not do.
What you get in the sheet
The tool returns one row per connection, using your own logged-in LinkedIn session:
| Column | What it holds |
|---|---|
| Full Name | The connection's name |
| Headline | Their LinkedIn headline |
| Location | The location on their profile |
| Profile URL | A link to their profile |
| Public Identifier | The slug in their profile URL |
| Connected At | When you connected |
| Picture URL | Their profile picture link |
| Connection URN | LinkedIn's internal connection ID |
There are no email addresses in this export. LinkedIn does not provide them through this route, and the tool does not look for them.
Why not wait for LinkedIn's archive?
LinkedIn's data export can include a connections file, but it is a request-and-wait process, and what arrives is a snapshot that you cannot refresh on demand. Copying from the page is slow: the connections list loads in chunks, and every connection needs a click to see anything beyond the name and headline. The Lection exporter reads your connections in batches from your browser, the same way the page does, and gives you a table.
Before you start
- Desktop Chrome with the free Lection extension.
- A LinkedIn login in the same browser. The tool uses your session to read your own connections.
Your LinkedIn cookies stay on your device. The tool's own page states that requests are made locally by the extension.
Step by step: LinkedIn connections to Google Sheets
- Open the LinkedIn Connections Exporter and install the extension if asked.
- Check that you are logged in to LinkedIn in this browser.
- Choose a batch size, with a Count and a Start offset. The defaults are 40 and 0.
- Click Export Batch for a batch, or Export All to page through your whole list. Large lists can take a few minutes.
- Download as CSV or Excel.
- In Google Sheets, choose File, then Import, then Upload and select the file. Pick "Replace spreadsheet" for a new file.
Make the sheet useful
- Segment by headline. Use Data, then Create a filter, and filter Headline by words like "founder", "recruiter" or "engineer".
- Add your own columns. Add Notes, Last contacted and Topic columns next to the exported data. Sort and filter on them.
- Sort by Connected At to see who you met recently and who you have not spoken to in years.
- Back it up. Save a dated copy as a record of your network.
If you are building an outreach list, keep it to people you actually know, and respect their expectations. Do not paste names into a mass messaging tool. Professional contact lists can be personal data under privacy rules such as GDPR. See our GDPR checklist for scrapers.
Keep it updated automatically
This is where the tool is honest about its limits: the LinkedIn Connections Exporter is a run-it-when-you-need-it tool. It does not support scheduled runs today, and because it relies on your own logged-in session, it is not a good fit for an unattended cloud job.
A practical routine is to export when you need it, for example once a month, then use Sheets to merge it with the previous list:
- Import each export as a new tab named by date, such as "2026-11".
- In a third tab, use
=FILTER()withISNA(MATCH())to list Profile URLs that appear in the new tab but not the old one. That gives you the new connections since last time. - Use
=UNIQUE()on the combined Profile URL column if you want one master list.
If you want to send results into other tools once they are in Sheets, the Google Sheets integration page and the guide on automating Google Sheets with scraped data cover what Lection can schedule for other sites. For the 30-day Standard trial, which unlocks scheduled delivery to Sheets for supported tools, see the trial link. It is free for 30 days, then $29 per month, a card is required, and it is for first-time subscribers only. It does not add scheduling to this particular exporter.
Honest limitations
- Your own connections only. The tool reads the list tied to the account you are logged in with.
- Login required. It uses your LinkedIn session.
- No scheduling. Re-run it by hand when you want a new snapshot.
- No emails or phone numbers. The export stops at profile-level fields.
- LinkedIn can change. If LinkedIn rejects the request, you may see an error asking you to confirm you are logged in. Reload LinkedIn and retry.
- Terms and privacy. Read LinkedIn's terms and the law that applies to you. Our hiQ v. LinkedIn explainer gives background.
Troubleshooting
"Request timed out." Make sure the Lection extension is installed and active.
"LinkedIn rejected the request." Log in to LinkedIn in the same browser and try again.
Export All is slow. That is normal for large networks. Leave the tab open until it finishes.
FAQ
Can I export LinkedIn connections to Google Sheets for free? Yes, through CSV and File, Import.
Does it include email addresses? No.
Can I export someone else's connections? No. It only reads the logged-in account's own list.
Can it run on a schedule? Not at present.
Is there a wider LinkedIn guide? See how to scrape LinkedIn without code.