What is spreadsheet id in Google Sheets?

When to use it

Use IDs and URL parameters when scripting, embedding, or linking directly to a tab or form field.

When to skip it

Skip raw IDs for casual sharing when a normal share link or named range is enough.

Better Sheets resources

Related Tutorials

Watch how spreadsheet ID works

Watch more tutorials
Activate A Certain Sheet When Opening a Spreadsheet

Activate A Certain Sheet When Opening a Spreadsheet

Create a short function that runs every time a spreadsheet file is open....
Advanced Coding in Google Sheets for Programmers

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu Create Native-like Functions Get URL and Sheet ID's vi...
5 Ways To Use Google Sheets for Advanced Project Management

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Man...
The First Thing I Do When Starting a Google Sheet

The First Thing I Do When Starting a Google Sheet

Are you tired of the default look of your Google Sheets? In this video, ...
Embed a Number in a Website from a Google Sheet

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...
How do I reference a different spreadsheet in Apps Script?

How do I reference a different spreadsheet in Apps Script?

I'll show you how to get text from one spreadsheet file to another with ...

Related blog posts

Guides that explain spreadsheet ID in more depth.

Browse the blog

Related terms