Google Sheets How-to Guides

Google Sheets how-tos for cleaning CSV imports, filtering and de-duplicating rows, writing lookup formulas, building charts, and locking down shared sheets.

Illustration for Google Sheets guides

These guides are for people who live in spreadsheets without being analysts: ops, finance, marketing and support staff inheriting a messy sheet and needing it to behave. They cover formatting, sorting and filtering, CSV and Excel imports, charts and pivot tables, formulas from SUM to QUERY, and the permissions that stop a shared sheet being overwritten.

Common Google Sheets workflows

Clean an imported CSV

A vendor export arrives with ragged columns and repeats. Get it into Sheets first, make it readable, then strip duplicates before anything depends on it.

  1. How to open a CSV file in Google Sheets
  2. How to make columns wider in Google Sheets
  3. How to freeze rows in Google Sheets
  4. How to find duplicates in Google Sheets
  5. How to remove duplicates in Google Sheets

Build a monthly report

Totals first, then a pivot to slice them, then a chart for the summary. Charting last means the numbers are already settled.

  1. How to use SUMIF in Google Sheets
  2. How to create a pivot table in Google Sheets
  3. Create and customize a chart in Google Sheets

Hand a sheet to a team

Constrain inputs, lock the formula cells, then share, so edits from colleagues cannot quietly break the model.

  1. How to use data validation in Google Sheets
  2. How to add a dropdown list in Google Sheets
  3. Lock cells and protect a range in Google Sheets
  4. How to share a Google Sheet for editing

Join two data sources

Pull a second spreadsheet in, match rows on a shared key, and trap lookup misses so blanks do not show as errors.

  1. How to use IMPORTRANGE in Google Sheets
  2. How to use VLOOKUP in Google Sheets
  3. How to use IFERROR in Google Sheets

Google Sheets guides

Enter and format cell data

You have the numbers in, but the sheet is hard to read: clipped text, odd column widths, or headers that scroll away. Work here before anyone else opens it.

Illustration for How to add a text box in Google Sheets
Google Sheets7 steps2 min read

How to add a text box in Google Sheets

Learn how to insert, resize, and format a text box in Google Sheets using the Drawing tool to add labels, callouts, or extra notes to any spreadsheet.

Interactive demo
Illustration for How to wrap text in Google Sheets
Google Sheets6 steps2 min read

How to wrap text in Google Sheets

Learn how to wrap text in Google Sheets so long cell content displays on multiple lines instead of overflowing into neighboring cells.

Interactive demo
Illustration for How to format numbers as currency in Google Sheets
Google Sheets7 steps2 min read

How to format numbers as currency in Google Sheets

Format > Number > Currency applies dollars in two clicks. For euros, pounds, or symbol placement, use Custom currency. Try it in the interactive demo.

Interactive demo
Illustration for How to merge cells in Google Sheets
Google Sheets7 steps2 min read

How to merge cells in Google Sheets

Learn how to merge cells in Google Sheets horizontally, vertically, or all at once, plus how to unmerge and avoid data loss.

Interactive demo
Illustration for How to use conditional formatting in Google Sheets
Google Sheets7 steps3 min read

How to use conditional formatting in Google Sheets

Learn to highlight cells, rows, or columns automatically in Google Sheets using conditional formatting rules, color scales, and custom formulas.

Interactive demo
Illustration for How to add checkboxes in Google Sheets
Google Sheets7 steps3 min read

How to add checkboxes in Google Sheets

Learn how to insert, customize, and use checkboxes in Google Sheets for to-do lists, tracking, and dynamic charts.

Interactive demo
Illustration for How to edit row size in Google Sheets
Google Sheets6 steps2 min read

How to edit row size in Google Sheets

Learn how to resize rows in Google Sheets by dragging, entering exact pixel heights, or auto-fitting rows to match your content.

Interactive demo
Illustration for How to make columns wider in Google Sheets
Google Sheets6 steps3 min read

How to make columns wider in Google Sheets

