GSC tools

Upload a Search Console .xlsx export—get JSON with meta + rows, Markdown table, or TSV for LLM prompts.

Paste or upload CSV/TSV from Search Console—same AI-ready JSON, Markdown, or TSV normalization.

Low CTR, striking distance, zero-click, and top-impression buckets from your export—local analysis.

Click-through rate from clicks and impressions.

Clicks needed to hit a target CTR at given impressions.

Lowercase, trim, and collapse whitespace on query lines.

Remove duplicate query lines (case-insensitive).

Row impressions as % of pasted total.

Round average position values for reporting.

Extra clicks if CTR improved to a target.

Convert comma-separated query rows to TSV.

Keep query lines containing a substring.

Flag queries with position between 4 and 10.

Position delta between two average positions.

Character and word count per query line.

Mean position from pasted values.

Row clicks as percent of total clicks.

Count queries by word count bucket.

Position gap to reach top 3.

Rank queries by impression count.

Alphabetically sort query lines.

Convert query,clicks,impressions rows to JSON.

Label CTR as low, average, or high for position.

Median average position from pasted values.

Clicks needed to reach a target CTR at fixed impressions.

Keep or drop lines containing a brand term.

Impression-to-click ratio for one row.

Label position as top 3, page one, or deeper.

Normalize query,clicks,impressions rows to clean CSV.

Keep top N queries by clicks from pasted rows.

Count distinct queries in a pasted list.

Share of total clicks from selected rows.

Min, max, and range of pasted positions.

Rank pasted query,clicks rows by clicks descending.

List rows at or above a CTR percent threshold.

Weighted average position using impressions.

Extra clicks needed at fixed impressions for target CTR.

Trim whitespace and dedupe query lines.

Positions needed improvement to reach top 10.

Convert query,clicks,impressions to markdown table.

Flag queries below CTR percent with enough impressions.

Keep rows above an impression threshold.

Percent change between two click totals.

Percent of total clicks per query row.

Rank query rows by CTR percent descending.

Rank rows by impressions descending.

Group queries into position bands (1–3, 4–10, etc.).

Visual click share with ASCII bars per query.

Impression-weighted average CTR from rows.

Count words per query and bucket by length.

Convert pipe-delimited rows to CSV.

Keep top N queries by clicks.

Impressions needed at target CTR for click goal.

Percent of total impressions per query row.

List queries with average position 11–20.

Sort query rows alphabetically.

Median CTR percent across query rows.

Convert query,clicks,impressions lines to JSON array.

Clicks per 1000 impressions per row.

Keep queries with character length in range.

Position improvement needed to reach rank 1.

Flag short single-word queries as likely brand.

Count rows and sum clicks and impressions.

Keep Search Console rows whose clicks meet a minimum.

Impression-weighted average position across query rows.

Lowercase the first CSV field on each GSC row.

Flag each row’s CTR percent against a target.

Convert query rows to one JSON object per line.

Rank pasted GSC rows by clicks, highest first.

Remove rows whose impressions are zero.

Ceil the fourth (position) field on each row.

Slugify the query field on each GSC row.

Average clicks across pasted Search Console rows.

Keep Search Console rows whose clicks are at or below a maximum.

Rank pasted GSC rows by impressions, highest first.

Trim whitespace from the query field on each GSC row.

Rank rows by click-through rate, highest first.

Convert query rows to CSV with header query,clicks,impressions.

Each row's percentage of total clicks in the paste.

Remove rows whose impressions fall below a minimum.

Floor the fourth (position) field on each row.

Title-case the query field on each GSC row.

Sum impressions and count rows in a pasted GSC slice.

Average click-through rate across pasted GSC rows.

Rank pasted GSC rows by clicks, highest first.

Character length of each query field on GSC rows.

Keep the top N rows by impressions.

Round the position field to one decimal on each row.

Remove rows with zero clicks from a GSC paste.

Convert query rows to tab-separated values with header.

Sum clicks and count rows in a pasted GSC slice.

Keep rows whose position is at or above a minimum rank.

Per-row CTR with impression share weight.

Median clicks across pasted GSC rows.

Rank pasted GSC rows by impressions ascending.

Count words in each query field on GSC rows.

Keep the bottom N rows by clicks.

Round the position field up to the next integer.

Keep rows whose impressions meet a minimum.

Convert query rows to JSON objects per line.

Sum impressions and count rows in a pasted GSC slice.

Keep rows whose position is at or below a maximum rank.

Rank pasted GSC rows by click-through rate.

Maximum clicks across pasted GSC rows.

Rank pasted GSC rows by clicks descending.

Character count in each query field on GSC rows.

Keep the top N rows by clicks.

Round the position field down to the previous integer.

Keep rows whose clicks meet a minimum.

Convert query rows to tab-separated values.

