3 ways to use Microsoft Copilot with Excel for free, and when to pay

Three distinct no-cost entry points let Irish users try Microsoft Copilot without a paid licence. You can sign in with a free Microsoft account at copilot.microsoft.com, use the Copilot sidebar in Microsoft Edge, or call the Copilot assistant built into Windows 11 or the Copilot mobile app, and then create or export content you open in Excel. At the same time, a fuller Copilot presence inside Excel itself, including the ribbon Copilot button and the new in-cell Copilot function, is described by other guides as tied to a paid Copilot subscription or dependent on tenant-level enablement. Start at copilot.microsoft.com or update Office as described below to test which route suits your needs and workplace setup.

1. Get started: where to find Copilot without paying

First, know that you don't need a paid Microsoft 365 licence to try several Copilot features. A Free Microsoft account is enough to sign in at copilot.microsoft.com and use the web chat for generating text, formulas or short workflows. One practical guide notes that copilot.microsoft.com offers a chat interface that can produce content you then copy into Excel.

Other free entry points exist. On Windows 11, Copilot is integrated into the taskbar, and Microsoft Edge has a persistent Copilot sidebar you can enable via the browser icon. The Copilot mobile app on iOS and Android gives you chat, voice commands and image capture that you can later open on desktop. These routes let you create drafts and exportable content for Excel without paying, according to the same guide.

Example scenario: you are working on an expenses sheet on a laptop without a Microsoft 365 licence. You sign into copilot.microsoft.com with a free account, paste a small sample of your expenses into the chat, ask Copilot to produce a formula that flags expenses over a threshold, and copy the returned formula into your Excel workbook.

2. Moving Copilot output into Excel: copy, export or direct push

Choose the entry route that fits the task. If you want Copilot to write formulas, build pivot tables, make charts, filter or clean data, you can either create the guidance in the web chat or in the Windows taskbar assistant and then copy or export the result into your workbook.

One source spells out this workflow for people who don't have the embedded in-app experience.

Depending on setup, Windows Copilot and the Edge sidebar may provide direct export features that push content into Excel formats, which saves a manual copy-paste. The practical guide that outlines the free routes describes both copy-and-paste from copilot.microsoft.com and the ability in some configurations to export or open output directly in Word, Excel or PDF. That makes it straightforward to produce a formula or step list, and then apply it inside Excel.

Worked example: you open the Edge Copilot sidebar while viewing a table of raw address data on a web page. You ask Copilot to extract a six-digit postal code pattern, export the generated steps or formula, and then open the exported file in Excel to apply the transformation to your column of addresses.

3. The in-Excel Copilot experience and the subscription question

Expect a mix of zero-cost entry paths and paid, in-app features. Another Excel-focused guide describes a deeper, embedded Copilot experience inside Microsoft 365 apps. That account says the visible Copilot button on the Excel ribbon and the new in-cell Copilot function appear only after you subscribe to Copilot or once your tenant has enabled it. The same guide advises updating Office to see those features when they're rolled out to your account.

In practice, that means some Copilot abilities will be available for free via web and system integrations, while the full, contextual in-app Copilot that can write prompts inside cells and point at ranges may require a paid Copilot subscription or tenant enablement. A third source emphasises Microsoft Graph integration and pricing tiers for organisations, which suggests enterprise customers will see a different feature set than individual free-account users.

Worked example: you open Excel after updating Office as advised. If your tenant has enabled Copilot, you may see a Copilot button in the ribbon and the ability to enter a prompt directly into a cell to extract a pattern across a range. If you don't see the button, the Excel-focused guide suggests you may need a subscription or tenant enablement.

4. Update steps to surface Copilot features on your devices

If you prefer the in-app route, make sure Office is fully up to date. One guide instructs Windows users to go to File > Account > Update Options > Update Now, and Mac users to use Help > Check for Updates in Office. Installing the latest Office build is the step that lets your account receive in-app Copilot features when your tenant or Microsoft enables them.

For browser use, open Microsoft Edge and click the Copilot icon to enable the sidebar. For mobile workflows, download the Copilot app from the iOS App Store or Google Play. The practical guide that lists free entry points recommends these update and install steps so you can try Copilot wherever you prefer to work.

Checklist: ensure the following before testing in-app Copilot features.

