Bjorn

Bjorn's Label Studio

Design and print labels and badges

- a web app -

Launch app.

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™.

Intro

Quickly design and print labels and badges from data in spreadsheets and other sources.

 

NEWS: Dec 2024 - your personal cloud folder

You can now store your Bjorn's Label Studio documents in a personal cloud storage folder, a.k.a your Bjorn's Cloud folder.

The File drop-down menu has an option to save documents to your cloud folder, and of course, you can open documents from the cloud with another option in the same menu.

NEWS! - new bindable checkbox elements

Nov 2024 - app now supports bindable checkbox elements. The state of a checkbox can be can be bound to a data column in your merge data source.

  • Values turning on a checkbox: true; yes; on; any number other than 0.
  • Values turning off a checkbox: false; no; off; 0.
  • Values setting the checkbox unset or intermediate state: null, undefined, notset, not-set.

See this Sheet for a sample data sheet using a column with checkbox states.

Checkboxes have quite a few formatting properties, see video for a demo of some of them. Worth noting is that you can use different fill colors for the three different states - perhaps useful as indicators on a badge?

A new checkbox palette has been added to the sidebars.

Make sure to checkout the video below.

(demo video)

NEWS! - individual images for each label

Oct 2024 (4) - merge data and design and create individual images for each label/badge.

Save images to a local file system folder or upload to Google Drive or Google Photos.

(demo video)

NEWS! - two-sided printing

Oct 2024 (3) - app has now support for two-sided printing.

(demo video)

NEWS! - multi-column placeholder UI

Oct 2024 (2) - app has a new UI to make it more obvious how to create placeholders that fetch data from more than one data column - the "insert multi-column placeholder" dialog.

(short demo here)

NEWS! - auto-adjust font size for placeholders

Oct 2024 (1) - auto-adjust font sizes: when turned on the app will decrease the font size of a placeholder until the text fits on one line in the generated labels.

(short demo here)

NEWS! - new handy?? context menus

Oct 14 2023. New context menus available in the rotate and resize handles of selected shapes.

(short YT video)

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.

(check out short YT video)

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.

Templates are stored on your local hard drive with the .labeltemplate extension.

(check out short YT video)

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.

See a sample Google Sheet using formatting columns here

More

Check out this short YouTube video.

Check out screenshots and install from the Microsoft web store.

Launch the app.

Personal cloud folder

This app supports cloud storage included with your subscription. The File drop-down menu has an option to save documents to your personal cloud storage folder, a.k.a your Bjorn's Cloud folder, and of course, you can open a document from the cloud with another option in the same menu.

The cloud storage folder is enabled when you are signed in and have a valid subscription.

File system integration

The app is (when installed) integrated with the host file system, i.e. you can use the 'Open with' feature to launch the app for a selected file.

Extensions that can be opened are:

  • .csv
  • .labels
  • .labeltemplate
  • .tsv
  • .txt

Note that you have to install the app to enable file system integration.

Other platforms

Check out these other versions for other platforms.

Bjorn's Label Studio - a Google Sheets extension

Bjorn's Label Studio - an Excel add-in

See also

You might also be interested in these other apps or add-ons.

Bjorn's Barcode Studio - a web app

Design and print QR and barcodes from spreadsheet data

Bjorn's Bulk Mail'n'more - a web app

Nextgen bulk mail and email blasts, and more. Mail merge evolved!

Bjorn's Text Flow - a web app

Advanced text layout and editing

Pricing

This app is in the TIER-1, a TIER-1 subscription costs $8.95 per month.

You can try the app 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

Please report bugs here or reach out 2 me with questions @ support@backlund.org.

Follow me at Instagram @bjornsplayground and check out more videos at my YouTube channel.

You can view our privacy policy here.