This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We gave a presentation and notes were taken to help with each slide. They were typed into an Excel spreadsheet. I can import them into a Word document, but I really don't want to have to retype them all. Is there a way to insert data from either a spreadsheet or document into the notes section of the slides? Preferably without overwriting any notes that may already be there.
Any help you can provide is appreciated! I have Office Pro Plus 2013.
Thanks!
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
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.
Answer accepted by question author
There's some code on our site. It is based on Steve's method but slightly different so maybe give it a go. It allows you to select any path to the notes text (best on desktop)
The code and directions can be found following the link. (It's a little long to post here.) http://www.pptfaq.com/FAQ00937\_Importing\_notes\_text\_from\_a\_text\_file.htm
When I go into the master for the notes page, there is a text box for the notes.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 6%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Can you post the link to the code you found online?
Is there in fact a notes text placeholder on the notes master and/or on each of the notes pages in the presentation? Sounds as though there might not be.
Well, it is a rather large deck of slides, but the bigger thing is doing it again in the future. I found something online that is supposed to take it and import it into the notes with VBA code but I get a run-time error with "specified value is out of range" on the section it referenced the notes text placeholder.
I can copy and paste this time but figuring out how to do it going forward would be wonderful so I figured I'd ask.
You could fairly easily copy/paste the notes from spreadsheet/document into the notes section of each slide as appropriate. You could either paste them before/after or atop the existing notes, if any.
In theory, this could be automated, but it'd take longer to settle on the specs for the project, much less to code it, than it'd take to do manually. It wouldn't be worth the effort unless a) there are thousands of slides or b) this is something that has to be done regularly.