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 provides handling up to 10 data rows (if you want more contact us).

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.