Widen one column in Google Sheets by dragging or double-clicking its border, or resize all columns at once with Resize columns and Fit to data.

Interactive demo
Illustration for How to freeze rows in Google Sheets
Google Sheets7 steps2 min read

How to freeze rows in Google Sheets

Learn how to freeze rows in Google Sheets so headers stay visible while scrolling, plus how to adjust or remove frozen rows.

Interactive demo

Organise rows, columns, and sheets

The structure is wrong rather than the contents. Rows are out of order, a column is missing, or one tab is carrying too much.

Filter and find data

A sheet has grown past what you can scan by eye and you need one customer, one status, or the repeated entries hiding in it.

Illustration for How to create a filter in Google Sheets
Google Sheets7 steps2 min read

How to create a filter in Google Sheets

Learn how to create a filter in Google Sheets to sort, hide, and analyze data quickly using the built-in filter tool on any free account.

Interactive demo
Illustration for How to create a filter view in Google Sheets
Google Sheets7 steps3 min read

How to create a filter view in Google Sheets

Learn how to create a filter view in Google Sheets to sort, filter, and analyze data privately without changing what collaborators see in the file.

Interactive demo
Illustration for How to remove a filter in Google Sheets
Google Sheets7 steps3 min read

How to remove a filter in Google Sheets

Remove a filter in Google Sheets with the toolbar's Remove filter button or Data > Remove filter, or clear one column's criteria only. Includes a demo.

Interactive demo
Illustration for How to filter data in Google Sheets
Google Sheets6 steps2 min read

How to filter data in Google Sheets

Learn how to filter data in Google Sheets using column filters, filter by condition, and filter by values on the free plan.

Interactive demo
Illustration for How to filter by color in Google Sheets
Google Sheets7 steps2 min read

How to filter by color in Google Sheets

Learn to filter by fill color or text color in Google Sheets to quickly isolate highlighted rows in any dataset.

Interactive demo
Illustration for How to search in Google Sheets
Google Sheets4 steps4 min read

How to search in Google Sheets

Learn how to search for text, numbers, or formulas in Google Sheets using Ctrl+F to find matches and Ctrl+H to replace them.

Interactive demo
Illustration for How to find duplicates in Google Sheets
Google Sheets7 steps2 min read

How to find duplicates in Google Sheets

Learn how to find and highlight duplicate entries in Google Sheets using conditional formatting and COUNTIF formulas.

Interactive demo
Illustration for How to highlight duplicates in Google Sheets
Google Sheets7 steps2 min read

How to highlight duplicates in Google Sheets

Learn how to highlight duplicate values in Google Sheets using conditional formatting and COUNTIF, covering single columns, rows, and multiple columns.

Interactive demo
Illustration for How to remove duplicates in Google Sheets
Google Sheets6 steps2 min read

How to remove duplicates in Google Sheets

Learn how to find and remove duplicate rows in Google Sheets using the built-in Remove Duplicates tool in just a few clicks.

Interactive demo

Import, connect, and automate

Data starts life somewhere else: a CSV export, a form, another spreadsheet. These cover getting it in, keeping it linked, and getting it out again.

Illustration for How to open a CSV file in Google Sheets
Google Sheets4 steps3 min read

How to open a CSV file in Google Sheets

Learn how to open a CSV file in Google Sheets from Drive or by importing it — preserve formatting and keep your column structure.

Interactive demo
Illustration for How to convert CSV to Google Sheets
Google Sheets4 steps3 min read

How to convert CSV to Google Sheets

Learn how to convert a CSV file to Google Sheets format, preserve your column structure, and save it as a native Sheets file.

Interactive demo
Illustration for How to download a Google Sheet as Excel
Google Sheets6 steps2 min read

How to download a Google Sheet as Excel

Learn how to convert and download any Google Sheet as a Microsoft Excel (.xlsx) file for free, with offline editing and formatting intact.

Interactive demo
Illustration for How to connect Google Forms to Google Sheets
Google Sheets7 steps2 min read

