How to make a graph in Google Sheets
Turn a plain range into the right chart, choose better axes, and avoid the defaults that make spreadsheet graphs hard to read.
Published July 13, 2026 · Updated July 27, 2026SHEETSTEPS FIELD GUIDE
The SheetSteps blog
Clear spreadsheet lessons built around real cells, formulas and files.
Published July 13, 2026 · Updated July 27, 2026 · 8 min
How to make a graph in Google Sheets
Turn a plain range into the right chart, choose better axes, and avoid the defaults that make spreadsheet graphs hard to read.
Read article →
Google Sheets invoice template: build one that tracks payment
Create a polished invoice, calculate totals correctly, and keep sent, due and overdue invoices visible in one dependable sheet.
Published July 26, 2026 · Updated July 27, 2026
Google Sheets budget template: a practical monthly system
Plan income, set category limits, track actual spending and see what remains without turning budgeting into a second job.
Published July 25, 2026 · Updated July 27, 2026
How to create a table in Google Sheets
Structure raw data with headers, types, filters and totals so sorting and formulas keep working as the sheet grows.
Published July 24, 2026 · Updated July 27, 2026
How to sort in Google Sheets without scrambling rows
Sort a complete dataset by one or several columns while keeping every record intact.
Published July 23, 2026 · Updated July 27, 2026
How to merge cells in Google Sheets—and when not to
Merge titles and presentation blocks safely while keeping tables sortable, filterable and formula-friendly.
Published July 22, 2026 · Updated July 27, 2026
How to wrap text in Google Sheets
Keep long comments, descriptions and headers visible without making the entire spreadsheet awkward to scan.
Published July 21, 2026 · Updated July 27, 2026
How to use VLOOKUP in Google Sheets
Look up an ID, return the matching entry and fix the range, index and exact-match mistakes behind most VLOOKUP errors.
Published July 20, 2026 · Updated July 27, 2026
How to use SUMIF in Google Sheets
Add entries that match one condition, understand criteria syntax and graduate to SUMIFS when the question has more than one rule.
Published July 19, 2026 · Updated July 27, 2026
How to use IMPORTRANGE in Google Sheets
Pull a reliable range from another spreadsheet, grant access once and combine it with QUERY without creating a fragile chain.
Published July 18, 2026 · Updated July 27, 2026
Google Sheets formula not working? Check these seven things
Diagnose parse errors, wrong results, #N/A, #REF! and formulas displayed as text using a repeatable checklist.
Published July 17, 2026 · Updated July 27, 2026
How to use AI in Google Sheets for real work
Classify, extract, summarize and generate across rows while keeping prompts, outputs and costs predictable.
Published July 16, 2026 · Updated July 27, 2026
How to scrape a website into Google Sheets
Extract organized page data into rows, handle multiple URLs and know when IMPORTXML is enough—or when a browser-backed scraper is needed.
Published July 15, 2026 · Updated July 27, 2026
How to build a Google Sheets dashboard people can read
Turn a clean source table into a compact operating view with trustworthy KPIs, filters and charts.
Published July 14, 2026 · Updated July 27, 2026
Google Sheets calendar template: build a calendar that stays usable
Set up a monthly calendar with real dates, clean event fields and a layout that remains easy to edit.
Published June 8, 2026 · Updated July 24, 2026
Google Sheets formulas: the practical guide to writing them correctly
Learn the parts of a formula, how cell references behave and how to check a result before filling it down.
Published June 9, 2026 · Updated July 25, 2026
How to alphabetize in Google Sheets without mixing up rows
Sort names or labels from A to Z while keeping every record together.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets Gantt chart template: plan work on a real timeline
Turn tasks, owners, dates and status into a timeline that the team can update.
Published June 11, 2026 · Updated July 27, 2026
How to multiply in Google Sheets
Multiply cells, fixed rates and full columns without copying the wrong reference.
Published June 12, 2026 · Updated July 24, 2026
Google Sheets assignment tracker for classes and deadlines
Track classes, due dates, grades and overdue work in one compact student sheet.
Published June 13, 2026 · Updated July 25, 2026
Google Sheets project management template for small teams
Run a project with clear owners, due dates, status and a short weekly review.
Published June 14, 2026 · Updated July 26, 2026
How to search in Google Sheets
Find text, numbers and formulas in one sheet or the full workbook.
Published June 15, 2026 · Updated July 27, 2026
How to sum in Google Sheets
Add a row, a column or selected cells and keep the total accurate as entries are added.
Published June 16, 2026 · Updated July 24, 2026
How to add a column in Google Sheets
Insert one or several columns without losing formulas, formatting or filters.
Published June 17, 2026 · Updated July 25, 2026
ChatGPT for Google Sheets: practical ways to use AI with rows
Write formulas, classify text and process repeated rows while keeping checks around the output.
Published June 18, 2026 · Updated July 26, 2026
How to subtract in Google Sheets
Subtract cells, dates and fixed amounts with formulas that copy correctly.
Published June 19, 2026 · Updated July 27, 2026
ARRAYFORMULA in Google Sheets: fill a full column with one formula
Replace copied formulas with one array formula and handle blank rows cleanly.
Published June 20, 2026 · Updated July 24, 2026
Google Sheets percentage formulas for totals, growth and discounts
Calculate a share of total, percentage growth, discounts and percentage-point differences.
Published June 21, 2026 · Updated July 25, 2026
Best AI for Google Sheets: what to check before choosing a tool
Compare formula help, row processing, scraping and sheet editing by the work you actually need.
Published June 22, 2026 · Updated July 26, 2026
IMPORTHTML in Google Sheets: import tables and lists from a page
Pull a public HTML table or list into cells and fix the most common index mistakes.
Published June 23, 2026 · Updated July 27, 2026
Google Sheets errors: what each message means and how to fix it
Read missing-match, bad-reference, wrong-type, division and formula parse errors without guessing.
Published June 8, 2026 · Updated July 24, 2026
How to use IMPORTXML in Google Sheets
Extract page titles, headings, links and table cells with a tested XPath.
Published June 9, 2026 · Updated July 25, 2026
IMPORTXML not working in Google Sheets: fixes that match the cause
Check the XPath, returned HTML, page access and loading method before replacing the formula.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets conditional formatting not working: 8 checks
Repair rule ranges, custom formulas, date checks and rule order when cells do not format.
Published June 11, 2026 · Updated July 27, 2026
How to hide errors in Google Sheets without hiding broken logic
Use IFNA or IFERROR only after checking why the formula fails.
Published June 12, 2026 · Updated July 24, 2026
Google Sheets SUM that ignores errors
Total a range containing errors without deleting the source rows.
Published June 13, 2026 · Updated July 25, 2026
How to freeze rows and columns in Google Sheets
Keep headers and labels visible while scrolling through a large table.
Published June 14, 2026 · Updated July 26, 2026
How to make a dropdown in Google Sheets
Create a fixed list, set invalid-data behavior and apply it to future rows.
Published June 15, 2026 · Updated July 27, 2026
How to remove duplicates in Google Sheets safely
Delete repeated records while keeping a copy and checking which columns define a match.
Published June 16, 2026 · Updated July 24, 2026
How to filter in Google Sheets
Show only matching rows, save personal filter views and avoid changing what teammates see.
Published June 17, 2026 · Updated July 25, 2026
COUNTIF in Google Sheets: count rows that match one rule
Count statuses, names, dates and text matches with criteria that behave as expected.
Published June 18, 2026 · Updated July 26, 2026
SUMIFS in Google Sheets: sum with several conditions
Total entries by date, owner, status or category with aligned ranges.
Published June 19, 2026 · Updated July 27, 2026
INDEX MATCH in Google Sheets: a lookup that works in either direction
Return a field from any column without relying on a left-to-right table layout.
Published June 20, 2026 · Updated July 24, 2026
XLOOKUP in Google Sheets: cleaner exact-match lookups
Look up IDs, return entries from either side and set a clear not-found result.
Published June 21, 2026 · Updated July 25, 2026
Google Sheets date formulas for deadlines, months and working days
Calculate due dates, month boundaries, elapsed days and working-day schedules.
Published June 22, 2026 · Updated July 26, 2026
Google Sheets inventory template with reorder warnings
Track stock, unit cost, reorder points and incoming quantities in one file.
Published June 23, 2026 · Updated July 27, 2026
Profit and loss template for Google Sheets
Turn monthly income and expense entries into revenue, gross profit and net profit.
Published June 8, 2026 · Updated July 24, 2026
Loan amortization schedule in Google Sheets
Split each payment into interest and principal and track the remaining balance.
Published June 9, 2026 · Updated July 25, 2026
Google Sheets CRM template for a simple sales pipeline
Track contacts, next actions, deal stages and expected revenue without a full CRM app.
Published June 10, 2026 · Updated July 26, 2026
Google Sheets content calendar for planning and publishing
Plan titles, channels, owners, dates and production status in one schedule.
Published June 11, 2026 · Updated July 27, 2026
IMPORTHTML not working? Use SheetSteps AI to extract the page instead
Diagnose the formula error, then extract the same page with SheetSteps AI when Google cannot read the table or the page needs JavaScript.
Published July 20, 2026 · Updated July 28, 2026
How to scrape multiple URLs with SheetSteps AI
Turn a URL column into organized results with previews, controlled batches, cached fetches, progress states and retryable failures.
Published July 21, 2026 · Updated July 28, 2026
How to refresh web data with a SheetSteps AI batch
Replace volatile formula churn with deliberate refresh jobs, cached results, timestamps and clear edit tracking.
Published July 22, 2026 · Updated July 28, 2026
SheetSteps AI vs Apps Script for Google Sheets web scraping
Fetch public pages safely, parse small static responses and understand when a hosted queue is the better architecture.
Published July 23, 2026 · Updated July 28, 2026
How to import public API data with SheetSteps AI
Turn JSON responses into stable columns, handle pagination and errors, and avoid exposing API credentials in cells.
Published July 24, 2026 · Updated July 28, 2026
How to extract JSON page data with SheetSteps AI
Choose the correct record array, flatten nested objects and expand repeatable data into rows that formulas can use.
Published July 25, 2026 · Updated July 28, 2026
How to extract titles and meta descriptions with SheetSteps AI
Audit URL metadata in bulk with final URLs, status codes, canonical tags and clear missing-field states.
Published July 26, 2026 · Updated July 28, 2026
How to extract website links with SheetSteps AI
Collect hrefs, anchor text and link types from public pages, then normalize and deduplicate them for research or SEO review.
Published July 27, 2026 · Updated July 28, 2026
SHEETSTEPS_VISIT: bring clean webpage text into Google Sheets
Read a public webpage into one clean text cell for research, summaries, classification or translation.
Published July 12, 2026 · Updated July 28, 2026
SHEETSTEPS_TITLE: extract page titles into Google Sheets
Collect one title per URL for an SEO audit, research list or content inventory.
Published July 13, 2026 · Updated July 28, 2026
SHEETSTEPS_DESCRIPTION: extract meta descriptions into Google Sheets
Pull meta descriptions from public URLs and flag missing or duplicate entries.
Published July 14, 2026 · Updated July 28, 2026
SHEETSTEPS_H1: extract the primary heading from every URL
Collect the first H1 from public pages and compare it with each page title.
Published July 15, 2026 · Updated July 28, 2026
SHEETSTEPS_HEADINGS: extract a webpage heading outline
Return H1–H6 headings as a table for content research and on-page SEO review.
Published July 16, 2026 · Updated July 28, 2026
SHEETSTEPS_LINKS: extract webpage links into spreadsheet rows
Return page links as a spill table for link research, prospecting and SEO inspection.
Published July 17, 2026 · Updated July 28, 2026
SHEETSTEPS_IMAGES: extract image URLs and alt text
Collect page images into Google Sheets for media audits, ecommerce research or content review.
Published July 18, 2026 · Updated July 28, 2026
SHEETSTEPS_PAGE_DATA: audit core page metadata with one formula
Return a compact page-data object containing common SEO and document fields.
Published July 19, 2026 · Updated July 28, 2026
SHEETSTEPS_SELECTOR: scrape any public element with a CSS selector
Extract text or an allowed attribute from repeated page elements using a CSS selector.
Published July 20, 2026 · Updated July 28, 2026
SHEETSTEPS_SCHEMA: extract JSON-LD from webpages
Read public JSON-LD schema into Google Sheets for product, article, organization or local-business audits.
Published July 21, 2026 · Updated July 28, 2026
SHEETSTEPS_STATUS: check HTTP status and final URLs
Record response status, redirects and final destinations for a controlled URL list.
Published July 22, 2026 · Updated July 28, 2026
SHEETSTEPS_WEB_EXTRACT: extract custom fields from any public page
Describe the fields you want and return an organized object using hosted scraping plus your selected AI execution mode.
Published July 23, 2026 · Updated July 28, 2026