Format data for Copilot in Excel
Applies To
To use Copilot in Excel, your data will need to be formatted in one of the following ways:
You can then use Copilot to get insights, generate formulas for new columns, and highlight, sort, and filter your data.
Tip: Copilot in Excel will only work on files that have AutoSave turned on.
Format data as a table
You can create a table, or you can convert a range of cells into a table if you have a data range.
-
Select the cell or the range in the data.
-
Select Home > Format as Table.
-
In the Format as Table dialog box, select the checkbox next to My table as headers if you want the first row of the range to be the header row.
-
Select OK.
Keep data as a supported range
If you prefer to keep your data in a range and not convert it to a table, it will need to meet all of the following requirements:
-
Only one header row
-
Headers are only on columns, not on rows
-
Headers are unique; no duplicate headers
-
No blank headers
-
Data is formatted in a consistent way
-
No subtotals
-
No empty rows or columns
-
No merged cells
Note: As we make improvements and updates, requirements may change.
Here's an example of a data range that you could use with Copilot:
More ways to work with data in Excel
Identify insights from numerical data with Copilot in Excel