PrintPiperOpen app SPREADSHEET PRINTING GUIDE
How to Print Labels from Excel Without Word
To print labels from Excel without Word, export your worksheet as CSV. In PrintPiper, create and save a label template, import the CSV, then preview and export a PDF. Each row fills one copy of your template.
Before you start: PrintPiper imports CSV data, not .xlsx or .xls workbooks. The editor currently requires an authorized account. It produces individual label pages and does not lay out multiple labels on a pre-cut sheet.
Which method fits your label stock?
For a sheet of address labels, Microsoft’s standard workflow uses an Excel mailing list with Word Mail Merge. Select the label supplier and product number in Word, connect your address list, insert fields, update the labels, preview, and print. Follow Microsoft’s label mail merge guide for that workflow.
PrintPiper’s CSV workflow suits individual label pages, custom product stickers, name badges, and personalized documents. Use it when you want to place spreadsheet values on your own PDF or image design.
1. Prepare one row per label in Excel
Put unique column headers in the first row and one record on each subsequent row. Remove merged cells and extra title rows. Store postal codes and product identifiers as text before entering them so leading zeroes are preserved. A number format that only displays extra zeroes is not a reliable substitute for text values.
| Name | Address | City | State | PostalCode |
|---|---|---|---|---|
| Alex Example | 12 Sample Lane | Exampleville | MA | 01234 |
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
2. Export the worksheet as CSV
In Excel, use File → Save As and select CSV UTF-8 when available. Export the worksheet containing the label records and keep your original workbook: CSV does not retain workbook formatting or multiple sheets. Microsoft documents this in its CSV import and export instructions.
Open the saved CSV in a text editor to check the headers, accented names, and postal codes. Avoid reopening it in a spreadsheet that may reinterpret text as numbers.
3. Create the template and add your fields
Open PrintPiper and use Select template for an existing design, or New template to create one. Start blank or add a PDF, PNG, JPEG, WebP, or TIFF as template artwork. These are design files; the variable data still comes from CSV.
Add a text field and enter the placeholders shown above, using the exact column names. Position the field and set its font size. In Paper & image fit, choose a size such as Address · 89 × 36 mm or enter custom dimensions. Set margins and image fit as needed.
If an imported design already has text in that area, Cover existing template text covers the field rectangle. Check that it does not cover nearby artwork.
4. Save the template, then import CSV
Click Save template at the bottom of the editor. After the account save succeeds, the right panel enables Import CSV. Choose the exported .csv file and check the data preview. An existing saved, unmodified template is ready for CSV import.
The save stores template artwork and field settings in your account. CSV row values and generated files are processed locally in your browser. If you edit the template again, save the changes before exporting.
5. Preview, export PDF, and print at 100%
Check several records, including the longest names and addresses. Select Print-ready PDF and a row range in the right panel, then choose Export batch. Larger batches download as a ZIP containing multiple PDFs. TIFF images in a ZIP are also available.
Print the exported PDF at Actual size or 100% with matching printer paper dimensions. Start with one test label. Bleed or crop marks enlarge the exported page beyond the finished label, so check the export dimensions shown in the app.
Common Excel-to-label problems
Why did my postal codes lose leading zeroes?
If the zeroes are missing in the CSV itself, correct the source values in Excel and export again. PrintPiper preserves imported CSV values as text; it cannot recover digits already removed by Excel.
Why are fields blank or columns missing?
In Connect columns, connect every template variable to a CSV column. Exact names connect automatically; for example, {{PostalCode}} can also be connected manually to a ZIP column. Headers must be unique and nonempty, and every row must have the same number of values as the header row. Save again if you change the template itself.
Can I print Avery 5160 or 30 labels per sheet?
PrintPiper does not currently arrange different CSV rows into a multi-label sheet. For pre-cut stock such as Avery 5160, use Word Mail Merge or a sheet-label tool that matches the stock’s margins, pitch, and label count. A generic multiple-pages-per-sheet setting does not guarantee alignment.
How large can my CSV and export be?
CSV import supports up to 10,000 rows and 200 columns, with a 15 MB file limit. Each export supports up to 1,000 output pages, subject to image and archive limits. A multi-page template uses more than one output page per row; select a smaller row range for large batches.