Format a table in Excel and naming tips

In Power Apps, you can create a canvas app based on Excel data only if it's formatted as a table. By following this content, you'll learn how to format a table in Excel and some tips of naming Excel columns.

How to format a table in Excel

You can convert your data to a table by selecting Format as Table in the Home tab of Excel.

Excel format a table

You can also create a table by selecting Table on the Insert tab.

Excel insert a table

To find your table easily, go to Design under Table Tools, and rename your table. It's useful to give your table a meaningful name, especially when the same Excel file contains more than one table.

Excel rename a table

Naming tips in Excel

If a column in your table contains images, include "image" in the name of that column. This keyword will bind that column to an image control in a gallery.

Connect Excel table with images

Next steps

  • Generate an app from Excel in Power Apps based on a table that you specify. The app will have three screens by default: one each for browsing records, displaying details about a single record, and creating or updating a record.
  • Create an app from scratch using the table you format in Excel. You can manually create and customize your app to display, browse, or edit the data in your table.

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).