Setup Guide
(for Barcode To Sheets 2.0)
Embedded Files
Step 1. Create a Google Spreadsheet and share it with your Google account (with edit permission) so that your Google account can edit it
Step 1. Create a Google Spreadsheet and share it with your Google account (with edit permission) so that your Google account can edit it
Do either A or B:
A: If share with specific people and groups, select **Editor** for them. (recommended)
B: If share with anyone via link, make sure it shows **can edit**
For details, see: https://support.google.com/docs/answer/2494822
Step 2. Enter the sheet details in the app
Step 2. Enter the sheet details in the app
Open the Google sheet in a web browser, then refer to the below image for Spreadsheet ID and Sheet Name.
In this image, Spreadsheet ID would be 1RwPt-bfNzl0qyai11ItkUkpm13Ldlaa-psND1NmSP0s and Sheet Name would be Sheet1.
Hint: To avoid typing these on your phone, you may convert these into QR Codes using online QR code generators. Then use the app to capture the values directly.
Optional Settings
Optional Settings
Start column: Start column of the table to insert data. If a table is found overlapping the start column, the data will be merged to that table.
Automatically create sheet if not exists
If checked, the app will create the sheet when you next scan a barcode if the specified sheet is not found in the Google Spreadsheet.
Sheet name format
Normal: Sheet name on Google Spreadsheet will be exactly as what you specified in the app
Date: Sheet name specified in the app (e.g. yyyy-MM-dd) will be converted to today's date/time as the sheet name in Google Spreadsheet (e.g. 2025-04-26). The date/time conversion logic uses java "Simple Date Format". For details, refer to "Date and Time Patterns" and "Examples" section in: https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
Step 3. Starting scanning barcodes and QR codes
Step 3. Starting scanning barcodes and QR codes
Last updated: 26th April 2025
Page updated
Google Sites
Report abuse