New A row picker for the BigQuery console

Pick the rows.
Get the SQL.

Tick rows in BigQuery's results and copy them as CSV, JSON or Markdown, or as ready-to-run SQL: WHERE IN filters, CTEs and validation checks. No screenshots, no retyping IDs.

7-day Pro trial, no card Your data never leaves the browser Chrome and Edge
Works in Google Chrome and Microsoft Edge Runs only on console.cloud.google.com 0 bytes of your data sent anywhere 19 outputs in one menu

See it in BigQuery

Five seconds from rows to results

Recorded in the real BigQuery console with made-up data. Pick a demo.

console.cloud.google.com · BigQuery

Tick three orders, copy a WHERE … IN filter, paste it under your query.

Built for the work around a query

BigQuery is great at queries.
Its results grid isn't built for what comes next.

You can't tick a few rows, grab just their IDs, or share three exact records without screenshots, retyping or exporting everything. Rowsmith fixes that, right in the console.

Validate and QA

Find duplicates, missing keys and changed rows between runs with checks written for you.

Tickets and docs

Paste the exact rows as a clean table instead of a cropped screenshot nobody can search.

Share exact data points

Send a teammate the three records that matter, as SQL they can run or JSON they can read.

Follow-up queries

Turn ticked rows into a WHERE … IN, a named CTE, a temp table or a join back to the source.

How it works

Three clicks. Nothing to set up.

No sign-in, no connection to your Google account, no query is ever run for you.

Run your query

As usual. Then click Pick rows on the results. Old jobs work too: Job history → View job in editor.

Tick what matters

Across every page. Filter, select all, invert, choose columns, open nested records.

Copy as…

CSV, JSON, Markdown, SQL or a validation check. Paste it into the editor, a sheet or a ticket.

Everything in the menu

Small tool. Serious output.

Every value is written as a typed GoogleSQL literal, so what you paste runs, and big numbers stay exact.

6 copy formats

TSV for Sheets and Excel, CSV, JSON, JSON Lines, Markdown and HTML tables.

SQL you can run

WHERE … IN, column lists, named CTEs, temp tables, INSERT … VALUES and join-back queries.

7 validation checks

Find keys, duplicates, missing keys, counts, compare with a table, nulls, everything except. Plus your own templates.

Select across pages

Pages, filter, select all, Shift-click ranges, invert, and View selected to see exactly what you picked.

Nested data

STRUCTs and ARRAYs as whole values, or opened into fields and unnested into rows. JSON, GEOGRAPHY and RANGE kept.

Keyboard first

Option/Alt+Shift shortcuts for select, invert, view selected, filter, pages and copy.

Private by design

Your data never leaves the tab.

Rowsmith reads what BigQuery already shows you, works on it in memory, and forgets it when you move on. Built so your security team can say yes.

Read the security details
  • No query data, SQL, table names or URLs sent anywhere. The build fails if a network call is added.
  • Nothing from your results is saved. Rows are dropped when the query changes or after 15 minutes idle.
  • Generated SQL is never run for you. You review it and run it.
  • Runs only on console.cloud.google.com, with the minimum permissions.
  • If Google changes the page, Rowsmith pauses instead of copying wrong data.

Pricing

Start free. Upgrade when it saves you an hour.

Every install starts with 7 days of Pro, no card needed. Then keep Free or go Pro.

Free

$0
forever
  • Up to 10 rows at a time, 1 key column
  • Copy as TSV, CSV and Markdown
  • WHERE … IN filters and column lists
  • Pages, filter, View selected, nested data
  • JSON, HTML, CTE, temp table, INSERT, join-back
  • Validation checks and templates
  • Select all, ranges, invert, choose columns, stats
Add to Chrome

Compare Free and Pro in detail →

Questions

Good to know

Does Rowsmith run queries or cost me BigQuery money?

No. It only reads results BigQuery already shows you. Generated SQL is copied for you to review and run yourself.

Can my company's data leak through it?

No query data is sent, saved or shared. There's no server, no account and no analytics in the extension. Rows live in the tab's memory and are dropped when you move on. See the security page.

Does it work with old jobs and table previews?

Old jobs, yes: open them with Job history → View job in editor. Table previews aren't readable by any extension today; query the table instead. Reading previews directly is planned.

What about very large results?

Rowsmith works with every row BigQuery loads into the page (a few thousand on huge results) and tells you how many of the total it has.

Which browsers?

Google Chrome and Microsoft Edge. Firefox is on the roadmap.

Is there a team plan?

Not yet. If your team wants shared templates, admin policy or SSO, tell us.

Stop screenshotting result grids.

Rowsmith is coming to the Chrome Web Store and Microsoft Edge Add-ons. Free to install, with 7 days of Pro.