How to create a QR code for a Google Sheet
- 1
Share the spreadsheet
Click Share, set General access to “Anyone with the link”, choose Viewer, and copy the link.
- 2
Paste and design
Paste the link, then add your colours, logo and a frame such as “Today’s prices”.
- 3
Test it on a phone
Open it on a phone that isn’t signed in to your account, and check it’s readable on a small screen.
How a Google Sheets QR code works
The code holds your spreadsheet’s sharing link. When someone scans it, the sheet opens in their phone’s browser, or in the Google Sheets app if they have it. It’s the live spreadsheet: when you update a price, a time or a stock level, everyone who scans sees the new numbers.
Make it readable on a phone
Spreadsheets are wide, and phones are narrow. A few changes make a big difference:
- Freeze the first row and column (View → Freeze), so headings stay visible while people scroll.
- Keep it to a few columns. Hide the ones visitors don’t need, or make a separate tab for them.
- Use a larger font and wrap text in long cells.
- Sort the most useful rows to the top, such as today’s schedule or the most popular items.
A cleaner view: publish to the web
A shared sheet opens in the spreadsheet editor. For a simpler, read-only page, use File → Share → Publish to web, pick the tab, and choose Web page. The published link updates automatically when you edit the sheet, and it hides your formulas and other tabs.
What people share with Google Sheets codes
- Price lists for wholesalers, markets and repair shops
- Timetables: classes, shuttles, shifts and match fixtures
- Stock and availability lists, such as plants, cars or rooms
- Event line-ups and seating plans
- Results tables for competitions, leagues and school sports
- Inventory sheets on storage rooms and equipment
- Sign-up lists, when you want people to add their name directly (use Editor, and keep a backup)
Collect data instead?
If you want people to add information, such as attendance, orders or feedback, a Google Form QR code is safer than an editable sheet: people can’t see or change other people’s answers, and responses still land in a Google Sheet for you.
Privacy
Anyone with the link can open a shared sheet, including people who got the link from someone else. Don’t share personal data like phone numbers or addresses in a public sheet. Use a separate tab or a separate file for private columns: hiding a column isn’t enough, because viewers can still copy the sheet.
Static and dynamic codes
This is a static code: free and permanent. Because the sheet itself is live, you can keep its content up to date. A dynamic QR code adds scan counts, and lets you point the printed code at a new spreadsheet next season.
Print tips
Google Sheets links are long, so give the code at least 2.5 cm, and more on signs people scan from a distance. Keep it dark on a light background.