Use Copilot to find data from the web or your organization and add it in Excel
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for MacWhen you’re creating a table in Microsoft Excel, you may want to pull in data from somewhere else. This is easy and quick with Copilot. You can ask Copilot to add data from:
-
The web
-
Files saved in SharePoint/OneDrive (Word documents, Excel files, PowerPoint files, or PDF files)
-
Other organizational information (emails, meetings, etc.)
No need to disrupt your workflow. Just tell Copilot what data you want and where to find it. It’ll list the data, and then you can insert it into a new sheet in your workbook—or copy it into the sheet you’re working in.
For example, you can ask Copilot in Excel to list purchased devices from a quarterly report that was created in Word. Or maybe you want to get info online—a table of countries and exchange rates perhaps. Maybe you want to use data from another Excel file and you want to make sure that if that file is updated, you’ll see the changes show up in your new Excel file. You can ask Copilot to insert the data, and as long as it comes from an Excel file with a table, you can make it refreshable.
Note: To ask Copilot to add data from files and the web, you must have a Copilot license and a stable internet connection. For web searches, you’ll also need to have Web Search enabled. 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.
Search for data using Excel with Copilot
-
Open Excel.
-
Select the Copilot icon
in the toolbar. -
In the search box, type a prompt such as "search the web for...". See example prompts for more ideas to try.
-
Wait for Copilot to collect the info, and if it’s the data you want, select one of the following options:
-
Insert to new sheet to copy the data into a new sheet.
-
-
The Copy icon () to copy the data into the sheet you're working in.
Import data from Excel files using Excel with Copilot
If your search results include Excel files with tables, you can use Power Query to import the data directly and create a refreshable connection.
-
Open Excel.
-
Select the Copilot icon
in the toolbar. -
In the search box, type a prompt such as "get rates from the file about...". See example prompts for more ideas to try.
Note: You can currently only import data from Excel files with tables—we're working on providing more options. Also, 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 select Show tables to import to see the data.
-
When you see the data, select Import to a new sheet. The table is inserted in the workbook, and you can refresh the table any time to get the most updated data.
Note: If you get an authentication dialog, select Organizational Account and sign in with your user.
Example prompts
Here are some prompts you could use to get info for your spreadsheet:
-
Search the web for a table of countries and their exchange rates.
-
Get ___ from my file about ___ (e.g., "Get device names from my file about Q3 purchases."
-
Find ___ and ___ from my file about ___ (e.g., "Find devices and costs from my file about Q3 purchases.")
-
Find all the employees who report to ___.
-
Search the web for an itinerary for a month trip to Europe in a table format.
-
Search the web for a list of 15 intermediate level vocabulary words in Spanish and their translations.
-
List yesterday's emails in a table, with sender, subject, and importance.
Feedback
We want to hear from you! You can submit your comments and feedback by using the Copilot thumbs up or down buttons, or by selecting Help > Feedback in Excel.
Learn more
Get started with Copilot in Excel