Turn Your SEMrush Keyword Export Into a Content Plan

The Keyword Magic Tool is great at producing 10,000 keyword ideas and terrible at telling you how many pages that actually is. Upload your SEMrush CSV to Optiwing and get SERP-backed clusters that map every keyword to a specific page, pay-as-you-go.

Upload Your SEMrush CSV - Group 100 Keywords Free

100 free creditsNo credit card requiredCredits never expire

What Your Export Looks Like

Optiwing accepts SEMrush exports directly. A Keyword Magic Tool export typically includes Keyword, Intent, Volume, Keyword Difficulty, CPC, and Competitive Density. Optiwing reads the Keyword column and keeps Volume and Difficulty attached to every cluster.

Keyword	Intent	Volume	Keyword Difficulty	CPC (USD)
meal prep containers	Commercial	33,100	74	1.25
best meal prep containers	Commercial	9,900	68	1.51
glass meal prep containers	Commercial	8,100	55	1.10
how to meal prep for the week	Informational	6,600	49	0.85

Export from the Keyword Magic Tool or Keyword Manager with the Export button (choose CSV). Columns like Trend, SERP Features, or Number of Results can stay in the file - they are ignored during clustering.

The Workflow, Step by Step

Export your list from the Keyword Magic Tool

Filter by volume, KD, or intent in SEMrush, select the keywords you care about (or export all), and download as CSV. Broad match exports work well because SERP clustering will separate the mixed intents for you.

Upload the CSV to Optiwing

Create a free account (100 free credits, no credit card), hit +New on the dashboard, and drop in the SEMrush file. The Keyword, Volume, and Difficulty columns are detected automatically.

Set your market

Choose the Google location and device that match the SEMrush database you exported from. Clustering runs against live SERPs in that market, so US keywords get grouped by US results.

Launch and let live SERPs do the grouping

Optiwing pulls the top 10 Google results for each keyword and groups keywords that share 3 or more of the same URLs. Unlike lexical grouping, this splits 'glass meal prep containers' from 'how to meal prep' even when they share words, because Google ranks different pages for them.

Read the clusters as a page list

Every cluster is one page. The highest-volume keyword becomes the primary keyword, the rest are variations for subheadings and body copy. A 10,000-keyword export often collapses into a few hundred distinct pages, which is your real content backlog.

Export the plan or brief the writers

Download clusters as CSV for your editorial calendar or client deliverable, or generate an AI content brief per cluster (25 credits each) with suggested structure pulled from the ranking pages.

What You Get Back

SERP-Backed Clusters

Keywords grouped by shared top 10 Google results, so every group reflects real search intent rather than shared phrasing.

A Content Map

A defensible page list: primary keyword, variations, and combined SEMrush volume for every planned page.

CSV Export

One click back to CSV, ready for Google Sheets, Airtable, or the client-facing report template you already use.

Optional Content Briefs

AI briefs per cluster with headings, questions, and related terms, so writers start from the SERP instead of a blank page.

What It Costs

1 credit clusters 1 keyword. No seat licenses and no monthly minimum: buy a pack when you have an export to process, and unused credits never expire.

Job Size	Credits Needed	Cost	Notes
100 keywords	100	Free	Signup credits cover your first test run
2,500 keywords	2,500	$19	Personal pack, a filtered Keyword Magic export
10,000 keywords	10,000	$59	Founder pack, a full broad-match export
20,000 keywords	20,000	$110	Consultant pack, several client projects

Regular volume? The Starter subscription is $20/month for 5,000 fresh credits ($4.00 per 1,000 keywords), and subscription credits are always used before purchased ones.

See full pricing

Frequently Asked Questions

Does Optiwing accept SEMrush CSV exports without any editing?

Yes. Exports from the Keyword Magic Tool, Keyword Manager, and Organic Research all work as-is. Optiwing looks for the Keyword column and optionally Volume and Difficulty; every other SEMrush column is ignored, so there is nothing to clean up first.

SEMrush already shows keyword groups. Why cluster again?

The Keyword Magic Tool's left-hand groups are lexical: they bucket keywords that contain the same word, like everything with 'glass' in it. Optiwing groups by live SERP overlap, meaning two keywords land together only when Google ranks 3 or more of the same top 10 pages for both. That is the difference between a word filter and a page plan.

How many keywords can I process in one job?

There is no keyword limit or throttling; the only constraint is a 100MB file size cap per upload. Even six-figure exports fit if you remove unused columns or split the file. A 10,000-keyword job typically completes within minutes.

What does it cost compared to my SEMrush plan?

Clustering is pay-as-you-go at 1 credit per keyword: $19 covers 2,500 keywords and $59 covers 10,000, one-time, with credits that never expire. There is no per-seat fee, so it adds a few dollars per project on top of SEMrush instead of another subscription tier.

Can Optiwing replace SEMrush for me?

No. SEMrush remains your source for keyword research, backlinks, and site audits - Optiwing does not do those. It is the step after the export: turning a raw keyword list into SERP-backed clusters, content briefs, and rank tracking without upgrading your SEMrush tier for clustering credits.

Does the Intent column from SEMrush affect the clustering?

Clustering is driven purely by live SERP overlap, which captures intent more precisely than a per-keyword label. In practice you will see SEMrush's Informational and Commercial keywords naturally separate into different clusters because Google ranks different pages for them.

What should I do with the clusters once I have them?

Sort clusters by combined volume, pick the ones matching your site's authority level, and treat each as one article or landing page. Use the primary keyword in the title, variations in H2s, then generate a brief per cluster or export everything to CSV for your content calendar.