Bjorn's Label Studio
Print labels and badges from within Google Sheets
- a Google Sheets extension -
Intro
Quickly design and print labels and badges from data in spreadsheets and other sources.
Fully integrated with Google Drive™ - load data from Google Sheets™, save and open design documents from your Gdrive, upload generated QR codes to Google Photos™.
NEWS! - quick print labels for temp data
Sep 3 2023. App has a new feature to print labels for a temp row of data. Assume you have created a great label design and you just want to re-use it from time to time to print a sheet of labels for some new data, then this is a feature for you. Open your great design and use the "Print a temp row..." option in the main toolbar. This option will open a UX in which you can quickly enter data for all data columns used in the design and then print using the current design.
NEWS! - 'print selected row' feature'
Sep 2023 - App has a new nifty feature (requested by customers) that allows you to generate multiple copies of the same label for a selected row of data.
You find the feature in the Data dropdown and in the on-hover menu to the left of a row in the Data tab.
NEWS! - templates
June 2023 - you can now use template files to save or load commonly used designs.
A template specifies the selected sheet definition and the label design but no data.
You an apply a template when you create a new project or later.
You can save any project as a template for future use.
Applying a template on a project replaces the selected sheet definition as well as the current label design.
Note: you will have to re-assign columns to items in the design if the columns used in the template don't match the columns used in the current design.
You assign columns using the 'Assign column...' in the right mouse button menu, aka. the context menu.
This short video shows how to apply a template as well as how to create a new one.
Not that due to (lame) restrictions by Google in Google add-ons, templates are not supported in the Google Sheets add-on version.
Templates are stored on your local hard drive with the .labeltemplate extension.
NEWS! - formatting columns
May 2019 - you can now use formatting columns to custom format some barcode labels.
A column named 'Color' sets the color for each field in a label.
A column named '[datacolumn] Color' sets the color for the field [datacolumn], e.g. if you have a data column 'FirstName', use a column with header 'FirstName Color' to set the color.
You can use CSS color names or CSS #RRRGGBB color values - read more here: w3school.com
In addition to Color you can use FontSize columns to set label specific font sizes.
More
Check out this short YouTube video.
Check out screenshots and install from the Google web store.
Other platforms
Check out these other versions for other platforms.
See also
You might also be interested in these other apps or add-ons.
Bjorn's Barcode Studio - a Google Sheets extension
Print QR and barcodes from within Google Sheets
Pricing
This add-on is in the TIER-1, a TIER-1 subscription costs $8.95 per month.
You can try the add-on for 7 days for free.
Note that a TIER-1 subscription covers all TIER-1 products.
There is a 5-user subscription with a great discount, $29.95 per month.
Use Bjorn's Account Manager to buy/manage your subscription.
Use your PayPal account to cancel your subscription.
Support
Note - if you have installed the add-on and the add-on submenu only contains the 'Help' option - PLEASE RELOAD THE DOCUMENT - and the other options will appear.
Please report bugs here or reach out 2 me with questions @ support@backlund.org.
Got an idea for a new feature/app/add-on? Use the suggestions portal.
Follow me at Instagram @bjornsplayground and check out more videos at my YouTube channel.
You can view our privacy policy here.
