Merge Excel (XLSX) data with PowerPoint template

Placeholder Syntax

• Text Values: Use double curly braces for text placeholders. Example: {{name}}, {{company}}, {{title}}
• Image URLs: Use the same syntax as for text placeholders. Example: {{profile_picture}}, {{company_logo}}.
  You must add sample image (it will be replaced with the one under the provided URL) and type the placeholder name into the contents of "Alt text". This can be achieved by right-clicking the image and selecting "Show alt text" from the menu.
  NEW FEATURE You can now embed images in your Excel file. Here are the 3 simple steps to use images embeded in Excel in resulting PowerPoint presentation:

  1. Insert image (or images) alongside your data (wherever in the worksheet).
  2. Edit 'Alt text" field for the image(s) and type in a handle (e.g. projectStatusOK, projectStatusWarn, projectStatusNOK).
  3. Use that handle in the image column (assume you called the column projectStatus) instead of image URL and our service will know, that it should look for the image inside of the provided data (Excel) file.

  Check one of our blog posts - Generate Project Status PowerPoint from Excel with Images (Fast & Easy) to find sample PPTX and XLSX files.
• QR Codes: QR codes are rendered as images, using our component syntax. Example: {{data=contact_info type=qr}}, {{ data=website_url type=qr }}.
  You must add a sample image (the one to be replaced with generated QR code) and type the placeholder name into the contents of "Alt text". This can be achieved by right-clicking the image and selecting "Show alt text" from the menu.
• Sample Presentation Template (PPTX) Download example PowerPoint presentation to see how it looks and works with sample data provided below.
• Sample Excel Data File Template (XLSX) Download example Excel(XLSX) file to see how row oriented data should look like.

Upload Your Files

1. PowerPoint Presentation: Upload a PPTX file containing your placeholders. Ensure the placeholders match the names of the columns in your XSLX file.
2. Data: Proide your XLSX data file in the designated field. Each column should correspond to a placeholder in your PowerPoint slide. This free version allows the creation of up to 5 slides in a single run (if you need more check our pricing).

Step-by-Step Guide

1. Prepare Your PowerPoint Slide: Design a PowerPoint template using the specified placeholder syntax.
2. Prepare Your XLSX Data: Ensure your XLSX data has headers matching the placeholders in your slide. For JSON objects the object properties must match the placeholders.

3. Upload and Submit: Drag and drop your PPTX file, upload your XLSX data file, and hit the submit button. Our service will process the data and provide you with a link to download the generated presentations.

Frequently Asked Questions about Excel to PowerPoint conversion

1. How do I mail merge Excel into PowerPoint?

   Upload your Excel (.xlsx) file and a PowerPoint template to the Excel → PPTX tool to automatically create a personalized presentation.

2. What are common use cases for Excel to PowerPoint?

   Certificates, personalized reports, marketing decks, quizzes, and bulk presentations for events or training.

3. Will my Excel formatting be preserved?

   Cell values are mapped into your PowerPoint template’s placeholders. Visual formatting in Excel doesn’t transfer, but layout and styles come from your PPT template, the same goes for text and table formatting and image cropping, effects.

4. Is the Excel to PowerPoint converter free?

   Yes, with limitation. You can convert Excel to PPTX online for free on pptxmailmerge.com—no signup required. The free tier is limited to 5 data rows. If you need to process more data, you can upgrade to a paid plan.

5. Where can I find examples on how to use Excel to PowerPoint conversion?

   Check out our blog posts with various use cases and step by step examples:

   • How to merge Excel data into PowerPoint presentation?
   • Create quiz wtih PowerPoint and Excel in a few simple steps
   • Automate pricing offers with Excel and PowerPoint
   • Generate Project Status PowerPoint from Excel with Images (Fast & Easy)
   • Create Project Summary / Case Study Using Excel and PowerPoint