How to print bottle cap labels.

Discussion in 'Beer Brewing "How-To" Guides' started by Arek, Dec 30, 2018.

Help Support The Homebrew Forum UK by donating:

  1. Dec 30, 2018 #1

    Arek

    Arek

    Arek

    Active Member

    Joined:
    Nov 16, 2018
    Messages:
    20
    Likes Received:
    9
    Location:
    Chorley
    Last edited by a moderator: Dec 30, 2018
  2. Dec 30, 2018 #2

    Chippy_Tea

    Chippy_Tea

    Chippy_Tea

    Administrator. Administrator

    Joined:
    Mar 17, 2013
    Messages:
    26,193
    Likes Received:
    5,685
    Location:
    South Cumbria.
    I copied this post from a thread posted earlier today and added the pictures as i am sure members will be interested.
     
    crowcrow and Aaron Rennie like this.
  3. Dec 30, 2018 #3

    Arek

    Arek

    Arek

    Active Member

    Joined:
    Nov 16, 2018
    Messages:
    20
    Likes Received:
    9
    Location:
    Chorley
    Thanks @Chippy_Tea. I was thinking about writing short guide but due to christmas/work/uni got no time at all.
     
  4. Dec 30, 2018 #4

    Chippy_Tea

    Chippy_Tea

    Chippy_Tea

    Administrator. Administrator

    Joined:
    Mar 17, 2013
    Messages:
    26,193
    Likes Received:
    5,685
    Location:
    South Cumbria.
  5. Dec 30, 2018 #5

    jjsh

    jjsh

    jjsh

    Senior Member

    Joined:
    Jan 4, 2011
    Messages:
    1,680
    Likes Received:
    706
    Location:
    East Lindsey, Lincolnshire
    I don't seem to be able to download the spreadsheet in either of the 4 formats ~ is it just me?
     
  6. Dec 30, 2018 #6

    Arek

    Arek

    Arek

    Active Member

    Joined:
    Nov 16, 2018
    Messages:
    20
    Likes Received:
    9
    Location:
    Chorley
    Works fine for me. I think you have to be registered user to download. First 2 files are for Excel and OpenOffice. The other 2 are the same but you can use them if you brew smaller batches, so you can save on paper and print labels for 2 beers on the same sheet.
     
  7. Dec 30, 2018 #7

    aamcle

    aamcle

    aamcle

    Landlord.

    Joined:
    Dec 27, 2012
    Messages:
    996
    Likes Received:
    156
    Location:
    Newton-le-Willows
    Of the easy way.

    Glables prints round labels 19mm diameter on A4 sheets, it's easy to use does text and pictures and it's free.

    But Linux not Windoze.
     
  8. Jan 2, 2019 #8

    jjsh

    jjsh

    jjsh

    Senior Member

    Joined:
    Jan 4, 2011
    Messages:
    1,680
    Likes Received:
    706
    Location:
    East Lindsey, Lincolnshire
    Top man! Glabels installed on my Ubuntu laptop and I am happily creating 25mm round labels that match my 25mm paper punch. Cheers for the tip.
     
    Chippy_Tea likes this.
  9. Jan 2, 2019 #9

    matt76

    matt76

    matt76

    Landlord. Supporting Member

    Joined:
    Oct 17, 2018
    Messages:
    793
    Likes Received:
    314
    Nice one @Arek , thanks for sharing! athumb..

    I saw a photo of bottle cap labels on this forum recently and I really like the idea.

    All - it's pretty self explanatory even in Polish but you can copy and paste the text into https://translate.google.com if you're curious (at the end he says he made a version 2 to print two different labels per A4 sheet)

    I can't download it either but I'm pretty certain I can knock up a spreadsheet to do this - to eBay! :laugh8:
     
  10. Jan 7, 2019 #10

    matt76

    matt76

    matt76

    Landlord. Supporting Member

    Joined:
    Oct 17, 2018
    Messages:
    793
    Likes Received:
    314
    20190107_210339.jpg 20190107_210713.jpg 20190107_212541.jpg

    So after a little fiddling in Excel, a few test pages, a 25mm hole punch and some label paper I got this sorted - pretty pleased with the result athumb..

    Can post more detailed instructions if anyone is interested.
     
    PhilBrew and Chippy_Tea like this.
  11. Jan 7, 2019 #11

    jjsh

    jjsh

    jjsh

    Senior Member

    Joined:
    Jan 4, 2011
    Messages:
    1,680
    Likes Received:
    706
    Location:
    East Lindsey, Lincolnshire
    Labelled up some bottles tonight using this method tonight, and all went well. I used the 24mm round label template on gLabels on Ubuntu rather than the spreadsheet.

    [​IMG]
     
  12. Jan 7, 2019 #12

    aamcle

    aamcle

    aamcle

    Landlord.

    Joined:
    Dec 27, 2012
    Messages:
    996
    Likes Received:
    156
    Location:
    Newton-le-Willows
    I buy A4 sheets of round labels (19 mm dia) and print them with a program called gLables. It does text an pictures and it's very easy to use but it's a Linux program.

    You can do it with Inkscape but it involves layers and difficult cut and paste.


    Atb. Aamcle
     
  13. Jul 17, 2019 #13

    Ray1314

    Ray1314

    Ray1314

    Active Member Supporting Member

    Joined:
    Oct 10, 2015
    Messages:
    55
    Likes Received:
    22
    Location:
    Elgin, Moray
    Cheers for this, going to be so much better than messing around with labels on the bottles.
     
    Last edited: Jul 18, 2019
  14. Jul 19, 2019 #14

    matt76

    matt76

    matt76

    Landlord. Supporting Member

    Joined:
    Oct 17, 2018
    Messages:
    793
    Likes Received:
    314
    Since you were asking @PhilBrew .....

    The attached zip file contains a version of the Excel sheet I used to print my bottle cap labels (it wouldn't let me upload the original *.xlsx file so I zipped it)

    I generally brew smaller ~12L-ish batches so this version prints labels for two different beers: you just need to change the values in cells B3-D6 and the first lot will update, likewise in B27-D30 for the second lot. Or just make everything reference B3-D6 if you need more of the same label.

    Feel free to mess around with the colours of the text and cell-fill if you like (the colours of the Belgian flag happen to work well if you're making a Witbier for example!).

    When you come to print it, note that the page scaling is set to 50% to fit it on one page (you shouldn't need to change this I think). I generally print a test page on plain paper to check it's OK before printing it on the label paper.

    More recently I've been experimenting with putting a semi-transparent image over the text to jazz it up a bit - can post some pics later)

    screen01.png screen02.png
     

    Attached Files:

    Ray1314 and PhilBrew like this.
  15. Jul 19, 2019 #15

    matt76

    matt76

    matt76

    Landlord. Supporting Member

    Joined:
    Oct 17, 2018
    Messages:
    793
    Likes Received:
    314
    This is what I was talking about - I print the background images first, then put the paper back in the printer to print the text athumb..

    20190719_165720.jpg
     
    Chippy_Tea and Ray1314 like this.
  16. Jul 19, 2019 #16

    An Ankoù

    An Ankoù

    An Ankoù

    Landlord.

    Joined:
    Feb 2, 2019
    Messages:
    1,793
    Likes Received:
    811
    Location:
    Brittany, France
    This looks exactly what I was looking for and as Ubuntu is my OS of choice, I'm optimistic.
     
  17. Jul 19, 2019 #17

    matt76

    matt76

    matt76

    Landlord. Supporting Member

    Joined:
    Oct 17, 2018
    Messages:
    793
    Likes Received:
    314
    I'm a friend of Linux - but printers are printers so bear in mind that printing twice may return better results then printing everything in one go, regardless of OS - my previous attempt was done in one go, it's ok but could be better - meh, as long as the beer is good, that's the main thing:

    20190719_214947.jpg
     
  18. Jul 20, 2019 #18

    Kinneuchar

    Kinneuchar

    Kinneuchar

    New Member Supporting Member

    Joined:
    Mar 1, 2018
    Messages:
    11
    Likes Received:
    12
    Location:
    Leven, Fife
     
  19. Jul 20, 2019 #19

    Kinneuchar

    Kinneuchar

    Kinneuchar

    New Member Supporting Member

    Joined:
    Mar 1, 2018
    Messages:
    11
    Likes Received:
    12
    Location:
    Leven, Fife
    Just what I was looking for, glad you shared
    Cheers!
    Tom
     
  20. Aug 30, 2019 #20

    gingerneil

    gingerneil

    gingerneil

    Active Member

    Joined:
    Aug 9, 2019
    Messages:
    68
    Likes Received:
    11
    I've used this template for my latest batch - works great for crown tops.
    Are swing tops the same dimension? 2.5cm? Or are they generally smaller?
     

Share This Page