Ask Your Question

How do I create labels from a spreadsheet? [closed]

asked 2014-04-18 10:19:18 +0200 gravatar image

updated 2014-06-16 00:18:05 +0200

bencomp gravatar image

I want to print labels from a mailing list i have on a spreadsheet.

I went into File - New - Label and created a label the size i want. But i dont know how to import data into it. In the 'database' section it only gives me the option to select Bibliography...

anybody can help me on this ? that would be awesome...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-25 18:15:08.441597

1 Answer

Sort by » oldest newest most voted

answered 2014-04-18 14:36:30 +0200

Regina gravatar image

updated 2014-04-18 14:38:18 +0200

The spreadsheet document needs to be registered as database. Therefore you have to generate a .odb database administration file. Goto File > New > Database. Check "Connect to an existing database" and select "Spreadsheet" from the drop-down list. Next. Select your spreadsheet file. Next. Check "Yes, register". Finish. Save the .odb file, for example beside the spreadsheet file.

Make sure, your spreadsheet has columns labels. They will become the database field names.

edit flag offensive delete link more


Great directions. I did it. But what do I do after I get the spreadsheet made into a database? I still need labels.

Theresa gravatar imageTheresa ( 2015-04-30 03:10:52 +0200 )edit

The wizard from File > New > Labels now shows your registered "spreadsheet-database". Select it, then select the to be used "table", which actually is a sheet. On the left side you generate the label text. You can write own texts and you can select a database field and insert it into the text with the ← button. Do you read already the help topic "Labels and Business Cards"?

Regina gravatar imageRegina ( 2015-05-01 12:51:58 +0200 )edit

Question Tools

1 follower


Asked: 2014-04-18 10:19:18 +0200

Seen: 18,725 times

Last updated: Jun 16 '14