How to Create a QR Code for Google Sheets & Excel

Why Use a QR Code for Spreadsheets?

Spreadsheets are one of the most common ways to collect and share data — sign-up sheets at events, inventory trackers, project timelines, budget reports, and collaborative documents. But sharing a spreadsheet usually means sending a link via email or messaging app. A QR code eliminates that friction entirely. Print it on a poster at a conference, include it in a printed handbook, or display it on a screen, and people can access the spreadsheet instantly.

This is particularly powerful for sign-up sheets and data collection. At trade shows, volunteer events, school activities, and community gatherings, a printed QR code that opens a Google Sheets form or editable spreadsheet lets people add their information on their own phone. No passing around a clipboard, no deciphering handwriting, no manual data entry afterward.

Setting Up Your Google Sheets Link

Open your Google Sheets document and click the Share button in the top-right corner. Set the access level to Anyone with the link can view (or can edit, if you want people to add data). Click Copy Link. The URL will look like https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit. This is the link you will encode in your QR code.

If you want to share a specific sheet or range within the spreadsheet, you can append parameters to the URL. For example, adding #gid=SHEET_ID at the end jumps to a specific tab. Adding /export?format=pdf converts it to a downloadable PDF. For a view-only version that hides the toolbar, use /preview instead of /edit at the end of the URL.

For Excel files, upload the file to Google Drive or OneDrive first, then share the link. Google Drive will give you a URL like https://drive.google.com/file/d/FILE_ID/view. OneDrive uses a similar sharing model. The QR code will open the file in the browser's built-in viewer without requiring the person to have Excel installed.

Creating the QR Code

Go to the URL QR code generator on this site. Paste your Google Sheets sharing link into the URL field. The QR code generates in real time. You can customize the appearance — use Google's brand blue (#4285F4) or green (#34A853) as the dot color for instant recognition. Add your company or organization logo to the center for a branded, professional look.

Download the QR code as PNG for quick use in documents and slides, or as SVG for high-quality print materials like event banners and handouts. Always test the code by scanning it with your phone before distributing it. Confirm that it opens the correct spreadsheet and that the sharing permissions are set correctly.

Use Cases for Spreadsheet QR Codes

Event sign-up sheets are the number one use case. Print a QR code on a poster or table tent at your event. Attendees scan it, the spreadsheet opens on their phone, and they type in their name and email. This works for conferences, workshops, volunteer drives, church groups, school events, and community meetings. The data goes straight into your spreadsheet — no transcription needed.

Inventory and asset tracking is another strong use case. Warehouses and offices can print QR codes on shelves or equipment that link to a shared spreadsheet with stock levels, maintenance logs, or usage schedules. Staff scan the code, update the spreadsheet, and everyone sees the changes in real time.

Teachers and professors use spreadsheet QR codes for attendance tracking, grade sharing (view-only), and collaborative class projects. Print the QR code on the syllabus or project brief, and students can access the shared document without needing to find a link in their email. Project managers use the same approach for sprint boards, task trackers, and meeting agendas.

Security and Permissions

Be deliberate about sharing permissions. If you only need people to view the data, set the link to Viewer access. If you need them to add data (like a sign-up sheet), set it to Editor. Never share a spreadsheet with Editor access if it contains sensitive data that should not be modified by the public.

For sensitive documents, consider using a Google Form instead of a direct spreadsheet link. Google Forms collect data into a spreadsheet but do not expose the underlying sheet to respondents. You can create a QR code for the Google Form URL, and responses flow into your private spreadsheet automatically. This is the safest approach for collecting personal information.

If you need to revoke access after an event, you can change the sharing settings back to Restricted at any time. The QR code will still exist and be scannable, but the link will return an access denied page. This gives you control over the lifecycle of the shared data without needing to recall printed materials.

Tips for Print and Display

Always add a label next to your QR code explaining what it does. Scan to add your name to the sign-up sheet or Scan to view the project timeline sets expectations and increases scan rates. People are more likely to scan a code when they know what will happen.

For events, print the QR code at least 3 × 3 inches on table tents and posters. For handouts and flyers, 1.5 × 1.5 inches is sufficient. Make sure there is adequate contrast between the QR code and the background. Black on white is the safest choice. Test the code under the same lighting conditions where it will be displayed — printed QR codes can be harder to scan under dim event lighting.