ConnectionCleanup
Start your cleanup

Template

The DIY spreadsheet: analyze your network by hand

Everything below works in a free Google Sheet with your Connections.csv. It genuinely works, and we'll be honest: by tab 4 you'll understand why we built the tool. Both are fine outcomes.

Setup (2 minutes)

  1. Get your export: LinkedIn, Settings & Privacy, Data privacy, Get a copy of your data, tick Connections only.
  2. New Google Sheet, then File, Import, Upload, select Connections.csv.
  3. Delete the notes rows above the header so row 1 reads First Name, Last Name, URL, Email Address, Company, Position, Connected On.
  4. Rename the tab to Connections (the formulas below reference it).

Tab 1: Who do I know where? (companies)

  1. Create a new tab named Companies.
  2. In cell A1 paste:
=QUERY(Connections!A:G, "select E, count(A) where E is not null and E <> '' group by E order by count(A) desc label E 'Company', count(A) 'People'", 1)

Instant account map. Scan the top 20 for companies you forgot you had warm coverage at.

Tab 2: What is my network made of? (titles)

  1. Create a tab named Titles.
  2. In A1, count how many titles contain a keyword (change "founder" to anything):
=COUNTIF(Connections!F:F, "*founder*")

Stack a column of keywords (founder, chief, director, head of, student, retired) next to a column of COUNTIFs and you have a seniority breakdown.

Tab 3: Which era is my network from? (years)

  1. In Connections, add a header Year in H1, then in H2:
=IF(G2="", "", RIGHT(G2, 4))

Fill down, then pivot: Insert, Pivot table, rows Year, values COUNTA of Year. If most of your network is from a career phase that no longer matches your ICP, you're looking at the reason your feed feels irrelevant.

Tab 4: The stale sweep

  1. Filter Position for blanks, and for the words retired, student, or intern combined with old connection years.
  2. That filtered list is your starting cleanup sheet. Work through it profile by profile.
=FILTER(Connections!A2:G, (Connections!F2:F="") + ISNUMBER(SEARCH("retired", Connections!F2:F)))

This is where the manual version starts to hurt: every rule you add means another formula, and none of it touches messages, invitations, or job changes.

Tab 5: the confession

The tool does all four tabs in about 30 seconds, plus the nine files this sheet can't handle: messages, invitations, reactions, comments, and the month-over-month job-change diff.

Run the free scan insteadSee pricing