Excel - Create what Excel refers to as a 'table'

An Excel table is a pre-formatted view of the content that allows easy filtering of each column. It is a way in Excel to further specify a range of data within a spreadsheet.

It would be great if we had an action that populates an Excel spreadsheet with data, formatted as an Excel table. I have had users who receive an Excel report from one of my Catalytic automations and the first thing they need to do is "Format as a table" in Excel so they can begin using the filters. We should be able to set that up for them, in advance. When exporting data from Oracle into a spreadsheet, as an example, it is already formatted as a table.

Additionally, Sharepoint requires data to be formatted as a table in order to import it into a Sharepoint list (future idea :smile: for improvement, once this is implemented).

5 votes

Swept · Last Updated