Catalogue · Excel and data with AI

Pull data from another workbook

You import data from another OneDrive file and cross-check it with your table.

ExcelAdvanced0:44Capsule 9 of 11

SkillKapsul

The steps

The exact sequence, in order.

01
In Allow editing mode, name the source file in your request.
02
Check the list of suggested sources and keep only the right one.
03
Check the new imported sheet.
04
Ask your question to cross-check the two tables.

The prompt to copy

Word for word, exactly as shown in the video.

Get the stock for each item by warehouse from my file named Display stock – warehouse.xlsx.

The habit to keep

Before importing, always check the list of sources.

Related capsules

You might also like

Open Copilot in Excel and pick a mode

You open Copilot in Excel and pick the right mode: edit, plan or just answer.

Ask your table a question

You ask your table a question in your own words and get the answer, without changing anything.

Clean up a table in one click

You fix inconsistent text and extra spaces in a list typed by hand.

Newsletter

Monday's capsule

One skill a week, straight to your inbox. The easiest way to keep learning without thinking about it.

Your data stays in the EU. Never sold.