If you’re like me and realised that you have a lot of non-active LinkedIn connections, you’d like an efficient way to remove them from your network so that you can make room for new and more meaningful connections.
Following the instructions below:
- Extract your existing Connections. Click here to learn how to do it.
- Open the CSV file in Excel or Google Sheets and in a free Column (say G or H) and Row 5 enter the following formula: =A5&” "&B5. This will put the First and Last Name in the one cell.
- Copy and paste this formula all the way to the end of the sheet.
- Delete all the people you want to retain on LinkedIn and only keep the people you wish to remove from LinkedIn.
- Next, you should ideally have two windows open on your screen
Window 1 - CSV file
Window 2 - Click here to open your LinkedIn network list.
- When you open the link you’ll see a search box “Search by name”. Copy the name of the person you want to remove from your LinkedIn network in the CSV file and paste it in the search box. You will notice only people with the first name and last name will appear. Usually, just the person will show up, unless they have very common First and Last Names.
- Next to the “Message” button, you will see 3 dots. Click the 3 dots and then click “Remove connection”.
What happens is that LinkedIn observes that you have only visited one page (the connections List Page) even though you remove 1000 or more people using Copy/Paste from the CSV.
Do share your views on this technique. Let me know if it worked for you.