Share via

Create visual PowerPoint slides from excel data

Anonymous
2023-12-22T17:56:26+00:00

Is there a way to use excel data to create a PowerPoint slide. I want to take data in excel such as words and numbers and have it auto populate in power point images that have been assigned to each word or number. The goal is to have each person fill out there row of dats and have their own individual slide based on their data.

Microsoft 365 and Office | PowerPoint | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Steve Rindsberg 99,156 Reputation points MVP Volunteer Moderator
    2023-12-23T16:45:23+00:00

    There's nothing like this built into PowerPoint or Excel, but both of them support VBA, a programming language that lets developers create add-ins that extend the abilities of both progams.

    As it happens, a couple of us here do this for a living.

    John Wilson's Simple Merge ( http://www.nattyware.com/pixie.php ) might do the job for you.

    If not, my PPTools Merge ( https://www.pptools.com/merge/ ) will almost certainly do this. To do the job with Merge, you'd use a formula of some sort in Excel to fill an extra cell with the name of the appropriate image file. Merge would then insert the image into PPT, each row of data becoming a new slide, each with whatever image and other text is appropriate.

    6 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-23T01:46:07+00:00

    Dear Daniel,

    I think the possible way may be to use Paste Special to link the Excel data to each slide for users to fill in the rows in Excel when they open the PowerPoint slides.

    .

    Meanwhile, I'll keep the thread open and welcome other community members to share their suggestions and opinions.

    Thank you for your time and effort.

    Sincerely

    Cliff | Microsoft Community Moderator

    0 comments
  2. Anonymous
    2023-12-22T20:48:53+00:00

    Dear Daniel Hartman1,

    Good morning!

    Thank you for posting in the Microsoft Community. We will be happy to help you. We are investigating your situation and will update the thread shortly.

    I appreciate your patience and understanding and appreciate your time and cooperation.

    Sincerely

    Sean | Microsoft Community Moderator

    0 comments