Pinterest Pixel

How to Use Add Content in Copilot for Excel: 5 Easy Steps

John Michaloudis
Microsoft Copilot can be used to include content in the Excel workbook.
You can pull information by uploading images and files and attaching cloud files.

In this article, you will learn how to use the Add content in Copilot for Excel.

Microsoft Copilot can be used to include content in the Excel workbook. You can pull information by uploading images and files and attaching cloud files. In this article, you will learn how to use the Add content in Copilot for Excel.

Key Takeaways:

  • The Add content option is available from the Add (+) menu in the Copilot pane.
  • You can upload images and files to provide more content.
  • You can attach cloud files when relevant to your request.
  • Added content can provide Copilot with more context for your prompt.
  • Always review the response provided and workbook changes made by Copilot before using the results.

 

Introduction

When using Copilot in Excel, the information in the current workbook may not always provide enough context for your request. You may have information in another file or image that is relevant to the task.

The Add content option lets you provide this information directly in the Copilot pane. For example, you may want to add:

  • An image containing information you want Copilot to work with
  • A file containing supporting information
  • A cloud file related to the workbook or task

Instead of manually typing all the supporting information into your prompt, you can use Add content to include relevant material and then tell Copilot what you want to do with it.

 

How to Add Content in Copilot

Add Content

STEP 1: Open a new or existing Microsoft Excel.

STEP 2: Go to the Home tab and select the Copilot button.

Add Content in Copilot for Excel

STEP 3: In the Copilot panel, select the Add (+) menu.

Add Content in Copilot for Excel

STEP 4: Select Add content.

Add Content in Copilot for Excel

STEP 5: Copilot searches the content and inserts it into the worksheet.

Add Content in Copilot for Excel

Upload Images and Files

The Upload images and files option lets you add supporting content directly to your Copilot request. You can use this option when the information you need is stored outside Excel. After adding the content, enter a prompt explaining what information you want Copilot to work with.

Add Content in Copilot for Excel

The more specific the prompt, the clearer the intended task.

Attach Cloud Files

The Add content menu also provides an Attach cloud files option. You can use this option when the supporting content is stored as a cloud file rather than being uploaded directly from your device.

After attaching a relevant file, tell Copilot how you want the information to be used.

 

Tips & Tricks

  • Add only content that is relevant to the task you want Copilot to perform.
  • Clearly tell Copilot how the added content relates to the workbook.
  • Mention the specific information you want Copilot to find or work with.
  • Use detailed prompts instead of broad requests.
  • Review Copilot’s output before relying on the information or saving workbook changes.

 

FAQs

1. What is Add content in Copilot for Excel?

Add content lets you provide extra information, such as images or files, that Copilot can use as context for your request.

2. What type of content can I add to Copilot in Excel?

You can add images and files or attach relevant cloud files to provide additional context.

3. How do I add a file to Copilot in Excel?

  • Open the Copilot pane
  • Select the Add (+) menu
  • Choose Add content
  • Select the appropriate option for adding your content.

4. Why should I add content to a Copilot prompt?

Adding content can be useful when the information Copilot needs is not available in your current workbook. It gives Copilot more context for understanding your request.

5. What should I do after adding content to Copilot?

Enter a clear prompt explaining what you want Copilot to do with the added content. Be specific about the information you want it to find, summarize, or organize.

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to View and Delete Copilot Chat History in Excel

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...