PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
You are here: Home / Design / Charts, tables & diagrams / Create a table from Excel data in PowerPoint

Create a table from Excel data in PowerPoint

February 15, 2015 by Ellen Finkelstein 4 Comments

READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Recently, a subscriber asked me about how to put a table of data from Excel on a slide. You can do this in a couple of ways.

powerpoint-tips-excel-table-on-slide-1 First, think about whether the data will be readable if it will be projected on a screen. Also consider whether the data lends itself to a graph, because graphs can be easier to understand. If you have too much data to fit on a slide, here are 2 options:

  • Divide it up onto multiple slides
  • Provide it as a handout, either printed or electronic

Copy into a PowerPoint table

powerpoint-tips-excel-table-on-slide-2PowerPoint’s tables offer you lots of options for design and layout. If you want the table to look polished, use this option. An easy way to start is with the Title & Content layout. Then click the Insert Table icon in the middle of the slide. You’ll see the small Insert Table dialog box.

PowerPoint's tables offer you lots of options for design and layout. If you want the table to look… Click To Tweet

Go back to your Excel data and count the number of columns and rows you need, including the row and/or column headers. This is also the time to select the table and copy it to the Clipboard. Then return to PowerPoint and complete the dialog box. Click OK to insert the table.

You now see a default table on the slide and the Table Tools Design and Layout tabs appear, as you see here.

powerpoint-tips-excel-table-on-slide-3

Click in the upper-left cell and paste.

For a video tutorial on creating a table, see my earlier post, Create a table in PowerPoint. There you’ll see some ways of formatting the text and the table design.

Here is the table after formatting.

powerpoint-tips-excel-table-on-slide-4

Copy and paste

If you’re in a rush and you don’t care how the table looks, you can simply copy and paste. In this situation, I would use the Title Only layout. Follow these steps:

  1. Select and copy the date in Excel.
  2. In PowerPoint, paste onto a slide.
  3. Resize and move the table to cover most of the slide.
  4. Select all of the content and resize the text — it’s always too small for projecting onto a screen

PowerPoint still creates a table but uses minimal formatting. You can change the formatting using the 2 Table Tools tabs. Here’s a simpler table that I created using this technique.

Simply add a table of Excel data to your PowerPoint slide Click To Tweet

powerpoint-tips-excel-table-on-slide-5

3 orange large asterisksDo you have any additional table tips? Leave a comment!

 

Share9
Tweet
Share18
+12
Shares 29
READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Related posts:

  1. Create a table in PowerPoint
  2. How to Create a Chart-Graph in PowerPoint from Excel Data-Part III
  3. Animate a chart or table
  4. Animate a table or chart in PowerPoint 2007 & later

Filed Under: Charts, tables & diagrams Tagged With: Excel spreadsheet, Excel table, table

4
Leave a Reply

avatar
This comment form is under antispam protection
4 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
4 Comment authors
VinceMoosemanISAM H. SHAKEEREasylivetrade Recent comment authors
avatar
This comment form is under antispam protection
  Subscribe  
newest oldest most voted
Notify of
Easylivetrade
Guest
Easylivetrade

Nice info about data

Vote Up0Vote Down 
6 years ago
ISAM H. SHAKEER
Guest
ISAM H. SHAKEER

You say in the above article the following
PowerPoint still creates a table but uses minimal formatting. You can change the formatting using the 2 Table Tools tabs. Here’s a simpler table that I created using this technique.
My question where I can find 2 Table Tools tabs

With my regards

Vote Up0Vote Down 
6 years ago
Mooseman
Guest
Mooseman

ISAM H. SHAKEER :
There are two (2) table tools tabs (Design and layout) in the ribbon you can use to format the table.

Vote Up0Vote Down 
6 years ago
Vince
Guest
Vince

This is a very nice explanation.

In case that there needs to be more than one table created it is worth having a look at SlideFab. It can create tables from Excel in Powerpoint automatically. Even when there are conditional formats applied, it will take them over as well. E.g. useful for heatmaps without having to set up the colors in Powerpoint manually (http://slidefab.com)

Vote Up0Vote Down 
5 years ago
wpdiscuz   wpDiscuz

Free Video Training!

13 Techniques that Will Make Designing Your Slides EASY!

And get the PowerPoint Tips Newsletter with tips and resources for presenters. Plus 5 bonus tips!

BirdSend Email Marketing Tool
4-up-ads PresenterMedia PoweredTemplate High-Persuasion Secrets Power Pointers Quarter Hour


Recent Posts

Recent Posts

  • Using PowerPoint’s cartoon people
  • Which version of PowerPoint should you buy?
  • Add a customizable, live web feed with Cameo
  • Get a designer look with abstract images to create backgrounds for slides and shapes
  • Creating and using a strong call-to-action slide

Connect with me!

Connect with me! Twitter LinkedIn Facebook

Ellen Finkelstein, Inc. · Fairfield, IA · Tel: 515-989-1832

Privacy, Refund, and Other Legal Stuff

wpDiscuz