Import data from the web and internal sources with Copilot in Excel

When 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.)

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 and import data

Open Excel.
From the Home tab, select the Copilot button in the toolbar.
Select the Manage content preferences globe icon. Make sure the Web content toggle is in the On position so that you have access to content from the web.
In the Copilot pane, ask Copilot to find the data you're looking for. You can copy and paste some of the example prompts, or create your own.
Copilot takes a moment to collect the data.
If the data that Copilot found is what you want, select Insert to new sheet to copy the data into a new sheet. To add the data into your current sheet, select the Copy icon and paste the data where you want it.

Search for data with prompts like:

Icon depicting a document with sparkles Search the web for a table of countries and their exchange rates.

Icon depicting a document with sparkles Get (blank) from my file about (blank).

Icon depicting a document with sparkles Find all the employees who report to (blank).

Icon depicting a document with sparkles Search the web for a list of 15 intermediate level vocabulary words in Spanish and their English translations.

Icon depicting a document with sparkles 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. 

More ways to create with Copilot in Excel

Get started with Copilot in Excel

Import data from other Excel files with Copilot in Excel

Create PivotTables with Copilot in Excel

Import data from the web and internal sources with Copilot in Excel

Search for and import data

Search for data with prompts like:

Feedback

More ways to create with Copilot in Excel

Need more help?

Want more options?

Was this information helpful?

Thank you for your feedback!