A-PDF :: Affordable PDF Tools

How do you extract data from two or more sheets for labeling?

Return KB main page

Question

I am trying to upload my excel file. But it is only uploading one of my tabs, not the enitre excel worksheet. How to import 2 or more sheets at the same time?

Solution

When you use A-PDF Label (PDF mail merge) (free download here), after clicking "Open excel file", you can input below sentenses in SQL box to import two or more tables from one Excel at the same time:

select * from [Sheet1$]
union select * from [Sheet2$]
union select * from [Sheet3$]

("Sheet1/2/3" stands for the different names of sheets, make sure all sheets contain the same number columns.)

Click "Run SQL" and then follow the below steps:

  1. Select a Rule for Labeling: Click the "+" icon and custom a rule step by step(a label rule defines labels content based on a PDF template) and then save;
  2. Click the "Label and Create as PDF" icon to form PDFs with labels.

This web tutorial will give you an overview of the procedure and you will handle this tool with ease!

tutorial

More Related Q&A

Related products

  • A-PDF Excel to PDF - Batch convert MS Excel file into professional-quality PDF documents
  • A-PDF Label - Batch add formatted dynamic Label fields (mailing label) such as Name, Address, City to custom PDF templates (such as in form letters, on envelopes, business card, name badge and so on) for printing, The Label fields lists information come from a spreadsheet in MS Excel file
  • A-PDF To Excel - extract and convert almost any PDF data (such as Invoice, Bank statement, Price list, inventory list. Etc…) to highly-editable Microsoft Excel document or CSV file format in several minutes.

We always like improving our products based on your suggestions. Please send your feedback (or ask questions) to us in the contact page.

Return KB main page