← All postsPerson using Catalog Maker on a laptop for a real wholesale task

Turn a 24-SKU Spreadsheet into a Wholesale Line Sheet PDF

Paste CSV rows, group products by category and build a cover, contents page and product cards you can email to buyers.

catalog makerline sheetwholesale catalogproduct catalog PDFCSV importprice listpdf toolsbrowser tools
5 min readPublishing & Print Makers

A buyer at a gift shop has asked for your range ahead of Thursday's appointment. What you have is a spreadsheet with 24 products, a folder of photos and no design software. Building that into a clean document by hand takes hours, and a raw spreadsheet printout does not make a first impression. Product Catalog Maker turns the rows into a PDF with a cover, a contents page that lists each category with its page number, and neat product cards.

There are two modes. Product list builds the pages from typed or pasted product data. Combine files wraps a cover and contents around sheets you already have. Both run in the browser, so your price list and photos are not uploaded. The clip below shows the product-list workflow.

How to Make a Product Catalog PDF Online

How to Make a Product Catalog PDF Online

Prepare the spreadsheet first

The importer reads five columns: name, SKU, price, category and description. If the first row contains at least two recognised headings such as product, code, cost or group, it is treated as a header. Otherwise the columns are read in that order. Rows without a name are skipped, so a blank spacer row is harmless but a product with a missing name will vanish.

Tidy three things before you paste. Give every product a category, because the contents page is built from categories, not individual products. Keep names short, since the name uses at most two lines on the card. Trim each description to four short lines, because longer text is cut off.

A sample header and row looks like this: name,sku,price,category,description then Blue Mug,MUG-1,12.50,Kitchen,Ceramic 350 ml.

Worked example: 24 products, four categories

Say the range is six mugs, six planters, six candles and six textiles. Paste all 24 rows into the Paste CSV box and press Add pasted rows, or use Import CSV file. The cards appear in the list and you can add a photo to each one.

Next comes Layout: currency, columns (2 or 3 per row), page size (US Letter or A4) and an accent colour, plus tick boxes for the cover page and the contents page. Type a Catalog Title such as "Autumn Range 2026" and your company name. A title is required if the cover is on.

I planned this exact shape through the layout logic with short names and one-line descriptions. At 3 per row, the four categories of six fall on four product pages, one per category, so the PDF has a cover, a contents page and four product pages: six pages in total. At 2 per row the same range spread over six product pages in the same test. Longer text makes cards taller and pushes the count up, so treat these numbers as an indication and check the page count on the Download button, which shows the total.

Steps in the tool

  1. Choose Product list at the top.
  2. Enter the catalog title and company name.
  3. Paste or import the CSV, then scroll the product list and fix anything that looks wrong.
  4. Add a photo per product. A photo is scaled to fit and centred inside the card's photo area, so a very wide or very tall picture will leave empty space beside it rather than being cropped.
  5. Pick currency, columns, page size and accent colour. Numeric prices are reformatted, so 12.5 becomes 12.50 with the chosen symbol. Text such as "Ask for quote" is left as typed.
  6. Press Build Catalog. This counts as one of your 2 trial usages for the day.
  7. Look through the preview, then download the PDF. If something is off, press Edit and change it without retyping.

What you will notice in the preview

Products are grouped by category in the order each category first appears in your list, not alphabetically. If you want Candles before Mugs, reorder the rows so a candle comes first. A category heading is drawn above its group, and the group starts on a new page if its heading and first row would not fit at the bottom of the current page.

The contents page lists categories with the page on which each starts. If you have no categories at all, the contents page is skipped, because there is nothing to list. Currency choices include US dollar, Euro, Pound, Rupee, Canadian dollar, Australian dollar, Yen, Singapore dollar, Dirham and Rand. Price formatting follows US-style number layout, so a euro price shows as €12.50 and not 12,50 €. If your buyers expect a different layout, type the price as text.

When to use Combine files instead

Suppose your supplier already gave you PDF sheets for the two hero products, and your price list sits in a Word file. Switch to Combine files, drop the files in, name each section so the table of contents reads properly and drag them into order. You can set a cover with an optional PNG or JPEG image, add a Product Index page, and put a price list or ordering information on the back page. The back page can also carry a QR code to your order form or a real barcode in Code 128, EAN-13, EAN-8, UPC-A, Code 39 or ITF-14, with a value that must be valid for the type.

Combine files accepts PDF, Word .docx, plain text and PNG, JPEG, WebP or HEIC images. Pages are shrunk to the chosen size, so mixed sources get white margins. Older .doc files and spreadsheets are skipped with a warning.

Mistakes that cost a second pass

Leaving categories blank, so the contents page vanishes. Pasting prices with currency symbols inside, such as "$12.50", which can be read as text and left unformatted, so enter plain numbers and let the tool add the symbol. Using enormous photos, which makes the PDF heavy to email. Forgetting that the description is cut after four lines, so a key detail such as pack size should sit in the first line. And judging page count before looking at the preview: cards with two-line names and four-line descriptions take noticeably more space.

Finishing and sending

A catalog full of photos can reach tens of megabytes. Run it through Compress PDF if the email bounces, and zoom in on a product photo afterwards to see whether it is still crisp. To add a one-page terms sheet or a personal note, use Merge PDF with your catalog. To send one buyer only the candle pages, Split PDF pulls out a page range, though page numbers on the contents page will still refer to the full document. More options live in the PDF tools category.

The output is a fixed single-style catalog, so it will not offer option tables for product variants or live ordering. Check prices, SKUs and descriptions against your source sheet before you send it to a buyer.

Which format do your buyers ask for most, a line sheet, a full catalog or a price list on its own? Tell us on the contact page.

Open Product Catalog MakerOpen Merge PDFOpen Split PDFOpen Compress PDF