How to connect Google Forms to Google Sheets

Step-by-step guide to connecting Google Forms responses to a Google Sheets spreadsheet, including creating a form directly from an existing sheet.

Interactive demo
Illustration for How to use IMPORTRANGE in Google Sheets
Google Sheets7 steps3 min read

How to use IMPORTRANGE in Google Sheets

Learn how to use IMPORTRANGE to pull live data between Google Sheets files, grant access permissions, and fix common import errors.

Interactive demo
Illustration for How to use Apps Script in Google Sheets
Google Sheets7 steps3 min read

How to use Apps Script in Google Sheets

Learn how to open, write, and run Apps Script in Google Sheets to automate tasks, build custom functions, and add menus.

Interactive demo
Illustration for How to use AI features in Google Sheets
Google Sheets7 steps3 min read

How to use AI features in Google Sheets

Learn how to use the AI function in Google Sheets to generate text, summarize data, categorize entries, and analyze sentiment.

Build charts and summaries

Someone wants the picture, not the rows. Use these when a report, slide or stand-up needs the trend or the breakdown.

Illustration for Create and customize a chart in Google Sheets
Google Sheets7 steps4 min read

Create and customize a chart in Google Sheets

Create a chart in Google Sheets with Insert > Chart, then customize titles, colors, legend, and labels in the Chart editor. Fixes for charts that plot wrong.

Interactive demo
Illustration for How to make a bar graph in Google Sheets
Google Sheets6 steps3 min read

How to make a bar graph in Google Sheets

Learn how to turn spreadsheet data into a clear bar graph in Google Sheets, from selecting your data to customizing colors and labels.

Interactive demo
Illustration for How to make a line graph in Google Sheets
Google Sheets7 steps3 min read

How to make a line graph in Google Sheets

Learn how to build and customize a line graph in Google Sheets, from selecting data to styling axes, legends, and colors on the free plan.

Interactive demo
Illustration for How to make a pie chart in Google Sheets
Google Sheets7 steps3 min read

How to make a pie chart in Google Sheets

Learn how to build, format, and customize a pie chart in Google Sheets to visualize parts of a whole using your own spreadsheet data in minutes.

Interactive demo
Illustration for How to add a legend to a chart in Google Sheets
Google Sheets7 steps2 min read

How to add a legend to a chart in Google Sheets

Learn how to add, edit, and reposition a legend on any Google Sheets chart using the Chart editor's Customize tab.

Interactive demo
Illustration for How to add an X axis in Google Sheets
Google Sheets7 steps2 min read

How to add an X axis in Google Sheets

Add and label the X axis on a Google Sheets chart from the Chart editor's Customize tab: set the axis title, then style its labels. Interactive demo included.

Interactive demo
Illustration for How to use sparklines in Google Sheets
Google Sheets7 steps3 min read

How to use sparklines in Google Sheets

Learn how to build compact in-cell sparkline charts in Google Sheets using the SPARKLINE function to visualize trends fast.

Interactive demo
Illustration for How to create a pivot table in Google Sheets
Google Sheets7 steps3 min read

How to create a pivot table in Google Sheets

Learn how to create a pivot table in Google Sheets to summarize, filter, and analyze large data sets quickly, without any formulas.

Interactive demo

Write formulas

A value has to be calculated, looked up, or counted rather than typed. Pick by the question you are asking, from simple totals up to lookups and queries.

Illustration for How to use the SUM formula in Google Sheets
Google Sheets7 steps2 min read

How to use the SUM formula in Google Sheets

Learn how to add up numbers in Google Sheets using the SUM formula, from single ranges to multiple columns and mobile edits.

Interactive demo
Illustration for How to use SUMIF in Google Sheets
Google Sheets7 steps2 min read

How to use SUMIF in Google Sheets

Learn how to use the SUMIF function in Google Sheets to total values that meet a specific condition, with syntax and real examples.

