Lemon8 has no export feature, but its comment sections — dense with beauty, lifestyle, and product recommendations — are some of the highest-intent audience data on any platform. Getting them into a spreadsheet means exporting.
This guide exports comments from any public Lemon8 post into a CSV that opens directly in Excel — one row per comment.
The columns you'll get
The Clean export (default) gives you one comment per row with these fields:
- Author name
- @username
- Comment text (Unicode-safe — emoji, Thai, and CJK render correctly in UTF-8)
- Like count
- Reply count
- Timestamp (UTC)
- Language
- Pinned (TRUE / FALSE)
- Comment ID
- Reply-to ID
- Profile picture URL
Need every raw metadata field? Switch to the Raw export for the full set.
Step-by-step
1. Copy the post URL
A public Lemon8 post URL looks like:
https://www.lemon8-app.com/@{user}/{postId}
2. Open the Lemon8 exporter
Go to zocialcomment.com/export/lemon8 and paste the URL. Paste up to 50 posts, one per line, to batch them into one CSV.
3. Click "Export Comments"
The tool counts the comments and shows a preview. Free tier covers 3 posts a day, no signup.
4. Download the CSV
You'll get a UTF-8 CSV download when it finishes.
Opening the CSV in Excel without breaking emoji or CJK
- Open Excel first (blank workbook)
- Data ribbon → From Text/CSV
- Pick your downloaded file
- Set File Origin to
65001: Unicode (UTF-8) - Set Delimiter to
Comma, then Load
Mac Numbers and Google Sheets handle UTF-8 automatically — just double-click.
Useful Excel formulas
Rank by likes
=SORT(A2:K1000, 4, -1) — sorts by Like Count (column D) descending.
Find product questions
=COUNTIF(C2:C1000, "*?*") — counts comments with a question mark, a fast proxy for buyer questions worth answering.
Count mentions of a product
=COUNTIF(C2:C1000, "*productname*") against the comment-text column.
Free tier limits
The free tier exports comments from 3 posts per day with no signup. For bulk product research, the $14 3-Day Pass unlocks unlimited exports for 3 days, and the $39 pass adds AI comment analysis for sentiment and theme clustering.
Also exporting other platforms? See TikTok comments to Excel and Instagram comments to Excel.