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.
How to import data from another Excel file
Open Excel.
To open Copilot, select the Copilot icon in the lower-right corner of Excel, or select Home > Copilot on the ribbon.
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.
Prompt ideas for importing data from another Excel file
Get device names from my file about Q3 purchases.
Find devices and costs from my file about Q3 purchases.