Interactive demo
Illustration for How to use the IF formula in Google Sheets
Google Sheets7 steps2 min read

How to use the IF formula in Google Sheets

Learn how to write IF formulas in Google Sheets to test conditions, return custom results, and automate decisions in your data.

Interactive demo
Illustration for How to use IFERROR in Google Sheets
Google Sheets7 steps3 min read

How to use IFERROR in Google Sheets

Learn how to use IFERROR in Google Sheets to catch formula errors like #N/A and #DIV/0! and replace them with clean, custom values.

Interactive demo
Illustration for How to use COUNTIF in Google Sheets
Google Sheets6 steps2 min read

How to use COUNTIF in Google Sheets

Learn how to use the COUNTIF function in Google Sheets to count cells matching a condition, with text, number, and date examples.

Interactive demo
Illustration for How to count cells with text in Google Sheets
Google Sheets7 steps2 min read

How to count cells with text in Google Sheets

Learn how to count cells with text in Google Sheets using COUNTA, COUNTIF, and wildcards for exact or partial text matches.

Interactive demo
Illustration for How to use VLOOKUP in Google Sheets
Google Sheets7 steps3 min read

How to use VLOOKUP in Google Sheets

Learn how to write a VLOOKUP formula in Google Sheets to search a table and pull matching values into any cell automatically.

Interactive demo
Illustration for How to use INDEX MATCH in Google Sheets
Google Sheets7 steps3 min read

How to use INDEX MATCH in Google Sheets

Learn how to combine INDEX and MATCH in Google Sheets to look up data in any direction, with exact-match syntax and troubleshooting tips.

Interactive demo
Illustration for How to use the QUERY function in Google Sheets
Google Sheets7 steps2 min read

How to use the QUERY function in Google Sheets

Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data with a single SQL-like formula.

Interactive demo
Illustration for How to use ARRAYFORMULA in Google Sheets
Google Sheets7 steps2 min read

How to use ARRAYFORMULA in Google Sheets

Learn how to use ARRAYFORMULA in Google Sheets to apply one formula across an entire range without copying it into every cell.

Interactive demo
Illustration for How to use CONCATENATE in Google Sheets
Google Sheets7 steps3 min read

How to use CONCATENATE in Google Sheets

Learn how to combine text from multiple cells in Google Sheets using the CONCATENATE function, with syntax, examples, and formatting tips.

Interactive demo
Illustration for How to do multiplication in Google Sheets
Google Sheets7 steps2 min read

How to do multiplication in Google Sheets

Learn how to multiply numbers, cells, and columns in Google Sheets using the asterisk operator, the MULTIPLY function, and fill handles.

Interactive demo
Illustration for How to subtract in Google Sheets
Google Sheets7 steps2 min read

How to subtract in Google Sheets

Learn how to subtract numbers, cells, and dates in Google Sheets using formulas, the MINUS function, and cell references.

Interactive demo

Validate, protect, and share

More than one person is about to edit. Constrain what can be entered, lock what must not change, and decide who gets which access.

Frequently asked questions

  • Is Google Sheets free to use?

    Yes. Google Sheets is free for anyone with a Google account. Google Workspace (paid) adds advanced admin controls, storage, and collaboration features for teams.

  • Can Google Sheets open Excel files?

    Yes. Google Sheets can open .xlsx and .xls files directly and converts them to the Google Sheets format. You can also export back to Excel format at any time.

  • Should I use VLOOKUP or INDEX MATCH?

    VLOOKUP is quicker to write when the lookup column is leftmost. INDEX MATCH survives column changes and can look left, so it suits sheets that will keep changing.

  • Filter, filter view, or QUERY: which one?

    A filter changes what everyone sees, while a filter view is private to you. Reach for QUERY when the filtered result needs to live in its own range.

  • Which Google Sheets guide should I start with?

    Start with the guide that matches your immediate blocker: filtering for messy rows, freezing headers before review, importing CSV files, or formatting merged cells for a cleaner handoff.