# Turn a product spreadsheet into a print-ready PDF catalog

> Upload a product spreadsheet and get a paginated PDF catalog with category sections, cover, dividers and back cover. Built in the Templated dashboard, no code.

- **URL**: https://templated.io/workflows/product-catalog-pdf-from-spreadsheet/

---

One upload turns hundreds of products into a paginated catalog: product grid filled, a section per category, cover and back cover merged into one PDF.

[Start free](https://app.templated.io/signup) · [See the setup](https://templated.io/workflows/product-catalog-pdf-from-spreadsheet/#how-to-run)

50 free credits. No credit card required.

1. When

   CSV or Excel file

   Product list

2. Templated

   Render PDF

   Multi-page catalog

3. Then

   PDF download

   Download one PDF

## At a glance

Wholesale line sheets, price lists for sales reps, seasonal lookbooks: catalogs get rebuilt every time a price or a product changes, and laying out pages by hand is slow work that breaks with every edit.

Catalog generation takes a template with product slots and a spreadsheet. Templated fills the grid page by page, starts a new section when the category changes, and adds the cover, the dividers and the back cover. You get one PDF, ready to send or print.

- Trigger

  CSV or Excel file: Product list

- Output

  PDF, Multi-page catalog

- Delivered to

  PDF download: Download one PDF

- Run it with

  Catalog generation

- Cost

  1 credit per page rendered

- Free plan

  50 credits, no credit card required

## How it works

Three steps, from the event to the finished file.

1. ### Pick a catalog template

   A page with product slots (photo, name, price, SKU), plus a cover, a divider and a back cover.

2. ### Upload the product list

   Upload a CSV or Excel file and map its columns to the slot fields, including the category column.

3. ### Download the PDF

   Templated paginates the products, groups them by category and merges every page into one PDF.

## Map your data to the template

Each dynamic layer in your template gets its value from one field. Name your layers like this, or map whatever names you use.

| Template layer | Comes from | Example |
| - | - | - |
| photo | Image URL column | https\://.../chair.jpg |
| name | Name column | Oak Lounge Chair |
| price | Price column | $420 |
| sku | SKU column | OLC-01 |
| section | Category column | Living room |

Text layers take `text`, image layers take `image_url`. You can also change colors, hide layers or swap fonts per render. [See every layer property](https://templated.io/docs/renders/create/).

## When to use it

- B2B and wholesale teams who send line sheets or price lists.
- Retailers who print or email a seasonal catalog.
- Anyone who rebuilds the same catalog every time prices change.

## Tips

- Sort the spreadsheet by category first. A row with an empty category stays in the section of the row above it.
- Keep image URLs public and reasonably sized so the PDF stays light.
- Need the catalog in another language or price list? Upload a second file on the same template.

## How to run it

Set it up in a few minutes.

### Catalog generation

In the dashboard, no code

1. Open **Catalog generation** in the Templated dashboard and choose a template with product slots.
2. Upload your CSV or Excel file and map the columns to the slot fields.
3. Pick the content page, and optionally the cover and back cover and a section divider, then choose the category column.
4. Generate and download the PDF.

[More about Catalog generation](https://templated.io/integrations/catalog/)

## Related workflows

- ### [Turn a product CSV into marketing images for your whole catalog](https://templated.io/workflows/product-images-from-csv/)

  Export your products, upload the file, map the columns once and download an on-brand image for every product in the catalog.

  Spreadsheet generation, REST API, AI agent (MCP)

- ### [Generate sale and discount banners from a pricing sheet](https://templated.io/workflows/sale-banners-from-google-sheets/)

  Your pricing sheet becomes the design brief: each new row turns into a sale banner with the old price, the new price and the discount.

  Make, Zapier, n8n, Spreadsheet generation, REST API

- ### [Make catalog ad images for every product in your feed](https://templated.io/workflows/product-feed-ad-creatives/)

  Give dynamic product ads a branded frame: one creative per product, with price and offer, written straight into the feed your catalog uses.

  Make, Zapier, n8n, REST API

[See all workflows](https://templated.io/workflows/)

## Set up your first workflow today

Create a template, connect your tool and render your first image in minutes.

50 free credits. No credit card required.

[Start free](https://app.templated.io/signup)
