The ID Taken from the URL
Key points
- Paste the URL
- See the formula
- Check it
IMPORTRANGE Builder takes the ID that comes after /d/ in the URL.
Steps
- Paste the URL
- See the formula
- Check it
You can also paste just the ID.
Use "Build an IMPORTRANGE Formula" (free)
Tools that go well with this
- Build a SUMIF or COUNTIF Formula: Build SUMIF and COUNTIF formulas.
- Check an Excel Sheet Name: Check whether a sheet name is allowed.