Website
BlogSign In

Google Sheet Export Format

Detailed information about each field included in the exported LinkedIn profile data to Google Sheet.

FAQ

Can I change the columns ordering?

Yes. LinKapture will dynamically adapt to your preferences.

Can I remove the columns I don't need?

Yes. LinKapture will still store the information in the fullJson column, so if you add the removed columns back later, you can easily refill the missing data using a simple script (learn more). Please note that the columns url and fullJson must remain in the sheet; removing either will trigger an explanatory error message in the extension.

Can I add columns?

Yes, many of our users use Google Sheet as a CRM and need to keep track of business specific information about each profile. So we designed LinKapture to allow to add any columns you like, anywhere you like. When a profile is added or updated, they will be kept as you set them.

Why are firstname and lastname extracted by AI?

Safety! In order to get this data while scrapping a LinkedIn profile, one must either hook into LinkedIn API calls or query a specific LinkedIn API. LinkedIn doesn't like that and can punish users by blocking their accounts. We deemed these solution to risky for our users. Hence we use a Top Of The Art AI to figure out which is which based on fullname and make it available to all languages and alphabets.

Field Descriptions

Most fields are removable except url and fullJson.

Field Name
free plan
removable
Description

added_at

✅ yes

✅ yes

Date and time in UTC when the profile was added.

added_by

✅ yes

✅ yes

Email of the user who added this profile (based on the extension key used).

url

✅ yes

❌ no

LinkedIn URL of the profile.

emails

✅ yes

✅ yes

Emails found for the profile; if there are multiple, they are separated by commas.

phones

✅ yes

✅ yes

Phone numbers found for the profile; if there are multiple, they are separated by commas.

socials

✅ yes

✅ yes

Links to social platforms for the profile; if there are multiple, they are separated by commas.

fullname

✅ yes

✅ yes

The complete name as displayed on LinkedIn, cleared of any emojis.

firstname

✅ yes

✅ yes

Given name of the profile (extracted from fullname by AI).

lastname

✅ yes

✅ yes

Family name of the profile (extracted from fullname by AI).

title

✅ yes

✅ yes

Profile title as found on LinkedIn.

location

✅ yes

✅ yes

Location as found on LinkedIn.

about

✅ yes

✅ yes

"About" section as found on LinkedIn.

experience1

✅ yes

✅ yes

Same as experience1.

experience2

✅ yes

✅ yes

Same as experience1.

experience3

✅ yes

✅ yes

Same as experience1.

experience4

✅ yes

✅ yes

Same as experience1.

experience5

✅ yes

✅ yes

Same as experience1.

education1

✅ yes

✅ yes

The most recent education entry displayed on LinkedIn, including school name, link to LinkedIn page, degree name, years of study, and any comments if present.

education2

✅ yes

✅ yes

Same as education1.

education3

✅ yes

✅ yes

Same as education1.

education4

✅ yes

✅ yes

Same as education1.

education5

✅ yes

✅ yes

Same as education1.

language1

✅ yes

✅ yes

Includes language and proficiency level.

language2

✅ yes

✅ yes

Same as language1.

language3

✅ yes

✅ yes

Same as language1.

language4

✅ yes

✅ yes

Same as language1.

language5

✅ yes

✅ yes

Same as language1.

certification1

✅ yes

✅ yes

Includes certification name and delivery date.

certification2

✅ yes

✅ yes

Same as certification1.

certification3

✅ yes

✅ yes

Same as certification1.

certification4

✅ yes

✅ yes

Same as certification1.

certification5

✅ yes

✅ yes

Same as certification1.

project1

✅ yes

✅ yes

Includes project name, date range of participation, sponsoring company or school, and any description added by the user.

project2

✅ yes

✅ yes

Same as project1.

project3

✅ yes

✅ yes

Same as project1.

project4

✅ yes

✅ yes

Same as project1.

project5

✅ yes

✅ yes

Same as project1.

skills

✅ yes

✅ yes

List of skills, separated by commas.

recommendation1

✅ yes

✅ yes

Name, LinkedIn URL, and title of the person who gave the recommendation; date and relation with the person; text of the recommendation.

recommendation2

✅ yes

✅ yes

Same as recommendation1.

recommendation3

✅ yes

✅ yes

Same as recommendation1.

recommendation4

✅ yes

✅ yes

Same as recommendation1.

recommendation5

✅ yes

✅ yes

Same as recommendation1.

fullJson

✅ yes

❌ no

Sample Data Entry

Below is an example of how the data may appear in the Google Sheet:

added_at
added_by
url
emails
phones
socials
fullname
firstname
lastname
title
location
about
experience1
skills
language1
recommendation1
fullJson

2024-11-01 09:29:25

user@example.com

www.linkedin.com/in/example

example@mail.com, pro@email.com

+1-555-0100

@twitterhandle, live:example

Jane Smith

Jane

Smith

Senior Developer at Tech Solutions

Anytown, Country

About section

Co-Founder https://www.linkedin.com/company/103403627/ Linkapture June 2024 – Present · 6 months Paris, Île-de-France, France · Remote LinKapture is your companion app to export data from LinkedIn to Google Sheet in one click. Ideal for solo recruiters and small teams of sourcers. Get started quickly on your recruitments or prospecting.

Skill1, Skill2, Skill3

English

Native

Emily Johnson www.linkedin.com/in/example Director at Creative Labs On October 18, 2024, Emily was a senior colleague of John, but not his direct manager. John is one of the most dedicated and innovative developers I've worked with. His attention to detail and commitment to delivering high-quality work make him an invaluable asset to any team. I look forward to the opportunity to collaborate with him again in the future.

Note: The sample data above is for illustrative purposes only and does not contain real personal information.

Additional Notes

  • Multiple Entries: Fields that can have multiple values (e.g., emails, phones, socials, skills) are separated by commas (", ").

  • Experience, Education and Project Details: Experience and education fields include comprehensive details such as company name, position, duration, and descriptions.

  • AI involvement: We use AI to extract firstname & lastname from the fullname field. Unlike other tools that connect to and monitor LinkedIn API calls—potentially putting users' LinkedIn accounts at risk—our approach is safer and does not involve unauthorized access.

  • JSON Format: The fullJson field contains all the above information in JSON format for easy parsing and integration, excluding added_at and added_by (Learn more).

Need Assistance?

If you have any questions or need help at any point, feel free to:

PreviousFEATURE GUIDESNextthe fullJson Field Format

Last updated