SPREADSHEET PRINTING GUIDE

Print Labels from CSV with a PDF or Image Template

To print labels from CSV, create and save a label template in PrintPiper, import your CSV, connect its columns to template variables, and generate a print-ready PDF. Each row fills one label. Choose individual custom-size pages or Avery 5160 / 8160 sheets with 30 labels per Letter page.

1. Prepare column names and one row per label

Save your file as UTF-8 CSV. Use unique, nonempty headers and the same number of values in every row. Put addresses, names, product names, or prices in separate columns so you can position them independently. This fictional address shows the header names and matching placeholders:

Place these matching column placeholders in one text field:

{{Name}}
{{Address}}
{{City}}, {{State}} {{PostalCode}}

The example row prints as:

Alex Example
12 Sample Lane
Exampleville, MA 01234

Keep postal codes such as 01234 as text. CSV imports preserve leading zeroes present in the file, but cannot restore digits already removed by a spreadsheet. Quote values containing commas or line breaks, and double any quotation marks inside a quoted value. For example:

Name,Address,PostalCode
Alex Example,"12 Sample Lane, Unit 2",01234

2. Create and save your label template

Open New template, name the design, and choose Paper size. Use Avery 5160 / 8160 for 30-up Letter sheets, or enter your label dimensions in millimeters or inches. Start blank or add a PDF or image as background artwork. A PDF supplies the design; the CSV supplies changing text.

Add text fields using variables such as {{Name}} and {{Address}}. Position the fields, set printer margins, and click Save template. Avery sheets require single-page artwork. For individual labels, multi-page artwork repeats all template pages for each CSV record.

3. Import CSV and connect columns to variables

In the right panel, select Import CSV / Excel and choose your CSV. Exact header and variable names connect automatically. Use Connect columns to map a differently named header, such as ZIP, to {{PostalCode}}. Connect every used variable before exporting. Preview several rows, especially the longest values and multiline addresses.

4. Generate a PDF and print at actual size

Select your row range and Print-ready PDF, then click Generate files. When generation finishes, click Download beside each completed file. Larger jobs can produce several parts; download all parts before leaving the page. PNG and TIFF output are also available as ZIP parts.

Print at Actual size / 100% with paper matching the exported page. For Avery sheets, use Letter and disable Fit or Shrink. Test on plain paper before loading label stock. Follow the Avery alignment guide for a shifted grid or a partly used sheet.

Questions about CSV label printing

Does this convert the CSV table into a PDF table?

No. Values merge into positioned fields on a label or document design. The output is personalized labels or pages, rather than a printed spreadsheet table.

Can I reuse my design with another CSV?

Yes. Select the saved template and import a new file. Column mappings belong to the current batch and are not saved with the template.

Can I repeat a label or skip used positions?

Duplicate a CSV row for each copy you need. In Avery mode, choose Starting label from 1–30 for the first sheet. Subsequent records fill consecutive positions; scattered empty positions cannot be selected.

Can I import Excel or Google Sheets instead?

Import XLSX or XLS directly using the Excel workflow. For Google Sheets, download a CSV or XLSX snapshot first; there is no live connection or spreadsheet-sharing requirement.

Try the complete 30-label example with downloadable CSV, mapping and a generated PDF.