Online tool · PowerPoint populate

Populate a PowerPoint template

Choose a designed template slide and a workbook of records, and get one populated slide per record. Everything runs in this page using the same operation the ConsultChimps command line uses

Files are processed locally in your browser and are not uploaded to ConsultChimps

1. Choose a template

Drag a PowerPoint .pptx presentation here, or pick one with the button below. Its placeholders use the {{field_name}} syntax. Only the first presentation is used

2. Choose the records

Every nonempty row below the header row becomes one slide. Each template placeholder must match a column header exactly: whitespace inside the braces and around the header is trimmed first, and the two are then compared character for character, including case

Drag an Excel .xlsx or .xlsm workbook here, or pick one with the button below. Only the first workbook is used

Optional. Defaults to `<template>-populated.pptx`. The `.pptx` extension is added for you

Advanced options

Optional. Reads the records from one worksheet by name. Defaults to the first worksheet

Optional one-based row number. Defaults to the first nonempty row in the worksheet

Optional one-based slide number. Defaults to the first slide in the template. The finished presentation holds one populated copy of this slide per record and nothing else. The original template slide and any other slides in the template are not carried into the output

3. Preview

Choose a template and a records workbook to see the presentation this task will create

4. Run