Excel Tip: Mail Merge to PowerPoint via Word Outline

A reader asked how to convert an Excel document into a PowerPoint presentation where the first column was a title page and the next two columns were the subtitles.
This sounded to me like a Mail Merge problem, and indeed Word proved a bridge to getting this done.

[@ronametung1]

This is exactly what I was looking for, Thanks

[@danturk368]

Is it possible to add the content to a pre-existing slide?

[@CassandraAnderson]

On PPT for Mac, it wouldn't accept a Word doc outline, only CSV file; which did work, so still helpful. Unfortunately, formatting was terrible from a CSV - luckily the suggested Design Ideas in the latest version of PPT helped make the formatting better fast (not ideal though needing to touch every slide - only had 40 slides which made it manageable. Thanks for the help!)

[@elizabethbostic6519]

Thank you! Exactly the problem I was having

[@monicaberns4664]

You have to use the slidemaster to create a master format that would be applied to all of your slides BEFORE merging the data. I hope that makes sense.

[@rashaqissi6324]

thanks a lot it is helpful :) i used slide master to choose a default background and manage the fonts style for all slides

[@sejalshah-myers113]

You are awesome! I hope I can use this...I need to make 40 slides and I'd like to add pictures too!

[@ruirui4581]

Is it possible for cells contain pictures?

[@lisawhelpley]

Thank you so much! You were a lifesaver.

[@samsoul4]

Thanks for the video, I've managed to import the data but impossible to change the font the way I want to. Can anyone explain me how to do so not to get everything in Times New Roman when exported even if I did customize the headings in word before and the slide master in PPT ? Thanks a lot !

[@MZ-ox1zz]

The word document that you create to merge into PPT is where you would apply the font formatting to (es: color, size, font type). When you merge the data into PPT, it will carry over all the font formatting you selected! :)

[@fiezahadie]

it's not working 4 me..whyyyy T_T

[@knowledgeispower6653]

Thank you!

[@jamesbarber8202]

Thanks, the video was great. There is an add-in that does much more, but at $29 a month to something simple is not smart money.