Format Your Old LinkedIn Content

Format Old LinkedIn Content

Format Your Old LinkedIn Content

This article explains how you can make your old content on LinkedIn more accessible. If you have posted a lot to LinkedIn, it can be very difficult to locate your old posts. The approach described in this article provides a potential workaround.

Last month I wrote about how you can access your old content on LinkedIn:

Basically, you use their UI to export it to Comma-Separated Values (CSV) files. That's functional, but not very usable, especially because LinkedIn doesn't encode CSV files correctly. You can have an AI analyze that content:

To format the content, you can run the files through an AI to generate markdown, HTML, JSON, or whatever format you need. Most people might like a static HTML best, since then you don't need a tool to visualize markdown; you can just open the file in a browser.

One caveat is that the export does not include media. The LinkedIn media export feature has been "under construction" for a couple of decades. Another is that formatting is not great, specifically around linefeeds, but there are probably some instructions I could give to address some of that. And some URLS are LinkedIn Klingon-cloaked so they can ensure your online safety. And by that I mean track you better. And usernames are not clickable. And there are no preview cards for YouTube and such. And you only see your content, including your posts and comments, not the posts you commented on or the comments to which you responded.

Below are the instructions that I used to generate the sample that appears in this page.

Claude prevented me from uploading CSV files. I appended .txt extensions to the file names, which Claude allowed me to upload. But by then I had run out of free credit for today. I had also run out of free credit on ChatGPT. I signed up for a free month of gemini, but I'm already disappointed, because it is easily confused (AI lacks common sense), and the UI was quirky today. It helped to give it instructions first and then upload the files afterwards. It doesn't let me download markdown files (it links to something like sandbox:/mnt/data/filename.md and blames my UI, which is google gemini running in google's chrome browser), and there's a limit to how much it can render inline, which is also very slow.

Anyway, here are my approximate prompts that I used:

These CSV files do not seem to be encoded, quoted, or escaped perfectly. Please correct any errors in the files before proceeding.

Shares.csv lists posts. Comments.csv lists comments on posts. Every comment is always associated with a post, but for some comments, there is no post record in the shares CSV. In both files, the URL may identify the post.

Generate a markdown file that I can download. If possible, I want a bulleted list with an entry for each post, including all the comments associated with that post. Each entry should include a link to the post. Use the datestamp as the text of the link. Order the list so that the oldest posts come first.

It generated the output below.

I asked it to generate code that would let me do this locally, which seems to work. After some improvements, the script is here:

My LinkedIn post and comment history is here:

AI Session

This is a link to the relevent AI session:

Comments

You can comment here:

Sample Output

Here's my partial data that gemini was able to give me.