• Signed in with a Microsoft account at copilot.microsoft.com for web chat use.
• Windows 11 with Copilot enabled in the taskbar for quick desktop queries.
• Microsoft Edge with the Copilot sidebar enabled for browser-based assistance.
• Mobile device with the Copilot app installed for on-the-go capture.
• Office updated via File > Account > Update Options > Update Now on Windows, or Help > Check for Updates on Mac, to attempt to surface in-app features.

Worked example: you follow File > Account > Update Options > Update Now on your work laptop, reopen Excel, and check the ribbon. If you see the Copilot button, test an in-cell prompt with a small range first, because in some environments that button appears only after update and tenant enablement.

Understand the difference between a personal free account and tenant-connected Copilot. The deeper Copilot integrations that reference emails, files and calendar items rely on Microsoft Graph permissions tied to your Microsoft 365 tenant. A third source explains that these permissions enable contextualised responses based on tenant data, which is a core part of the enterprise design for professionals.

If you work in an organisation, administrators will need to assess what Copilot can access. That assessment covers governance and tenant-level controls to limit which data Copilot may draw from. For individual work on a free account, web chat and the Edge/Windows integrations operate against the signed-in account context and don't automatically gain the same tenant-scoped access that an enterprise-connected Copilot receives.

Checklist for IT and end users in a workplace.

• Confirm whether Copilot has been enabled for your Microsoft 365 tenant with your IT administrator.
• Ask what Microsoft Graph permissions Copilot has been given and whether any governance controls restrict access to emails, files or calendar data.
• For sensitive spreadsheets, decide whether to use the free web or mobile entry points for drafting rather than tenant-connected in-app Copilot.

Worked example: your IT team confirms Copilot is enabled in the tenant but restricted from accessing mailbox data. You can use the in-app Copilot button in Excel for workbook tasks that don't require mail context, but you avoid asking Copilot to reference specific emails when preparing a budget spreadsheet containing confidential client correspondence.

Good prompt technique and cautious verification will save time. Guides recommend giving Copilot a concise prompt, a representative data sample and an explicit example of the desired output. Then validate any generated formula or transformation on a test row before applying it across a full dataset to avoid propagating errors.

When Copilot produces formulas, copy them into the formula bar and check cell references, relative versus absolute addressing, and the result type. When Copilot returns a sequence of steps for a pivot table, perform the steps manually the first time to confirm the assistant's instructions match the workbook layout. For repeatable workflows, save the Copilot prompt and the generated formula or macro in a separate worksheet or text file so you can reapply or refine it later.

Verification checklist.

• Test any formula on a single row or a small sample first.
• Confirm ranges and absolute/relative addresses in the formula bar.
• Run through pivot or data-cleaning steps manually the first time.
• Save prompts and outputs in a dedicated worksheet or file for reuse.

Basically, worked example: you ask Copilot to generate a formula that extracts a six-digit code from an address column. Paste the formula into the formula bar for the first data row, verify the result is correct, then apply it to the column only after you are satisfied that row references are correct and the output format matches your needs.

Match your task to the right Copilot entry point.

• Quick formula or text generation for personal sheets: use copilot.microsoft.com or Windows Copilot chat and copy the result into Excel.
• Browser-based data extraction or reworking of web content: use the Edge Copilot sidebar and export into Excel when available.
• On-the-go capture of voice notes or images to be processed later in Excel: use the Copilot mobile app.
• Complex, tenant-aware tasks that combine calendar or email context with workbook data: expect the in-app Copilot inside Excel to be subject to tenant enablement and Microsoft Graph permissions.

Worked example: a project manager needs a weekly status summary made from emails and a workbook. If their tenant has enabled Copilot with Graph access, the in-app Copilot can combine mailbox and file data to draft that summary. If not, they can use copilot.microsoft.com to draft a template using pasted data, and then copy the result into Excel for final shaping.

Related Articles

• Six countries, no royalties: reggae band fights AI remixes
• Berkshire's US$380.2bn cash, patience not panic
• QuTwo hits €325m valuation after €25m angel round

Do this now: sign in with a Microsoft account at copilot.microsoft.com to test the web chat and its export options, or update Office via File > Account > Update Options > Update Now on Windows or Help > Check for Updates on Mac and then look for the Copilot icon on the Excel ribbon. If you work in a managed environment, ask your IT administrator whether your tenant has enabled Copilot and whether a paid subscription is required.

This article was created with AI assistance.