How to Browse and Search your Liked Tweets

Xoel López Barata
7 min readFeb 3, 2020

Have you ever tried to find a tweet you liked some time ago? Me too, and it’s almost impossible. Scrolling down in the ‘Likes’ tab of my profile while doing CMD-F is a pain and it doesn’t even work sometimes.

I came up with a way of saving all my past and future Twitter likes. It lets me browse, filter them, and search for tweets by text or user. And it’s free.

This is what you’ll have if you follow this post — a backup of all your likes in the cloud that you can query through Google Sheets

I thought it could be helpful for others, so here it goes

Before you start

We’ll to use Tinybird to store and query the tweets. It lets you ingest CSVs of up to billions of rows and create dynamic API endpoints on your data very easily.

Sign up here and email the team so that they activate your account (it’s deactivated by default)

Last, go here to request your full Twitter data. It will take 24h but this will ensure that you’re downloading all your tweets. Read more about this in the last section of the post

Ah, and install pipenv to run the necessary code we’ll use.

Downloading your most recent likes

Run these commands to set everything up

# clone the git repo
git clone https://github.com/xoelop/get-twitter-likes

--

--

Xoel López Barata
Xoel López Barata

Written by Xoel López Barata

Freelance data scientist and software developer. On Twitter: @xoelipedes.

Responses (6)