Google Sheets and Excel help that shows its work
Get any spreadsheet right.
Find a tutorial, fix a broken formula, or check your whole sheet for errors. Every step shown live.
Start with what you’re trying to do.
Format a
spreadsheet
Make sheets readable, consistent, and ready to share.
Clean messy
data
Fix duplicates, split text, trim spaces, and standardise values.
Build a
formula
Get the exact formula and understand why it works.
Fix an error
Understand what broke and repair it without guessing.
Short tutorials that show
the exact move.
Search for the thing you need to do, then follow a short recording inside a real spreadsheet. The written steps, expected result, and common mistakes are all on the same page.
Browse every tutorial →Extract Page Titles and Meta Descriptions Into Google Sheets
Watch the steps →02▶YouTube · Source workflow · 210sExtract Every Link From a Webpage Into Google Sheets
Watch the steps →03▶YouTube · Source workflow · 210sHow to Scrape Shopify Products Into Google Sheets
Watch the steps →04▶YouTube · Source workflow · 210sScrape Product Prices Into Google Sheets
Watch the steps →05▶YouTube · Advanced workflow · 210sScrape a JavaScript-Rendered Website Into Google Sheets
Watch the steps →06▶YouTube · Advanced workflow · 210sScrape a Whole URL Column in Google Sheets
Watch the steps →07▶YouTube · Troubleshooting · 210sIMPORTHTML Not Working? Here Is Why
Watch the steps →08▶YouTube · Troubleshooting · 210sIMPORTXML Could Not Fetch URL: Seven Fixes
Watch the steps →09▶YouTube · Core scraping · 210sImport Data From Any Website Into Google Sheets
Watch the steps →10▶YouTube · Core scraping · 240sWeb Scraping With Google Sheets, No Code Needed
Watch the steps →11▶YouTube · Troubleshooting · 210sIMPORTXML Not Working? Fix Every Common Error
Watch the steps →12▶YouTube · Native functions · 210sHow to Use IMPORTXML in Google Sheets
Watch the steps →13▶YouTube · Core scraping · 210sScrape Any Public Webpage Without Writing Code
Watch the steps →14▶YouTube · Core scraping · 210sIMPORTXML vs Apps Script vs SheetSteps AI
Watch the steps →See it happen.
Then do it yourself.
- 1
Find the exact taskSearch by menu, result, formula, or error.
- 2
Watch it in a real sheetFollow every click and value without skipping ahead.
- 3
Check your resultCompare the finished sheet and catch common mistakes.
Verified by real humansThe result, written steps, and recording are checked before publishing.
✓Formula help for the moment
you get stuck.
Fix a broken formula, write one from plain English, understand an unfamiliar formula, or change one you already use. You get one recommended Google Sheets formula first, followed by a clear explanation.
Useful templates.
Ready for your workflow.
A growing library of editable Google Sheets templates, each connected to a SheetSteps tutorial so you can understand it before you make it yours.
Bank reconciliation
Template + how-to in Sheets
Cash-flow model
12-month rolling forecast
P&L statement
Build it from transactions
Invoice tracker
Paid / overdue automation
Depreciation schedule
Straight-line & declining
Expense tracker
Categorize & total
Loan amortization
Payment schedule formula
AR aging report
30/60/90 buckets