Exporting social media data means one of two things: downloading a copy of your own account's data, which each network offers in its settings for your account only, or exporting public posts you found by searching, which needs a tool that keeps your search results. The first is for backups, moving platforms and seeing what a network stores about you. The second is for research, reporting and analysis. This guide covers both, then shows what to do with the file and how to keep it tidy and respectful of the people in it.
| Your own account's data | Public search results | |
|---|---|---|
| What it contains | Your posts, profile, messages and activity, in categories that vary by network. | Public posts, accounts or comments returned by searches you ran. |
| Whose data | Yours only. | Whoever posted it publicly. |
| Where you get it | The network's own settings, usually under privacy or account data. | A tool that saves search results, such as a social search engine. |
| Typical format | An archive the network prepares, then sends you a link to. | CSV for spreadsheets, or JSON for code. |
| Best for | Backups, moving platforms, seeing what is stored about you. | Research logs, reports, monitoring records and analysis. |
Downloading your own account's data
Most large networks let you request a copy of your account's data from your settings. The menus move around, so search the network's help centre for "download your data" or "download your information" to find the current steps. Two examples we checked:
- LinkedIn: from Settings & Privacy, open Data Privacy, choose Download your data and request an archive. LinkedIn says specific categories arrive by email within minutes, the larger download within 24 hours, and the file stays available for 72 hours. It provides only your own data, not other members'.
- YouTube: your YouTube data belongs to your Google Account, which you export with Google Takeout: choose the products to include, then have a download link emailed to you or the archive added to Drive or Dropbox.
Whatever the network, these downloads cover your account only. They are not a way to collect other people's posts. Store them carefully, because they can include private messages and contact details.
Exporting public search results
The search pages on the networks themselves are built for scrolling, not for downloading a list. To get public posts into a spreadsheet, people usually choose between four approaches:
- Copy and paste: fine for ten posts, slow and error-prone for a hundred, and easy to lose the link or the date.
- Official developer APIs: structured data, but they need developer access, code and acceptance of each network's terms.
- Social listening suites: broad coverage and dashboards, usually sold on longer contracts.
- Social search engines: run searches across networks and keep the results, often with an export.
Whichever you choose, export public content only, and respect each network's terms and the privacy of the people in the data.
How exporting works in Superlurk
Every search you run in Superlurk is saved privately to Results automatically, so there is nothing to save by hand. Exporting is free and does not use credits, on every plan including the trial.
- Run your searches. Search a supported network. Each result is kept in Results for 7 days on the trial, 90 days on Starter and a year on Pro and Max.
- Pick the results. Open Results and narrow the list with the find box, a network, or a date range (Today, This week, This month or All). Tick the results you want, or Select all.
- Choose a format. Choose Export as CSV for spreadsheets or Export as JSON for code. One export can include up to 1,000 saved results. On the search page, Export CSV exports the result you are looking at.
- Download within 24 hours. The file appears under Exports on the Results page a moment later. Its download link lasts 24 hours; after that, make a new export from Results, as long as the results are still kept.
What the CSV contains
The CSV has one row per item: each post, account or comment in the results you selected. The first four columns say where the row came from: result_id (the saved result), platform (the network), action_id (the search that produced it) and fetched_at (when the result was retrieved). The remaining columns are the fields shown for that kind of result, for example:
- Lists of posts: Post ID, Link, Author, Author name, Title, Text, Posted, Media, Likes, Comments, Shares, Views and Hashtags.
- Comments: Comment ID, Author, Comment, Posted, Likes and Replies.
- Lists of accounts: Account ID, Handle, Name, Profile link, Picture, Verified and Followers.
A cell is blank when the network did not provide that field, or when you mixed different kinds of result in one file and the column belongs to another kind. Lists, such as hashtags or media, are written as JSON text inside the cell. Text that starts with a character a spreadsheet would treat as a formula, such as = or +, gets a leading apostrophe so it stays plain text; strip it if you process the file with a script and need the original.
What the JSON contains
The JSON file keeps the full structure. It has a format_version, the export_id and a results list. Each result carries its result_id, platform, action_id, fetched_at, effective_inputs (the inputs actually sent for that search) and items, the full result objects with nested fields intact. Choose JSON when you will process the data with code or want to keep everything; choose CSV when a person will read it.
An export is built completely or not at all, so you never download half a file. Exports use only your own saved results and are private to your account.
What to do with the file
In a spreadsheet
- Open the CSV in Google Sheets, Excel or Numbers and freeze the header row.
- Filter by platform before comparing anything: views, likes and upvotes mean different things on each network.
- Sort by Posted to read a conversation in order, or by fetched_at to see when you collected each item.
- Remove duplicates by Link or Post ID when the same post turns up in more than one search.
- Add your own columns for notes, tags or a verdict to the right of the exported ones.
With pivot tables
A pivot table turns rows into answers. Count posts per platform per day to see when a topic picked up. Count rows per Author to spot accounts that post about a topic again and again. After you tag comments by theme, count how often each question comes up; our guide to comment analysis explains how to code them. Keep each network in its own column rather than adding counts across networks.
With scripts
For anything you will repeat, use code. In Python, pandas reads the CSV directly, and the standard json module loads the JSON so you can loop over each result's items. Scripts are the right tool for joining several exports, cleaning text or counting hashtags across thousands of rows. Keep the result_id and fetched_at values so every number can be traced back to a saved search.
Keep your data tidy
- One question per export. A file that answers one question is easier to read than a dump of everything.
- Name files clearly. Downloads are named social-search-export followed by an ID. Rename them with the date, network and topic, for example 2026-11-06_reddit_standing-desks.csv.
- Keep a raw copy. Work on a duplicate tab or file so you can always go back to what was exported.
- Write down the queries. Note the searches and dates on a README tab, or use our research log template.
- Delete what you no longer need. Old files full of personal data are a liability, not an asset.
Respect privacy
Exported search results contain public posts by real people. Public does not mean anything goes:
- Collect only what your question needs, and keep it only as long as you need it.
- Store files securely and share them only with people who need them.
- In reports, quote and link rather than republishing whole profiles, and leave out the handles of private individuals when the point does not depend on who they are.
- Never use exports to profile, track or contact private individuals.
- Depending on where you work, data protection law may apply to personal data in your files, so check your obligations.
Superlurk searches only public content, and people who appear in results can ask for removal through the data removal request page. If you work in news, our guide to social media search for journalists covers verification and record keeping in more depth, and if you are new to researching across networks, start with how to search all social media from one place.
Frequently asked questions
How do I export my own social media data?
Use the network's own download option, usually in account or privacy settings under a name like "Download your data". It covers your account only. LinkedIn emails you a link to your archive, and YouTube data is exported through Google Takeout.
Can I export social media posts to CSV?
Not from most networks' own search pages, but a tool that keeps search results can export them. In Superlurk, select saved results in Results and choose Export as CSV or Export as JSON. Exports are free.
What columns are in a Superlurk CSV export?
One row per item, starting with result_id, platform, action_id and fetched_at, followed by the fields for that kind of result: for a list of posts, for example, Link, Author, Text, Posted, Likes, Comments, Shares, Views and Hashtags.
How long do Superlurk export links last?
24 hours. After that you can make a new export from Results, as long as the saved results are still kept: 7 days on the trial, 90 days on Starter and a year on Pro and Max.
Do exports cost credits?
No. Exports are free on every plan, including the trial.
Can I export private posts?
No. Only public content that each network makes available can be searched, so only public content can be exported.
Sources
How this guide was written. Written by the Superlurk team on 6 November 2026. Export columns, formats and limits were checked against Superlurk's export code; account-download steps against the linked LinkedIn and Google help pages. Menus on other networks change often, so check their help centres for current steps.