SPREADSHEET PRINTING GUIDE

Print File Folder Labels from Excel or CSV

Turn a filing list you already keep in Excel or CSV into printable file folder labels: save one reusable tab design, import the list, connect the FolderName, FolderID and Year columns, and export a print-ready A4 sheet with one label per row, in your spreadsheet’s original order. This tutorial uses an 85 × 16 mm tab you cut yourself — not a pre-cut Avery grid. The dimensions and margins below are example assumptions: measure your folder tabs and your printer’s non-printable edge before you commit to a full run.

Prepare your folder list

Keep one row per folder tab and one column per printed value. The example uses three columns: FolderName (what the tab says in large type), FolderID (a short reference code) and Year (displayed on the right edge). Rows print in the order they appear in your spreadsheet — PrintPiper never sorts, groups or reorganizes them — so arrange the list the way you will file the folders. Keep ID values as text so leading zeros such as 00041 survive the round trip; the import preserves them as typed.

Year is a plain display-only field here. Nothing automatically groups, colors or archives by year; if you color-code by year, decide the color before importing or leave Year out of the design. For Excel, select the worksheet that holds the final list and make sure row 1 contains the column headers — PrintPiper reads those headers when connecting columns.

Set up the 85 × 16 mm template

Choose New template and set the values yourself instead of picking a preset. Edit the template in this order — Frame (size, background, then text fields), then Page, then Layout — and only save once everything below is in place:

1. Frame: width 85 mm, height 16 mm. Set padding to 2 mm on all sides (the default is 0, so enter it explicitly). Padding shapes where text may sit inside the tab and does not print.
2. Frame background: upload the downloadable background.png under the frame’s Image template, choose the Contain fit, and after uploading explicitly set the frame dimensions to 85 × 16 mm instead of trusting the file. This artwork draws the thin cutting outline that prints — the outlines shown in the samples come from it, not from the grid itself.
3. Page: A4 (210 × 297 mm) at 300 DPI, with 10 mm printer margins on every edge. Those margins are an example value: check your printer’s non-printable edge and raise the margin if your model needs more.
4. Layout: Images per sheet = Grid sheet, column/row gap 6 mm, content alignment centered, bleed 0, crop marks off. The columns and rows auto-fit the printable area — this frame yields a 2 × 12 grid.

After adding the three text fields described in the next section, click Save template — the one save action in this workflow. Frame, background, fields, page and layout must all be finished first; CSV upload unlocks only after the template is saved to your account.

The 2 × 12 grid has 24 positions, but positions are not records: three spreadsheet rows produce three printed labels on one A4 page, and the remaining cells stay empty. A larger grid never increases how many rows you may export — the Free plan allows 10 records per export.

A note on Avery 5366: this tutorial is deliberately not built-in Avery 5366 support, and an 85 × 16 mm tab is not compatible with that stock. White Avery 5366 labels are a different product — 2/3 × 3-7/16 inch, 30 labels per sheet — so check your pack before buying: Avery’s own file folder label article lists the exact 5366 dimensions. PrintPiper has no 5366 integration; this guide is for cut-your-own tabs only.

Text field positions

Add three separate text fields in the Frame view, one variable each. Coordinates are measured in millimetres from the upper-left of the 85 × 16 mm frame. When every field is in place, save the template as described above.

Shrink text to fit protects long folder names from overflowing the tab. Check your longest real name before exporting — the layout preview shows every selected field inside the usable area.

Worked example: three folders

All folder names, IDs and years below are fictional. The sample files are freely downloadable.

The folder ID column keeps its leading zeros because it is imported as text. Year is printed exactly as stored — 2026 stays 2026, with no automatic grouping or coloring.

Import and connect columns

In the right panel choose Import CSV / Excel and select your file (XLSX, XLS, CSV or TSV). The sample workbook holds one worksheet named “Folders”; in a multi-sheet workbook pick it from the worksheet list. Row 1 is the column-name row — click it in the preview if it is not already marked, then click Import records. Only after the records are imported do you connect each variable to its column under Connect columns.

