Operelio
LinkedIn ConnectionsZoho

How to import LinkedIn Connections into Zoho Contacts

7 of the 7 columns in a LinkedIn Connections export, mapped into 6 Zoho Contacts fields under Zoho's own names.

Download the Excel templateUse this template free

Free · 18 KB · Excel 365 or Google Sheets

Check your LinkedIn Connections export first

Built on LinkedIn Connections’ export columnsChecked against Zoho’s import rulesUpdated October 3, 2026

One LinkedIn Connections row, through the templatecopied as it ischanged on the way1explained below
  • First Name to First NameKaren
  • Last Name to Last NameWilson
  • Email Address to Email
  • Company to Account NameCavendish Legal
  • Position to TitleHead of Sales
  • URL, Connected On to Description1joined, with labelsLinkedIn: linkedin.com/in/karen-wilson-example | LinkedIn connected: 14 Aug 2026

Where LinkedIn Connections and Zoho don’t line up

1

Two columns kept in Description

This template gives URL and Connected On no Zoho field of their own.

The template writes them into Description, each with its label, and leaves empty ones out.

ExportURL linkedin.com/in/karen-wilson-example
Connected On 14 Aug 2026
ZohoLinkedIn: linkedin.com/in/karen-wilson-example | LinkedIn connected: 14 Aug 2026

Check your LinkedIn Connections export before you import it

Looks for the 7 columns this template reads, and what Zoho would skip.

Drop your LinkedIn Connections CSV here

Runs in your browser. Nothing is uploaded, and results are counts only.

LinkedIn Connections to Zoho in three steps

Step 1Export from LinkedIn Connections
  1. Click the Me icon at the top of your LinkedIn homepage and select Settings & Privacy.
  2. Click Data privacy on the left.
  3. Under How LinkedIn uses your data, click Download your data.
  4. Select Connections and click Request archive.
  5. Download the file from the link LinkedIn emails you. The link works for 72 hours.

Only first-degree connections are included.

An email address appears only for connections who allow their connections to see or download it.

LinkedIn: Export connectionsLinkedIn: Download your account data
Step 2Paste into the template
  1. Paste the export at A1 of Paste your export here.
  2. Start here checks all 7 columns were found.
  3. Save Zoho Contacts import as a CSV.

Works in Excel for Microsoft 365 and Google Sheets. Excel 2019 and older, Apple Numbers and LibreOffice can't run the formulas this file uses.

Just the 6 headers as a CSV

Step 3Import into Zoho
  1. Open the Contacts tab, click the down arrow next to the Create button and choose Import.
  2. Drop in or browse to your CSV, XLS or XLSX file, set the character encoding if needed and click Next.
  3. Choose Add as new, Update existing only or Both, and the field that identifies an existing record.
  4. Map each column to a Zoho CRM field; for a lookup, choose the field that identifies the linked record.
  5. Set the assignment, approval and automation options, accept the anti-spam policy and submit.
Zoho CRM's importer, screen by screen

Operelio, with the same template

Fixes the capitals in names, removes duplicate and blank rows, which the Excel file leaves to you. On every plan. Email verification from Starter.

Use this template in Operelio

Questions

Where does LinkedIn Connections' export fill Last Name, which Zoho requires?

Last Name comes from LinkedIn Connections' Last Name column. The checker above counts the rows with Last Name blank.

Where do URL and Connected On go?

Into Description on each contact, labeled like "LinkedIn: linkedin.com/in/karen-wilson-example | LinkedIn connected: 14 Aug 2026".

Why does Company go to Account_Name?

Zoho uses Account_Name on the contact to link the contact to a company record (Account). If the account doesn't exist yet, Zoho creates one during import.

Duplicates and undoing an import: Zoho CRM import questions.

Try this template free

Upload your LinkedIn Connections export and download a file Zoho can import. No credit card needed.

Use this template freeSee all templates