PPT Productivity PowerPoint add-in has 100+ 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
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). 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)
Paste any type of table data from the clipboard - HTML, CSV, tab separated, semi-colon - or Ctrl+click to specify any other preferred delimiter.