Turn Social Media Likes into Visuals

This guide shows you how to turn your social media likes into eye-catching visuals—like word clouds, bar charts, or infographics—that you can post or share. You’ll learn the exact steps to export your like data, clean it up, and create a visual that reveals your top posts or favorite topics. No coding or design skills are required, just a free account on a few web tools.

What You’ll Need

• A social media account (Instagram, TikTok, X/Twitter, or Facebook) where you can view your likes
• A computer or smartphone with a web browser
• A free account on a data export tool (e.g., ExportComments, or the platform’s native data download)
• A spreadsheet program (Google Sheets or Microsoft Excel) to organize the data
• A free word cloud generator (like WordArt.com) or chart tool (like Flourish or Datawrapper)

Step-by-Step

1. Export your likes data. Go to your social media account’s settings and look for “Download your data” or “Request data.” For Instagram, that’s in Settings > Privacy and Security > Download Data. For TikTok, it’s in Settings > Privacy > Download Your Data. For X/Twitter, it’s Settings > Your Account > Download an Archive. Select the data type that includes likes (often called “Likes” or “Interactions”) and request the export. It may take a few minutes to a few days; you’ll get an email with a link.
2. Extract the file. Once you receive the download, it’s usually a ZIP file. Unzip it on your computer or phone. Look for a file named something like likes.json, likes.csv, or interactions.csv.
3. Open the file in a spreadsheet. If it’s a CSV, double-click to open in Excel or Google Sheets. If it’s JSON, use a free online converter (like JSON to CSV) or open it in a text editor and copy the URLs or post descriptions.
4. Clean the data. Delete any columns you don’t need (like timestamps or user IDs). Keep the column that shows the post content or the link. If you have a list of URLs, you may want to extract the username or hashtag from the URL. For example, from instagram.com/p/abc123, you can extract “abc123” but that’s not useful—instead, use the post caption if available, or the account name.
5. Decide what visual you want. Do you want a word cloud of your liked captions? A bar chart of which accounts you like most? Or a pie chart of content types (photo, video, reel)? Your choice determines the next steps.
6. For a word cloud: Copy the column of post captions or descriptions into a text file (or directly into WordArt.com’s text box). Remove common words like “the,” “a,” and “and” if you want. Click “Generate” and customize the font, colors, and shape. Download the image.
7. For a bar chart of top accounts: In your spreadsheet, use the count function to tally how many times each account appears. For example, in Google Sheets, use =COUNTIF(range, A2) and drag down. Then select the account names and counts, go to Insert > Chart, and choose a bar chart. Customize the title and labels, then download as a PNG.
8. For a pie chart of content types: Add a column next to your data and manually label each row as “Photo,” “Video,” “Reel,” or “Text.” Then create a pie chart from that column. This works best if you have fewer than 100 likes.
9. Add context. Use a free tool like Canva to add a title, your username, and a short insight (e.g., “My top 5 liked accounts this year”). This makes your visual more shareable.
10. Export and share. Save your final visual as a PNG or JPEG. Post it on your social media or use it in a presentation.

Common Mistakes

• Using the wrong data file. Some platforms give you a “likes” file that only contains the IDs of posts, not the content. Double-check that you have the file with post URLs or captions.
• Forgetting to remove duplicates. If you liked a post twice (rare but possible), your counts will be off. Use the “Remove Duplicates” feature in your spreadsheet.
• Making a word cloud with URLs. If you paste raw URLs, the word cloud will show random letters and numbers. Always extract the caption or account name first.
• Ignoring privacy. If you include other users’ usernames or content in your visual, you may be sharing their data. Consider blurring or summarizing instead.

Tips

• For a more meaningful visual, filter your likes to a specific time period (e.g., last month) using the timestamp column.
• If you’re using JSON data, try a free online JSON viewer to see the structure before converting.
• Use a color palette that matches your personal brand—most tools let you customize.
• If you have thousands of likes, sample a random 100 to keep the visual readable.
• Combine likes with comments or shares for a richer analysis.

Troubleshooting

• The export file is empty or missing likes. Some platforms only provide likes for posts you’ve made, not likes you’ve given. Check the platform’s help page; if likes you gave aren’t included, you may need to use a third-party app (with caution) or manually note your recent likes.
• JSON file won’t open in Excel. Use a free online JSON-to-CSV converter. Or, open the JSON in a text editor and search for “caption” or “title” to manually copy the text.
• The word cloud looks gibberish. You likely included URLs or encoded characters. Clean the text by removing punctuation and URLs. Use the “Replace” feature in your spreadsheet to remove “http” and “www.”
• Chart won’t render in Google Sheets. Make sure you’ve selected the correct data range and that your count column contains numbers, not text.
• Download takes too long. If the platform says it may take 48 hours, plan ahead. You can also use the platform’s “Liked Posts” page and manually copy the first 50 for a quick visual.

Frequently Asked Questions

Can I do this without downloading my data?

Yes, you can manually copy your liked posts from your profile’s “Liked” tab, but it’s tedious. For a small number of likes, that works fine.

Which platforms support this?

Instagram, TikTok, X/Twitter, and Facebook all offer data downloads that include likes. Pinterest and LinkedIn have similar options, but the file structure may differ.

Is it legal to use other people’s content in my visual?

You can use the data for personal analysis, but reposting someone’s content may require permission. For a word cloud, you’re only using words, not images, so it’s usually fine.

What if I don’t have a spreadsheet program?

Google Sheets is free and works in your browser. You can upload your CSV file directly to Google Drive and open it with Sheets.

Can I automate this process?

Yes, if you’re comfortable with scripts, you can use Python or Google Apps Script to parse the JSON and generate charts automatically. But for a one-time visual, the manual steps above are faster.

How do I make the visual look professional?

Keep it simple, use a consistent color scheme, and add a clear title. Tools like Canva offer templates that look polished with minimal effort.

Related

• AI Assistants vs Search Engines: Which Should You Use?
• Physics That Keeps Humans Valuable as AI Changes Work
• Small Modular Reactors vs Diesel for Remote Canada