This product was not featured by Product Hunt yet. It will not be visible on their landing page and won't be ranked (cannot win product of the day regardless of upvotes).
Product upvotes vs the next 3
Waiting for data. Loading
Product comments vs the next 3
Waiting for data. Loading
Product upvote speed vs the next 3
Waiting for data. Loading
Product upvotes and comments
Waiting for data. Loading
Product vs the next 3
Loading
Open Trends
Free theme-level trend analysis from Keyword Planner data
A free, open-source browser app that turns Google Keyword Planner exports into theme-level trend analysis for any category: growth, velocity, seasonality and top searches. No accounts, no tracking — everything runs locally in your browser.
Hey Product Hunt! 👋
I'm Saarth — I work in insights & analytics and I spend a lot of time turning Google Keyword Planner exports into "what's actually trending in this category" reports.
The manual version of this is a 40-tab workbook: tag thousands of keywords against theme definitions, sum monthly volumes, compute growth, build seasonality, repeat next month. It works, but it doesn't scale, and every new category means rebuilding the whole thing.
Open Trends is that workbook turned into a browser app:
1. Drop in a Keyword Planner export (.xlsx/.xls/.csv).
2. Define your themes as Boolean queries or plain term lists (the bundled example is 22 fragrance themes).
3. Get theme-level growth, a velocity map, term drivers, brand/product attribution, seasonality and top searches — plus a full Excel workbook export.
Everything runs locally. No uploads, no accounts, no tracking. The code is MIT on GitHub.
A few things I'm proud of:
• The query engine supports NEAR/n, NOT, wildcards and phrases, matched against words (not raw strings), with light stemming.
• "Bare note" and "product context" toggles rescue searches like "sandalwood candle" that naive keyword matching drops.
• The Coverage card tells you exactly which searches didn't match and why, and exports them as CSV so you can extend your definitions.
It's a v1 and I'd love feedback on: which categories you'd want starter dictionaries for, whether the Boolean syntax is intuitive, and any edge cases in the parser.
Try the live demo (pre-loaded fragrance example) at https://opentrends.win/ — no signup.
Happy to answer anything in the comments! 🙏
About Open Trends on Product Hunt
“Free theme-level trend analysis from Keyword Planner data”
Open Trends was submitted on Product Hunt and earned 0 upvotes and 1 comments, placing #238 on the daily leaderboard. A free, open-source browser app that turns Google Keyword Planner exports into theme-level trend analysis for any category: growth, velocity, seasonality and top searches. No accounts, no tracking — everything runs locally in your browser.
On the analytics side, Open Trends competes within Open Source, Marketing, SEO and GitHub — topics that collectively have 619.4k followers on Product Hunt. The dashboard above tracks how Open Trends performed against the three products that launched closest to it on the same day.
Who hunted Open Trends?
Open Trends was hunted by Saarth Jauhari. A “hunter” on Product Hunt is the community member who submits a product to the platform — uploading the images, the link, and tagging the makers behind it. Hunters typically write the first comment explaining why a product is worth attention, and their followers are notified the moment they post. Around 79% of featured launches on Product Hunt are self-hunted by their makers, but a well-known hunter still acts as a signal of quality to the rest of the community. See the full all-time top hunters leaderboard to discover who is shaping the Product Hunt ecosystem.
For a complete overview of Open Trends including community comment highlights and product details, visit the product overview.
Saarth Jauhari