Format Tables

PPT Productivity PowerPoint add-in has 180+ time saving features. Format Tables features include shortcuts to create tables from boxes, convert tables to boxes, paste data into a table without the source formatting, auto table size optimizer and more. PPT Productivity lets you format your tables quickly in PowerPoint!

Paste Excel data without formatting

Paste data into a PowerPoint table format but retain the selected table formatting (so the table appearance is not impacted by data's source formatting). Exported data may be from Excel/ HTML/ CSV (comma, tab, or semicolon separated data).

When you paste Excel data into an existing table in PowerPoint, typically the table formatting is impacted by the data source. Table colors and fonts may change, and data does not paste correctly if there are insufficient columns and rows in the table.

This feature solves these frustrations. Use the 'Paste data as table' feature to paste data into an existing PowerPoint table on your slide and maintain the table's formatting.

  • Clipboard data is added to the selected table, at the selected cell
  • Extra table rows/ columns are automatically added to fit the data (if required)
  • If a subset of table cells is selected, data is only updated in those cells
  • If no table is selected, a new table is created in the default table style (based on your presentation's theme)
Once you have copied your data, click the Ribbon menu to paste, or right-click on a slide or within an existing table to access the special paste from Excel/HTML/CSV commands
Productivity Tip

Paste any type of table data from the clipboard - HTML, CSV, tab separated, semi-colon - or Ctrl+click to specify any other preferred delimiter.


Want to see our tools in action?

Book a personalized demo with our PowerPoint professionals

Book Live Demo

Download 30 Day Free Trial

Download your 30 day free trial - Microsoft Office for Windows

Start Free Trial