How to Make a Product Catalog from Excel or CSV (Without InDesign)

Your product data already lives in a spreadsheet. Here's how to turn that Excel or CSV file into a polished, print-ready PDF catalog in minutes — no design software, no template wrangling, no subscription.

Every wholesaler, brand, and distributor keeps their product list in Excel or a CSV export — from Shopify, WooCommerce, or an ERP. And every trade fair, buyer meeting, and sales call eventually ends with the same request: "Can you send me your catalog?"

The traditional answers are all painful. Building it manually in InDesign or Canva takes days and goes stale the moment a price changes. Generic catalog software charges monthly fees and still makes you drag products around. Agencies cost real money per revision.

There's a faster path: generate the catalog directly from your spreadsheet. Here's the complete process.

Step 1: Clean your spreadsheet

You don't need a perfect file, but a few habits make everything easier downstream:

• One row per product (or per variant) — don't merge cells for styling
• Consistent column names: Title, SKU, Price, Wholesale Price, Category, Image URL, Description
• Image URLs in a column — a Shopify export already has these in Image Src
• One price column for retail and one for wholesale if you serve both B2B and B2C

Step 2: Import the file and map your columns

A spreadsheet-to-catalog tool parses your file and asks which column is which: product title, SKU, barcode/EAN, retail price, wholesale price, category, image. This mapping takes under a minute and is usually auto-detected for standard exports.

What matters most for a professional result:

• Dual pricing: showing both the suggested retail price and the trade price is the single most useful feature for B2B buyers
• Barcodes: if your products have EAN codes, render them — retailers use them to set up your items in their systems
• Category grouping: buyers navigate catalogs by category, so make sure that column is filled

Step 3: Choose a layout that fits your audience

Not all catalogs should look the same. Pick based on who receives it:

Grid catalog (2–4 products per row)

The default for most B2B catalogs. Dense, scannable, works for hundreds of SKUs. Best when buyers need prices and references more than atmosphere.

Table / line sheet layout

One product per row with a compact variant table. Ideal for price lists and order forms — sales agents love these because they can annotate them.

Lookbook / editorial layout

Large photos, minimal text, 2–4 products per page. For fashion, design, and premium brands where the product image sells. Often paired with a separate price list.

Grand catalog (2 products per page)

Product hero image, full description, variant table, and price. The format for technical products or premium assortments that need explaining.

Step 4: Add your brand and export the PDF

Upload your logo, set your brand color, choose a cover. Then export to a print-ready A4 PDF: 210×297 mm pages, margins respected, vector text and barcodes so it stays sharp at any print size.

Keeping it fresh (the real win)

The biggest advantage of generating from a spreadsheet isn't the first catalog — it's the second one. Price change? Update the Excel file, re-import, export again. New products added to Shopify? Same flow. Your catalog stops being a quarterly design project and becomes a 5-minute task you can repeat before every sales cycle.