#LIBREOFFICE SPREADSHEET HOW TO#
#LIBREOFFICE SPREADSHEET SOFTWARE#

It just changes the names of the fields later.) HereвЂ™s what the screen should look like: On this screen, you can click on вЂњField Assignment,вЂќ which will let you match the fields in your imported data to the fields that are common for addresses. This is Step 4 of 5 (note, Step 3 was skipped because I only had one field in my spreadsheet). If you want, you can click on вЂњTest Connection.вЂќ Assuming everything worked, you should get this nice but relatively uninformative window:Д¬lick on вЂњFinishвЂќ and youвЂ™ll go back to the wizard: That will take you back to the previous screen. Click on вЂњBrowseвЂќ and go find the spreadsheet you are going to use, like this:Д¬lick on вЂњOpenвЂќ once youвЂ™ve selected it. Here, you need to choose your data source. Once youвЂ™ve selected the source for your data (again, IвЂ™m using a spreadsheet), select вЂњNextвЂќ and youвЂ™ll get this screen: But you can see from this screenshot that you choose from a variety of database sources: IвЂ™m using a Spreadsheet, so IвЂ™ll leave that selected. You have a lot of options you can choose from on this screen. ItвЂ™s actually really smart, when you think about what the programmers did here, but it isnвЂ™t straightforward at all that you have to do all of this first. On this screen, click on вЂњSettingsвЂќ and youвЂ™ll get a completely separate window: (Did I mention that this is a bit confusing and complicated. Unless you have your address data stored in Firefox or Thunderbird, select вЂњOther external data source.вЂќ Then click on вЂњNextвЂќ and youвЂ™ll get this next screen: ItвЂ™s basically saying, вЂњHey, letвЂ™s use existing data instead of having to enter new data.вЂќ Groovy. When you click on that, youвЂ™ll get this window: To create your database, click on File -> Wizards -> Address Data Source: Just think of this as getting everything set up. But it seems counterintuitive that you have to do this before you can start the mail merge. LibreOffice will walk you right through it with a wizard. Basically, you need to turn this list of addresses into a database that LibreOffice has registered so it can then pull those fields when it generates the labels. Okay, now we get to the weird part that is going to seem unrelated to merging these addresses into labels. Of course, if youвЂ™re outside the US, your columns will be different. ItвЂ™s always a good idea to separate out your fields like I have done: first name, last name, street, city, state, zip. Make sure that you have column names at the top as those can become the field names in the database. IвЂ™m assuming you have a spreadsheet with addresses, like this one: Part 1: Register Your Database with the Address Book Data Source WizardД«efore creating any labels, the first thing you need to do is create your database. And, in fact, the first step will seem unrelated to merging labels, but it is necessary. LibreOffice is fully capable of doing this, but itвЂ™s not what I would call вЂњeasyвЂќ or straightforward.

#LIBREOFFICE SPREADSHEET SOFTWARE#

The idea behind a label merge, just like a form letter merge, is that you have a bunch of address information in a spreadsheet or database and, rather than having to enter all of that separately into a document to print labels, youвЂ™ll just have the software create the labels from the data you already have.

#LIBREOFFICE SPREADSHEET HOW TO#

So, here is my tutorial on how to merge labels in LibreOffice. Whenever that happens, I know that means I need to create a tutorial on here so I can remind myself how to do it if I ever need to do it again. In the process, I realized that I totally forgot how to do it after the first time.

The first time, I actually did a form letter and a label merge the second time I just had to do an address label merge.

IвЂ™ve been using LibreOffice for over a decade and have only had to do an address label merge twice in that time вЂ“ both of which have been in the last month.

Libreoffice spreadsheet