Page 3 of 14PREVNEXT

Share Excel data with others by exporting it to a SharePoint site

Excel table

Excel data formatted as a table.
Callout 1 Alternate shading on rows.
Callout 2 AutoFilter arrows on columns.

To export the list of names to your SharePoint site, you start in Excel, where you'll get the data ready to export. To do that, you convert the data to an Excel table. This changes how the data looks by adding table formatting, but more important for now, it allows you to export data to your SharePoint site.

Put the cursor in the data. On the Insert tab, in the Tables group, click Table. After you click OK, Excel adds alternate shading on the rows of data and AutoFilter arrows on the columns. You don't need to do anything with the AutoFilter arrows. They are just part of what makes up a table.

Note     There are benefits to tables beyond using them to export data. To learn more about tables, see Demo: Organize your data by using an Excel table.

Page 3 of 14PREVNEXT