Because the sample headers and variable names match exactly, all three connections are automatic. With your own files, connect each variable to its column under Connect columns — FolderName, FolderID and Year map to three separate columns; one field never combines literal text and a variable.

Select the longest row in the preview to confirm nothing overflows — that click only changes the preview and never restricts which rows are exported. Exporting covers the range set under From row and Through row: for this sample, From row 1 through row 3. Mapping applies to the imported batch only; it is never saved into the template, and your spreadsheet stays on your device. You can rerun the export with different ranges without re-importing.

Export, print and cut

Choose Print-ready PDF, click Generate files, and wait until the last file is committed before clicking Download. The sample produces one A4 page with three labels. Pagination is strict: 24 records fill exactly one A4 sheet, and the 25th record starts the next sheet — a partial run never spills into a second page just because the grid has free cells. Print at Actual size / 100% with Fit, Shrink and any “scale to page” option disabled, on plain paper first.

Measure a test label against an actual folder tab before printing on cardstock or adhesive stock. The 10 mm margins and 6 mm gaps are example assumptions for this tutorial, not requirements — measure your printer’s non-printable edge and your folder tabs, and adjust the template, not the print dialog, if your printer’s printable area differs. Printer and stock compatibility are not guaranteed — use stock your printer handles, then cut along the outer edge of the printed outlines with scissors or a paper trimmer.

Troubleshooting

• Cuts miss the outline: the print was scaled. Reprint at Actual size / 100% and verify with a plain-paper test.
• Labels clipped at the sheet edge: your printer’s non-printable margin exceeds 10 mm. Raise the Page margins; the frame is never resized implicitly.
• Leading zeros vanished (00041 → 41): the value was edited or re-saved in Excel as a number. Keep the ID column as text and re-import.
• Long names look cramped: shrink-to-fit reduced the font. Shorten the name, or widen the field within the 2 mm padding. PrintPiper never splits a name across fields automatically; if you want a split, put the parts in separate spreadsheet columns and add one field per part with its own variable.
• Expected 24 labels but see 3: the grid has 24 positions, but only rows you import print. Empty cells are not filled with repeats.

File folder label questions

Can I use Avery 5366 or another pre-cut sheet?

Not with this design. 5366 is a 30-up, 2/3 × 3-7/16 inch white stock — a different grid from 85 × 16 mm tabs, and PrintPiper has no 5366 integration. Check Avery’s article for that stock’s true dimensions. PrintPiper has no 5366 integration, and this guide doesn’t cover it: for a pre-cut stock the app explicitly supports, start from that stock’s preset instead of recreating it — do not assume a hand-built frame with an auto-fit grid reproduces an arbitrary stock’s label size and pitch.

Does PrintPiper sort or group by Year?

No. Rows print in spreadsheet order and Year is a normal display-only field with no grouping, coloring or auto-archiving logic. Sort in your spreadsheet first if you want a specific filing order.

Is my Excel file uploaded to a server?

No. Your workbook, CSV rows, column mapping and generated files stay on your device. Only the saved template’s artwork and field settings are stored privately in your account, so you can reuse the design for the next filing season.

Can I put a color band or logo on every tab?

Yes, as template artwork: it repeats identically on every label while the spreadsheet replaces the text. That is exactly how this tutorial’s cutting outline works — the background.png artwork holds it. Upload a PNG sized for the 85 × 16 mm frame with a Contain fit and keep the fields inside the 2 mm padding.

How many tabs fit on one A4 sheet?

24 at this size (2 columns × 12 rows with 6 mm gaps), and 24 records fill exactly one sheet — the 25th starts the next page. You print only as many labels as you have rows; rerun the export when new folders are added.

Do I need the Avery numbering or a special template file?

No. This workflow uses a custom frame you define in millimetres on plain printer paper or cardstock. It is an example layout, not a tested match for every folder style — measure your own tabs and your printer’s margins before a full run.