Copilot
Copilot in Excel
Copilot in Excel
Import data from the web and internal sources with Copilot in Excel
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac

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

  1. Open Excel.

  2. From the Home tab, select the Copilot small image of the Copilot icon. button in the toolbar.

  3. 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.

  4. 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.

  5. Copilot takes a moment to collect the data.

  6. 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

Facebook LinkedIn Email

Need more help?

Want more options?

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

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center