How to export LinkedIn saved posts to Excel or Google Sheets
Create the CSV with the actual post text first. Then turn it into a clean working table you can search, filter, annotate, and refresh without destroying your notes.
Create a full-content CSV with LinkedIn Bookmark Exporter
LinkedIn itself does not provide a full-content spreadsheet export for bookmarks. A working sheet needs the complete post text, author, source URL, dates, and other source fields so you can evaluate records without reopening every post.
- Install LinkedIn Bookmark Exporter Chrome Extension
- Open LinkedIn Saved Items → Saved posts and articles.
- Open the extension, select CSV, and start the export.
- Leave the page open while the extension auto-scrolls and collects the saved history.
- Download the completed CSV and spot-check a few long posts, old posts, and URLs.
Rename the untouched download linkedin-saved-posts-2026-08-28-raw.csv. Make a separate working copy for filters and annotations. If something is accidentally sorted, deleted, or overwritten later, the raw file remains your recovery point.
Import CSV into Excel without garbled text
- Open a blank workbook.
- Use Data → From Text/CSV instead of double-clicking when you need control over encoding.
- Select the exported file and choose UTF-8 if Excel asks for file origin or encoding.
- Confirm that the delimiter is comma and that multiline post text remains inside one record.
- Load the data, select it, and create a table with headers.
- Turn on text wrapping for the post-text column and freeze the header row.
If an author such as “José” appears with broken characters, stop and re-import with UTF-8. Do not manually repair names: the same encoding error can affect every non-English character and emoji in the file.
Import CSV into Google Sheets
- Create a new spreadsheet.
- Select File → Import → Upload.
- Upload the CSV and import it into a new sheet.
- Confirm comma separation and automatic text conversion.
- Freeze row one and choose Data → Create a filter.
- Restrict sharing before adding private research notes.
Do not paste thousands of lines directly into the first cell. CSV import understands quoted commas and line breaks; paste operations are more likely to split long posts incorrectly.
A small schema that supports real retrieval
| Column | Origin | Use |
|---|---|---|
| Record ID | Export or generated | Stable reference |
| Author | Export | Source filter |
| Post text | Export | Full-text search |
| Source URL | Export | Context and deduplication |
| Date | Export | Recency filter |
| Topic | You | One primary subject |
| Status | You | Inbox, Keep, Used, Archive |
| Why saved | You | Your retrieval language |
Avoid calculating value from engagement alone. Likes and comments can be useful sorting signals, but a popular post is not necessarily accurate or relevant to your project.
Three views worth creating
- Inbox: Status is blank. This is the review queue.
- Active research: Status is Keep and Topic matches the project at hand.
- Used: Status is Used. This shows which bookmarks have actually contributed to a decision, article, campaign, or conversation.
These views are deliberately plain. A spreadsheet becomes useful when it reduces retrieval time, not when it contains the most elaborate dashboard.
Clean the sheet without damaging evidence
- Deduplicate on normalized source URL, not the first sentence.
- Keep the original text separate from your summary.
- Do not overwrite dates with spreadsheet-formatted display strings.
- Spot-check URLs after sorting and deleting rows.
- Search for blank author, URL, or post-text cells and investigate them.
- Keep raw, working, and published/used datasets separate.
If a URL contains tracking parameters, create a separate normalized URL column for comparison instead of changing the preserved source value.
Append future exports carefully
Each run of LinkedIn Bookmark Exporter is a fresh snapshot, so importing the whole file into the master sheet will create duplicates. Use this sequence:
- Run a new CSV export and save it with that day’s date.
- Import it into a temporary tab rather than the master table.
- Compare each source URL against the master sheet.
- Append only rows whose URLs do not already exist.
- Preserve your manual Topic, Status, and Why saved columns.
- Record the last successful export and import date.
For a more note-centered setup, compare Notion and Obsidian. To understand the source-file choices first, read the complete LinkedIn export guide.