Sum clicks and count rows in a pasted GSC slice.

Keep rows whose position is at or above a minimum rank.

Rank pasted GSC rows by impressions descending.

Minimum clicks across pasted GSC rows.

Rank pasted GSC rows by impressions ascending.

Word count in each query field on GSC rows.

Keep the bottom N rows by clicks.

Round the position field up to the next integer.

Keep rows whose clicks are at or below a maximum.

Convert query rows to a JSON array.

Sum impressions and count rows in a pasted GSC slice.

Keep rows whose position is at or below a maximum rank.

Assign rank numbers by clicks descending.

Minimum clicks across pasted GSC rows.

Rank pasted GSC rows by impressions ascending.

Word count in each query field on GSC rows.

Keep the bottom N rows by clicks.

Round the position field up to the next integer.

Keep rows whose clicks are at or below a maximum.

Convert query rows to a JSON array.

Sum impressions and count rows in a pasted GSC slice.

Keep rows whose position is at or below a maximum rank.

Assign rank numbers by clicks descending.

Median average position across pasted GSC rows with a position column.

Keep rows whose query contains a brand keyword.

Compute click-through rate (clicks ÷ impressions) per row.

Median impressions across pasted GSC rows.

Filter rows whose query contains a substring.

Convert pasted query rows to CSV with headers.

Mean clicks across pasted GSC rows.

Keep rows whose impressions meet or exceed a minimum.

Rank rows by average position ascending (best rank first).

Minimum impressions across pasted GSC rows.

Most frequent average position across pasted GSC rows.

Exclude rows whose query contains a brand keyword.

Each row's share of total clicks in the paste.

Median clicks across pasted GSC rows.

Filter rows whose query starts with a prefix.

Convert pasted query rows to tab-separated values.

Mean impressions across pasted GSC rows.

Row with the highest clicks in the paste.

Rank rows by click-through rate descending.

Worst (highest) average position in the paste.

Best (lowest) average position across pasted GSC rows.

Each row's share of total impressions in the paste.

Filter rows whose query ends with a suffix.

Row with the lowest clicks in the paste.

Convert pasted query rows to JSON array.

Mean clicks across pasted GSC rows.

Keep rows whose CTR meets or exceeds a threshold.

Character length of each query in the paste.

Impression-weighted average position.

Rank rows by impressions descending.

Worst (highest) average position across pasted GSC rows.

Row with the highest clicks in the paste.

Convert pasted query rows to tab-separated values.

Filter rows whose query starts with a prefix.

Median clicks across pasted GSC rows.

Rank rows by click-through rate descending.

Word count of each query in the paste.

Sum clicks across pasted GSC rows.

Sum impressions across pasted GSC rows.

Keep rows whose position falls within a min–max band.

Mean average position across pasted GSC rows.

Each row's share of total clicks in the paste.

Filter rows whose query contains a substring.

Convert pasted query rows to quoted CSV.

Median impressions across pasted GSC rows.

Rank rows by position ascending (best first).

Rows whose CTR falls below a threshold.

Keep first occurrence of each unique query.

Mean impressions across pasted GSC rows.

Keep rows with position between 4 and 20.

Count pasted GSC query rows.

Most frequent click count across pasted GSC rows.

Rank rows by clicks descending.

Minimum impressions across pasted GSC rows.

Row with the lowest click-through rate.

Uppercase the query field on each GSC row.

Convert pasted query rows to an HTML table.

Filter rows with zero impressions.

Max minus min clicks across pasted rows.

Min and max average position in a four-column paste.

Total clicks across pasted GSC rows.

Total impressions across pasted GSC rows.

Mean clicks per row in a pasted slice.

Rank rows by impressions descending.

Trim whitespace on query field per row.

Convert pasted query rows to JSON array.

Rows with CTR above 5% in the paste.

Filter rows with zero clicks.

Character count per query in the paste.

Median average position in a four-column paste.

Minimum clicks across pasted GSC rows.

Maximum clicks across pasted GSC rows.

Mean impressions across pasted GSC rows.

Rank rows by click-through rate descending.

Best (lowest) average position in a four-column paste.

Worst (highest) average position in a four-column paste.

Convert pasted query rows to tab-separated values.

Rows with CTR below 2% in the paste.

Filter rows whose query starts with a prefix.

Each row's share of total impressions in the paste.

Median clicks across pasted GSC rows.

Each row's share of total clicks in the paste.

Convert pasted query rows to CSV with header.

Rows with average position between 4 and 10.

Filter rows whose query contains a brand token.

Filter rows whose query contains a substring.

Mean average position in a four-column paste.

Impression-weighted average position.

Top N rows by clicks descending.

Filter rows with CTR above a threshold percent.

Wrap normalized GSC JSON in CTR audit, striking-distance, or full SEO handoff LLM prompts.