Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

To use another Excel file as a data source for import, you must select a table.

  1. Click a table in the Select Data dialog box to select it. You can only pick one.

  2. Select or clear the First row of data contains headers depending on the table you chose.

  3. Click OK to confirm your choice, or Cancel to exit without making a choice.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.