Embedded Files
Th
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
G
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the backgrounh
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the background.e
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the background.l
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the background.l
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the background.o
## Part 1: Design Certificate in Canva and Download as PNG
### Step 1: Open Canva
1. Go to [Canva](https://www.canva.com?utm_source=chatgpt.com)
2. Log in with your account.
3. Click **Create Design**.
4. Select **Certificate** or set a custom size.
### Step 2: Design the Certificate
1. Add:
* School/Organization Name
* Certificate Title
* Logos
* Borders
* Signatures
* Decorative elements
2. Leave blank spaces for:
* Student Name
* Course/Event Name
* Date
* Certificate Number
### Step 3: Download as PNG
1. Click **Share**.
2. Click **Download**.
3. Select **PNG**.
4. Choose **High Quality**.
5. Click **Download**.
---
# Part 2: Set PNG as Background in Microsoft Word
## Method 1 (Recommended)
### Step 1: Open Word
1. Open Microsoft Word.
2. Create a Blank Document.
### Step 2: Insert the PNG
1. Click **Insert** → **Pictures** → **This Device**.
2. Select the Canva PNG.
3. Click **Insert**.
### Step 3: Send Image Behind Text
1. Click the image.
2. Go to **Picture Format**.
3. Click **Wrap Text**.
4. Select **Behind Text**.
### Step 4: Resize to Page
1. Drag corners until the certificate covers the entire page.
2. Align properly.
### Step 5: Lock Position
1. Right-click image.
2. Select **Size and Position**.
3. Check:
* Lock Anchor
* Fix Position on Page
---
# Part 3: Create Text Boxes for Dynamic Fields
## Student Name
### Step 1
1. Insert → Text Box → Draw Text Box.
2. Draw over the blank name area.
### Step 2 Remove Border and Fill
1. Click Text Box.
2. Shape Format → Shape Fill → No Fill.
3. Shape Outline → No Outline.
### Step 3 Format Font
1. Select text.
2. Change:
* Font
* Font Size
* Bold
* Color
* Alignment
Example:
```
NAME HERE
```
Center align it.
---
## Course Title Text Box
Repeat same steps:
1. Insert Text Box
2. No Fill
3. No Outline
4. Place at Course Area
---
## Date Text Box
Repeat same process.
---
## Certificate Number Text Box
Repeat same process.
---
# Part 4: Prepare Excel Data Source
Create Excel sheet like:
| Name | Course | Date | CertificateNo |
| ---------- | -------------- | ---------- | ------------- |
| Ram Sharma | Canva Training | 2026-06-22 | C001 |
| Sita Rai | Canva Training | 2026-06-22 | C002 |
| Hari KC | Canva Training | 2026-06-22 | C003 |
### Save File
Example:
```
Certificate_Data.xlsx
```
---
# Part 5: Connect Excel to Word Mail Merge
### Step 1
Open Certificate Template in Word.
### Step 2
Go to:
```
Mailings
```
### Step 3
Click:
```
Start Mail Merge
```
Choose:
```
Letters
```
---
### Step 4
Click:
```
Select Recipients
```
Choose:
```
Use Existing List
```
---
### Step 5
Select:
```
Certificate_Data.xlsx
```
Click:
```
Open
```
---
### Step 6
Choose worksheet:
Example:
```
Sheet1$
```
Click:
```
OK
```
---
# Part 6: Insert Merge Fields
## Name Field
1. Click inside Name Text Box.
2. Mailings → Insert Merge Field.
3. Select:
```
Name
```
Word inserts:
```
«Name»
```
---
## Course Field
Insert:
```
«Course»
```
---
## Date Field
Insert:
```
«Date»
```
---
## Certificate Number Field
Insert:
```
«CertificateNo»
```
---
# Example Layout
```
CERTIFICATE OF ACHIEVEMENT
This certificate is awarded to
«Name»
for successfully completing
«Course»
Date: «Date»
Certificate No: «CertificateNo»
```
---
# Part 7: Preview Certificates
1. Click:
```
Preview Results
```
2. Use arrows:
```
<< Previous
Next >>
```
3. Check all records.
---
# Part 8: Generate All Certificates
### Option A: Create New Word File
1. Click:
```
Finish & Merge
```
2. Select:
```
Edit Individual Documents
```
3. Choose:
```
All
```
4. Click OK.
Word creates a document containing all certificates.
---
### Option B: Direct Print
1. Finish & Merge
2. Print Documents
3. All Records
4. Print
---
# Part 9: Save as PDF
### For All Certificates
1. File
2. Save As
3. PDF
OR
1. File
2. Export
3. Create PDF/XPS
---
# Final Recommended Workflow
**Canva Design → PNG Download → Word Template → Text Boxes → Excel Data → Mail Merge → Generate Certificates → Export PDF**
This method can generate hundreds or thousands of certificates automatically from a single Excel sheet while keeping the Canva-designed certificate exactly as the background.
Page updated
Google Sites
Report abuse