Make certificates and badges in bulk from a spreadsheet

One row per certificate; names and numbers fill into the design automatically.

, or drop one here

Free for any number of rows, with no watermark.

How to use it

Turn one certificate design and a spreadsheet into an image for every row. Add a text layer for each part that changes and paste the rows from Excel or Google Sheets; each column fills a layer. Preview any row; Generate All downloads a zip of PNG or JPG files.

  1. Click Open your design and pick a PSD or image, or click the sample certificate on the card to open it. Want the sample in another style? Click Describe it and type, say, a navy completion certificate, portrait, two signatures: the preview on the card redraws to match, and Open this certificate opens it. For each part that changes, add a text layer with the Type tool and name it after your column, such as Name or Date.
  2. Choose Image > Variables > Data Sets. Paste your table with the first row as headers, or click Load CSV. Columns match text layers with the same name; fix any pairing in the drop-downs.
  3. Pick which column names the files (or Numbers 001, 002…), choose PNG or JPG, and step through the rows with ‹ › to preview.
  4. Click Generate All. A zip downloads with one image per row, and your document is left exactly as it was.
Can I make certificates from an Excel list without uploading the list?
Yes. Copy the cells in Excel, Google Sheets or Numbers and paste them into the Data Sets window; tab-separated text and CSV (comma or semicolon) are both read, and a CSV that Excel saved as GBK or UTF-16 is decoded correctly too. The table and the generated images never leave your device.
What can I type in the Describe it box?
Words the sample certificate understands: what it is for (completion, appreciation, award, participation, employee of the month, membership), classic, modern or minimal, portrait or landscape, a color (gold, navy, teal, burgundy, forest (green), rose (pink), charcoal (black)), a frame (double, thin, corners, none), an ornament (laurel, ribbon, stars), script, serif or sans, seal or no seal, one or two signatures, and the issuer after by. It changes the sample certificate previewed on the card (your own PSD keeps its design), describing again refines that one, and Open this certificate opens it as a document. A word it does not know is named under the box; Let the AI read it asks the AI assistant for the closest style (that part asks you to sign in), and only that sentence is sent.
Do I need a PSD?
No. Any JPG or PNG can be the background. Add a text layer with the Type tool for each field; the dialog only lists text layers, so a flattened image has nothing to fill until you add them. A PSD from Photoshop works as long as the parts that change are still text layers.
How are the files named and how big are they?
Each image is the full size of your document, as PNG or as JPG at quality 92. The file name comes from the column you pick, cut to 80 characters with characters such as / and : replaced by _; duplicates get _2, _3 and an empty cell falls back to the row number.
How many can I generate at once?
There is no row limit. Rows are rendered one after another at full document size with a progress message, and the result is a single zip, so a long list simply takes longer.

Updated 2026-10-21

More toolsUS passport photoPassport photoAdd watermarkProduct photo on whiteRemove backgroundPNG to JPGJPG to PNGWEBP to PNG

Make certificates and badges in bulk from a spreadsheet

One row per certificate; names and numbers fill into the design automatically.

, or drop one here

Free for any number of rows, with no watermark.

How to use it

Turn one certificate design and a spreadsheet into an image for every row. Add a text layer for each part that changes and paste the rows from Excel or Google Sheets; each column fills a layer. Preview any row; Generate All downloads a zip of PNG or JPG files.

  1. Click Open your design and pick a PSD or image, or click the sample certificate on the card to open it. Want the sample in another style? Click Describe it and type, say, a navy completion certificate, portrait, two signatures: the preview on the card redraws to match, and Open this certificate opens it. For each part that changes, add a text layer with the Type tool and name it after your column, such as Name or Date.
  2. Choose Image > Variables > Data Sets. Paste your table with the first row as headers, or click Load CSV. Columns match text layers with the same name; fix any pairing in the drop-downs.
  3. Pick which column names the files (or Numbers 001, 002…), choose PNG or JPG, and step through the rows with ‹ › to preview.
  4. Click Generate All. A zip downloads with one image per row, and your document is left exactly as it was.
Can I make certificates from an Excel list without uploading the list?
Yes. Copy the cells in Excel, Google Sheets or Numbers and paste them into the Data Sets window; tab-separated text and CSV (comma or semicolon) are both read, and a CSV that Excel saved as GBK or UTF-16 is decoded correctly too. The table and the generated images never leave your device.
What can I type in the Describe it box?
Words the sample certificate understands: what it is for (completion, appreciation, award, participation, employee of the month, membership), classic, modern or minimal, portrait or landscape, a color (gold, navy, teal, burgundy, forest (green), rose (pink), charcoal (black)), a frame (double, thin, corners, none), an ornament (laurel, ribbon, stars), script, serif or sans, seal or no seal, one or two signatures, and the issuer after by. It changes the sample certificate previewed on the card (your own PSD keeps its design), describing again refines that one, and Open this certificate opens it as a document. A word it does not know is named under the box; Let the AI read it asks the AI assistant for the closest style (that part asks you to sign in), and only that sentence is sent.
Do I need a PSD?
No. Any JPG or PNG can be the background. Add a text layer with the Type tool for each field; the dialog only lists text layers, so a flattened image has nothing to fill until you add them. A PSD from Photoshop works as long as the parts that change are still text layers.
How are the files named and how big are they?
Each image is the full size of your document, as PNG or as JPG at quality 92. The file name comes from the column you pick, cut to 80 characters with characters such as / and : replaced by _; duplicates get _2, _3 and an empty cell falls back to the row number.
How many can I generate at once?
There is no row limit. Rows are rendered one after another at full document size with a progress message, and the result is a single zip, so a long list simply takes longer.

Updated 2026-10-21

More toolsUS passport photoPassport photoAdd watermarkProduct photo on whiteRemove backgroundPNG to JPGJPG to PNGWEBP to PNG