What is Get & Transform in Google Sheets?
Get & Transform is Microsoft's ribbon name for Power Query in Excel. In Google Sheets, think File > Import, IMPORTHTML, IMPORTXML, IMPORTDATA, IMPORTRANGE, and QUERY for shaping data. Connected Sheets covers large warehouse extracts Excel users handled with Power Query plus data model.
When to use it
Use this mapping when Excel docs say Get & Transform instead of Power Query.
When to skip it
Skip rebuilding every query step when a single IMPORT plus QUERY already matches the output.
Better Sheets resources
Related Tutorials
Watch how Get & Transform works
Convert Google Sheets into a REST API
Scrape Google Maps
The First Thing I Do When Starting a Google Sheet
Embed a Number in a Website from a Google Sheet
Google Sheets Interface Changes
Create Hundreds of Tweets in a Google Sheet
Related blog posts
Guides that explain Get & Transform in more depth.
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Google Sheets Interface Changes
New Date Chips and Integration with Google Workspace makes Google Sheets much more useful, within the ecosystem. It's a great tool within workspace now.
Read post →Related terms
Power Query
Power Query is Excel's click-and-refresh ETL engine. Google Sheets combines IMPORT functions, QUERY, Apps Script, Connected Sheets, and add-ons for the same jobs: pull web or file data, reshape tables, and refresh on a schedule. There is no Power Query UI inside Sheets.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →importing data into Sheets
Importing means pulling external data into a spreadsheet tab: from a file upload, another Google Sheet, a published CSV URL, or a function like IMPORTRANGE. The import dialog controls separator, locale, and whether new rows replace or append existing data.
Read guide →Connected Sheets
Connected Sheets lets you explore very large datasets from BigQuery (and related Google Cloud sources) through a Sheets interface with extracts, pivot-style analysis, and scheduled refresh. You work with a connected tab instead of pasting millions of rows into the grid. It targets analysts who outgrow IMPORTRANGE but still want a spreadsheet UX.
Read guide →Done reading about Get & Transform?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.