Sometimes you might need to import data from one Excel workbook into another. With Copilot in Excel, you can use Power Query to import the data directly and create a refreshable connection.
Note: To ask Copilot to add data from files, you must have a Copilot license and a stable internet connection. For Enterprise searches, you’ll need to verify if Restricted Search is active. You’ll also need one of the following: Excel for Windows (16.0.16731.10000 or later), Excel for Mac (16.76.729.0 or later), or Excel for the web​​​​​​​. You can get more details on licenses for consumers and for businesses. 
Import data from another Excel file
-
Open Excel.
-
From the Home tab, select the Copilot
-
In the Copilot pane, ask Copilot to find the data that you need. You can copy and paste one of the example prompts, or type something in your own words. Â
Note: You can currently only import data from Excel files with tables—we're working on providing more options. Import is currently only available for Excel for Windows or Mac. We plan to make it available for Excel for the web soon as well.
-
If there are multiple results, review them and select the one you want to use. You can choose Show tables to import to see the data that Copilot found.
-
When you see the data you want, select Import to a new sheet. Copilot inserts the table in your workbook.
-
Refresh the table any time you need to get the most updated data.
Note: If you get an authentication dialog, select Organizational Account and sign in.
Search for data with prompts like:
|
|
|
|
More ways to create with Copilot in Excel
Import data from the web and internal sources with Copilot in Excel
Create PivotTables with Copilot in Excel
​​​​​​​Generate a formula column with Copilot in Excel
