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 — one post per export, each downloading as its own 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 the first 100 comments of any post with no signup and no daily limit. For bulk product research, the 3-Day Pass unlocks unlimited posts for 3 days (up to 10,000 comments per post), and the Pro Pass adds AI comment analysis for sentiment and theme clustering.
Also exporting other platforms? See TikTok comments to Excel and Instagram comments to Excel.