Use 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. You can ask Copilot to add data from:

  • The web.
  • Files saved in SharePoint or OneDrive (Word documents, Excel files, PowerPoint files, or PDF files).
  • Other organizational information (such as emails and meetings).

For more information about the data sources used by Copilot in Excel, see Copilot in Excel data sources.

How to search for and use data

  1. Open Excel.
  2. To open Copilot, select the Copilot icon in the lower-right corner of Excel.
  3. 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.
  4. Copilot takes a moment to collect and then insert the data.

Prompt ideas for using data from the web or internal sources

Search the web for a table of countries and their exchange rates.

Get <outliers> from my file about <costs>.

Find all the employees who report to <manager>.

Search the web for a list of 15 intermediate level vocabulary words in Spanish and their English translations.

List yesterday's emails in a table with sender, subject, and importance.