Importing List of Words from Excel to PP

  • Thread starter Thread starter Kitty
  • Start date Start date
K

Kitty

Hi!
I am a teacher and have a list in Excel of 225 "sight"
words. I would like to import these words into a power
point presentation with one word per slide so the kids
can have electronic flash cards. Is there a way to do
this without retyping each word?

Thanks.
 
Kitty,
Save your Excel file as a text file, with each word on an independent line.
Open PowerPoint and do File--> Open. Change the type to All Outlines and
navigate to where you saved the file. Each word should end up on its own
slide in the title placeholder. Format the presentation as you want. (You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Kitty,
Save your Excel file as a text file, with each word on an independent line.
Open PowerPoint and do File--> Open. Change the type to All Outlines and
navigate to where you saved the file. Each word should end up on its own
slide in the title placeholder. Format the presentation as you want. (You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!
Click to expand...

One wrinkle ... might need to bust the text file into two parts. I think PPT
may limit you to adding 100 slides this way.

Once you have both converted to PPT, Insert, Slides, From File should merge the
two.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Steve,
I don't think the file needs to be split - I've just tested it with over 400
copy and pasted words in a list and it worked just fine. Want me to send you
the text file so that you can test it?

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Steve,
I don't think the file needs to be split - I've just tested it with over 400
copy and pasted words in a list and it worked just fine. Want me to send you
the text file so that you can test it?
Click to expand...

It may be version-dependent. If you say it works, it works. In which version?
<g>

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
2003 - You want me to check it on the other ones? I'll do it later
today....

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Steve, I tried 400 words in PowerPoint 2000 and 2003 and it worked.

However, I have not tried 400 titles with different indents - also no
variations in form from slide to slide were used since all slides only
included a title.

Also, I don't have PowerPoint 97 installed to test - anyone with PowerPoint
97 installed?

--
Geetesh Bajaj, Microsoft PowerPoint MVP
PowerPoint Notes: http://www.indezine.com/notes
Free Templates:
http://www.indezine.com/powerpoint/templates/freetemplates.html

Technical Specialist, PowerPoint Live
http://www.powerpointlive.com
 
Thanks for checking, Geetesh/Kathy.

Firing up a box with 97 installed right now. Hang on ...

Nope. I must be remembering that limit from an earlier version of PPT than 97.

97 blipped a 400 line text file into slides in nothing flat.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Thanks for checking. I didn't think it would fail on the earlier versions,
since it is based on an ancient tip of yours, but wasn't positive.

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived
 
Back
Top