=DIRECTORY.SHEETS

Google Sheets for Excel users

Official Sheets references, tutorials, communities, connectors, and videos for people who already know Excel.

Directory home Search resources

Search Excel resources

29 resources

Some outbound links may be affiliate or sponsored, and those are labeled where they appear. Ordering is editorial either way — nothing here is placed for money. Full disclosure.

youtube.comFree

5 essential Google Sheets data cleaning tips

Analytics with Adam: five cleanup techniques for messy imported data, duplicates included.

VideosGoogle Sheetsgoogle-sheets

ablebits.comFree

Ablebits Google Sheets tips

Task-shaped Sheets tutorials: duplicates, merges, dropdowns, IMPORTRANGE.

SitesGoogle Sheetsgoogle-sheets

youtube.comFree

Apps Script basics: Google Sheets for beginners

Eamonn Cottrell: closing lesson of a project series, automating a real workflow.

VideosGoogle Sheetsgoogle-sheets

benlcollins.comFree

Ben Collins

Long-form Sheets and Apps Script tutorials from a Google Developer Expert.

SitesGoogle Sheetsgoogle-sheets

coupler.ioFreemium

Coupler.io for Google Sheets

Scheduled imports from business apps into Sheets, without CSV exports.

ToolsGoogle Sheetsgoogle-sheets

youtube.comFree

Create an interactive Google Sheets dashboard

Teacher's Tech: slicers and linked charts driven from one raw-data tab.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

Excel Online vs Google Sheets

Spreadsheet Point: feature-by-feature comparison of the two browser spreadsheets.

VideosGoogle Sheetsgoogle-sheets

support.google.comPaid

Gemini in Google Sheets

Google's official guide to the Ask Gemini panel inside Sheets.

SitesGoogle Sheetsgoogle-sheets

developers.google.comFree

Google Apps Script documentation

Official docs for Apps Script, the JavaScript automation layer behind Google Sheets.

SitesGoogle Sheetsgoogle-sheets

youtube.comFree

Google Apps Script tutorial for beginners, part 1

Priyo Tutorials: the script editor and its syntax, for someone who has only written VBA.

VideosGoogle Sheetsgoogle-sheets

support.google.comFree

Google Docs Editors Help Community

Google's own user forum, with a Sheets category staffed partly by volunteer Product Experts.

CommunitiesGoogle Sheetsgoogle-sheets

youtube.comFree

Google Sheets Basics A-Z: Introduction to Spreadsheets

Learn Google Sheets & Excel Spreadsheets: the interface piece by piece, from zero.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

Google Sheets data cleaning: FILTER, TRIM, UNIQUE

DSMStrength: three functions as a lightweight cleaning toolkit, no add-ons needed.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

Google Sheets Full Course

freeCodeCamp.org: a structured beginner course on entering, organising, and visualising data.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

Google Sheets Full Course Tutorial

Sheetomatic: four hours from the Sheets interface through formulas, formatting, and charts.

VideosGoogle Sheetsgoogle-sheets

support.google.comFree

Google Sheets function list

Google's official reference of every built-in Sheets function, grouped by category.

SitesGoogle Sheetsgoogle-sheets

support.google.comFree

Google Sheets template gallery guide

Official instructions for finding and using the built-in Sheets template gallery.

SitesGoogle Sheetsgoogle-sheets

youtube.comFree

Google Sheets: getting started and collaboration

Technology Central: sharing permissions and real-time co-editing, the part Excel does differently.

VideosGoogle Sheetsgoogle-sheets

webapps.stackexchange.comFree

google-sheets tag on Web Applications Stack Exchange

Thousands of narrowly scoped Sheets problems with ranked, accepted answers.

CommunitiesGoogle Sheetsgoogle-sheets

youtube.comFree

How to convert Excel to Google Sheets

EasyClick Academy: uploading an xlsx file and converting it to native Sheets format.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

How to create a dashboard in Google Sheets in 5 minutes

Coupler.io Academy: a plain data tab to a working dashboard with native chart tools.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

How to use VLOOKUP in Google Sheets

Teacher's Tech: VLOOKUP syntax worked through, the lookup an Excel user reaches for first.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

IMPORTRANGE, QUERY and ARRAYFORMULA explained

Paul O'Malley: the three functions together, pulling live data between spreadsheets.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

Master pivot tables in Google Sheets

Coupler.io Academy: summarising a raw dataset before any of it becomes a chart.

VideosGoogle Sheetsgoogle-sheets

youtube.comFree

QUERY complete guide: Google Sheets' most complex function

David Benaim: clause-by-clause QUERY, for SQL-style filtering inside a sheet.

VideosGoogle Sheetsgoogle-sheets

r/GoogleSheets

Large subreddit where people debug formulas, scripts, and spreadsheet structure.

CommunitiesGoogle Sheetsgoogle-sheets

sheetgo.comFreemium

Sheetgo

Links separate spreadsheet files so one master sheet updates itself.

ToolsGoogle Sheetsgoogle-sheets

support.google.comFree

Use both Excel and Sheets: best practices

Google's own guidance on when to convert an Excel file and when to leave it alone.

SitesGoogle Sheetsgoogle-sheets

zapier.comFreemium

Zapier Google Sheets integrations

Treats a new Sheets row as an event that can trigger work in other apps.

ToolsGoogle Sheetsgoogle-sheets

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools