How to create labels from a spreadsheet in LibreOffice Writer?

Who I am
Catherine Le Nevez

Author and references

Label making is not very common nowadays, people already use other ways to mark products or works. But that doesn't mean it's an effective way to identify mail or postcards. That's why today you will learn how create labels from a spreadsheet in LibreOffice Writer as easy as opening a Word document without using Microsoft Office.

How to create labels from a spreadsheet in LibreOffice Writer

Thanks to the free software, a wonderful was created office program of which many ignore for the simple fact that it is not a Microsoft product, but this close cousin is equal or better, having multiple features, among which the ability to create custom labels stands out.

      Create labels from a spreadsheet in LibreOffice Writer

      Straight to the point and what came to your mind, how to create labels from a spreadsheet, to start this process you must run Libre Office Base, for this you just have to search for the program and open it as any other.

      Once this is done, a new window called "Database Wizard" , an option called will appear here "Connect with an existing database" click on it, a new window will appear where you have to select "Spreadsheet".

      Once chosen, click on " NEXT ", another section will appear with the button " Shop by Department ", click there, a search box will appear, search for your spreadsheet and click on the option " Open " to continue and then " The option " NEXT " will appear again, select it.

      Here one last section will appear in which different options will appear, the most important are: "Yes, Register Database" which is used for the same thing as its name says (registration in Libre Office), and "Open database for editing" , which is just for that, to edit the sheet.

      We click on the first and then on the button " end " to proceed to saving the spreadsheet with the name we want, with this you are closer to creating labels from a spreadsheet in LibreOffice Writer, since you will have successfully saved the sheet.

      Creating the mailing label

      When you complete this step perfectly, you will be able to compare two lists or columns in Calc LibreOffice with labels and even setup and print two pages per sheet in Calc LibreOffice.

      To start creating labels from a spreadsheet in LibreOffice Writer, you need access to the LibreOffice program. Just above in the toolbar select " Fillet ", several options will appear. Stop on the first call “ New ”, this will also display several options, select the one named “ labels ".

      This will take you to a section where you have to select the database that was registered in the previous step, select the drop down menu called "Database" and choose the one you created, then just below you will see another dropdown called " Table " here will choose the sheet where you have your data and you want to place the label.

      Also under that same drop down menu is another one called "Campo database" , here you will choose names or spreadsheet fields to insert into the label, you can choose many, then whenever you have one hit the black arrow which is looking left right there, to add.

      Then you have to change the format of the labels, this is done in this same section, in the option " Brand ", you give it there and then choose your brand. Just below that is another drop down menu called "Type" change this too as you like.

      Read here too!

      To continue editing, go to the format tab, which is next to where you are (labels). Here you can change the width and height of your label, among other things. Once you have this, click on " Save ”, the box with the sign and type you previously selected will appear, click on “ OK ”. And that's it, you can now create labels from a spreadsheet in LibreOffice Writer, now all you have to do is place them on the page.

      To insert

      To enter it, click on the tab next to it called " options ”. Here it gives the possibility to distribute them in: “Whole Page” o “Like a single label”. Choose one of these options and click "New document". Finally, the former will place the labels on a single page and the latter will place one per page.

      add a comment of How to create labels from a spreadsheet in LibreOffice Writer?
      Comment sent successfully! We will review it in the next few hours.