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.

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.
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.
Hand a sheet to a team
Constrain inputs, lock the formula cells, then share, so edits from colleagues cannot quietly break the model.
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.
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.

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.

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.

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.

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.

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.

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.

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.

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.

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.
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.

How to add a new sheet in Google Sheets
Learn how to add, rename, duplicate, and organize new sheets in Google Sheets on desktop and mobile, including shortcuts and templates.

How to add columns in Google Sheets
Learn how to insert one or multiple columns in Google Sheets using right-click menus, the Insert menu, or a keyboard shortcut.

How to move or swap rows in Google Sheets
Swap two rows in Google Sheets with Edit > Move > Row up or Row down, or drag a row by its number, without losing data. Includes an interactive demo.

How to shift cells down in Google Sheets
Right-click a range and choose Insert cells > Shift down, or press Ctrl+Alt+= (Cmd+Option+= on Mac). Everything below moves down. See the interactive demo.

How to sort a table A–Z in Google Sheets
Sort a table in Google Sheets A to Z or by several columns without scrambling rows. Keep the header in place, or sort with a formula instead.
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.

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.

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.

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.

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.

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.

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.

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

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.

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.
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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.
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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.
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.

How to add a dropdown list in Google Sheets
Learn how to add a dropdown list in Google Sheets using data validation, so cells only accept approved values from a list.

How to use data validation in Google Sheets
Learn how to set up data validation in Google Sheets to restrict entries, build dropdowns, add checkboxes, and enforce custom rules.

Lock cells and protect a range in Google Sheets
Lock cells in Google Sheets with Data > Protect sheets and ranges. Restrict who can edit, show a warning instead, or lock a whole sheet except input cells.

How to share a Google Sheet for editing
Learn how to share a Google Sheet for editing using email invites or shareable links, and control who can edit, comment, or view your data.

How to add a comment in Google Sheets
Learn how to add, tag, reply to, and resolve comments in Google Sheets to give feedback without changing cell data.
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.