And you don't need to be a prompt engineer to get it.
Columnly cleans, reshapes, computes, and reports on your Google Sheet in plain English — and every figure traces back to the cell it came from. Nothing fabricated, nothing untraceable, nothing it can't show its work for.
Columnly isn't prompt-in, answer-out. It interrogates a vague request about your Google Sheet and recommends — with a reason — so the output is the one you actually wanted. That's why a three-word prompt works.
You don't engineer the prompt. Columnly asks the right questions.
No format, no role-play, no examples. Someone typed this — run-on and all — and got the analysis below.
Analysis brief. A headline thesis, a five-number scorecard, and the evidence — then it keeps going into a ranked action plan and an honest "not covered" note.
That same one-line ask, returned as an interactive dashboard — real charts, KPI scorecard, fulfillment funnel, payment split, action priorities.
Columnly doesn't stop at computing — it tells you what the numbers mean: the headline finding, what's driving it, and the next move worth making. Every claim stays traceable back to the cells it came from, so an insight is something you can defend, not just read.
For every task, Columnly's model drafts a structured plan, a pure-Python engine executes it and returns an honest diff of exactly what changed — and that engine never edits your Google Sheet directly; a separate step applies the verified result. No arbitrary code runs on your Google Sheet, and failures are loud, never silent.
Normalize variant values in your Google Sheet with a completeness guarantee — every distinct value is accounted for, nothing is guessed, and a cell is never blanked unless you ask. Parse dates and numbers, trim whitespace, find/replace, dedupe rows.
Writes real, recalculating Google Sheets formulas — each one cross-checked against an independent computation before it lands. Logic, math, text, dates, regex, lookups, conditional aggregates. Data-exfiltration functions are blocked.
Pandas-backed restructuring of your Google Sheet that composes to virtually any reshape — pivot, unpivot, crosstab, group-aggregate, split/merge, explode, window, rank, within-sheet lookup — chained in one pass, through a safe op vocabulary, not arbitrary code.
Fonts, colours, fills, borders, alignment, banding, convert-to-table, column widths, number / date / accounting formats — applied straight to your Google Sheet, plus full conditional-formatting rules on number, text, and date predicates.
Most of your real questions live across several tabs of one Google Sheets workbook. Columnly reads the entire workbook and reconciles it into one answer.
Data spread across multiple tabs — orders here, costs there, a legend tab over there — stitched into a single brief or dashboard. You ask once; Columnly reconciles the sources.
Pivot one dimension against another — counts, sums, shares — into a clean, labelled crosstab, straight from a plain-English ask.
Point at a formula that pulls inputs from several tabs and ask "what does this do?" — Columnly explains it in plain English and traces every input back to the tab it came from.
When tabs overlap or disagree, Columnly checks before it combines — duplicate tabs, mismatched keys, legend meanings — so a cross-tab number is reconciled, never silently merged.
We're finalizing tiers. Add Columnly to your sheet today — you'll be the first to know when pricing goes live.
Free generation, then deterministic verification — an untraceable or fabricated number cannot ship. That's the line between a demo and something a business will trust with its data.
The embedded analyst for Google Sheets.