Automatically Generate Multiple Word or PowerPoint Sections from Excel Rows

Repeating sections automatically generates multiple sections in a Word or PowerPoint document from rows in an Excel table. The sections are based on a template section or slide that you design. The add-in repeats that template for every row in your Excel table, filling in text, images, tables, and HTML automatically. The result is consistent formatting and data-driven content at any scale, with no manual editing required. Repeating sections is a very powerful feature included in the Excel-to-Word Document Automation add-in.

This very simple example shows how to update text-based sections. In my Excel table, each of the three rows will create and update a section. I submit the content. Then in Word, here is my template section. These three text areas are linked to columns in my Excel table. When I click update document, we can see that it automatically and reliably creates and updates the content of a section for each Excel row. In PowerPoint, here's my template slide. The update creates a slide for each Excel row. It updates the content in the text shapes that are linked to the columns in the Excel table.

When should you use repeating sections? If you are copying and pasting the same layout with different data, repeating sections was built for you. It can automate a variety of workflows such as - catalogs with one section per product, inspection reports with one section per finding, summary decks with one slide per client, and proposals with one section per solution.

Here are the key benefits that make repeating sections worth adopting. First, save time and boost quality. No more manual copy and paste and every section stays 100% consistent and easy to update. Second, design on your terms. Use your own document and slide designs and mix text, HTML, images, and tables in a single section. And third, scale without limits. Sections can be as small as a paragraph or as large as full chapters, and you can update hundreds of them in seconds. Best of all, it combines with other related features like conditional content and auto-hide rows.

This example contains other content types, including HTML, three methods to update images, and tables. Other repeating sections solutions don't support these content types. I'll submit the content. Then in Word, when I update, the sections are created and populated with the content from Excel, including text, HTML content, images, and tables. In this example, we have one section per page. Also in PowerPoint, here's the template slide. When I click update document, the three slides are created and the linked content is updated, including the text, images, and tables. In this last example, we'll start with three rows. In Word, it creates three sections. Then, I'll add a lot more rows. I'll submit content. In Word, we can see that it quickly adds and updates one section for each row. You can create hundreds of sections. Also in PowerPoint, when I update, the slides are created and the linked content is updated. Multi-slide template sections are also supported, enabling many automation possibilities.

Next, view the repeating sections tutorial video, then set up repeating sections in your own document. Thank you.