How to Make a Google Sheet Public
Before anyone can download your Google Sheet or share it with someone without a Google account, you need to make it publicly accessible. This guide shows you exactly how to do it in under 30 seconds — on desktop, iPhone, and Android.
⚡ Quick Answer
Open your Google Sheet → click Share (top right) → under "General access" change the dropdown from Restricted to Anyone with the link → set role to Viewer → click Copy link. Done. Now anyone with that link can view and download the sheet as Excel, CSV, PDF, or ODS.
Step-by-step: Make a Google Sheet public (Desktop)
Open your Google Sheet
Go to sheets.google.com and open the spreadsheet you want to share. You must be signed in to the Google account that owns the sheet.
Click the Share button
Find the blue Share button in the top right corner of the screen and click it. A sharing dialog will appear.
Change access from "Restricted" to "Anyone with the link"
Scroll down to the General access section. Click the dropdown that says Restricted and change it to Anyone with the link.
Set the role to "Viewer"
Next to "Anyone with the link", make sure the role dropdown is set to Viewer. This lets people view and download the sheet but not edit it. Only change to Editor if you specifically want people to edit.
Click "Done" and copy the link
Click Done to save the settings. Then click Copy link (or copy the URL from your browser's address bar) and share it — or paste it into SheetsBox to download it in any format immediately.
How to make a Google Sheet public on iPhone / Android
Open the sheet and tap the ⋮ menu
Open the Google Sheets app, open your spreadsheet, and tap the three-dot menu (⋮) in the top right corner.
Tap "Share & export" → "Share"
From the menu, tap Share & export, then tap Share. The sharing settings screen will open.
Tap "Change" next to link access
Tap Change next to the link access setting, select Anyone with the link, set the role to Viewer, and tap Done.
Understanding Google Sheets permission levels
| Access level | Who can see it | Best for |
|---|---|---|
| Restricted | Only people you've specifically invited | Private data, confidential sheets |
| Anyone with the link — Viewer | Anyone who has the URL | Sharing data, enabling SheetsBox downloads ✅ |
| Anyone with the link — Commenter | Anyone who has the URL | Collecting feedback without edit access |
| Anyone with the link — Editor | Anyone who has the URL | Collaborative editing (use with caution) |
Frequently Asked Questions
Does making a sheet public expose it to Google search?
Not automatically. "Anyone with the link" means people need the actual URL to access it — Google won't index it in search results unless you explicitly publish it to the web (File → Share → Publish to web), which is a separate action.
Can I make the sheet public without a Google account?
No — you need to be signed into the Google account that owns the sheet to change its sharing settings. However, once it's public, anyone can download it without a Google account using SheetsBox.
How do I make the sheet private again?
Go back to Share → General access → change back to Restricted → Done. The link will immediately stop working for anyone who doesn't have explicit access.
Will people be able to edit my sheet if I make it public?
Only if you set the role to "Editor". If you set it to "Viewer" (recommended), people can view and download the data but cannot make any changes to your sheet.
I set it to public but SheetsBox still shows an error — why?
The most common reason is that the sheet is still set to "Restricted". Double-check by opening the Share dialog and confirming "Anyone with the link" is selected under General access. If it's correct and still failing, try copying the URL fresh from the browser address bar and pasting it into SheetsBox again.
Sheet is public? Now download it.
Paste the link into SheetsBox and download as Excel, CSV, PDF, or ODS — free, instant, no login.
Download with SheetsBox →