Citing a spreadsheet: why our SharePoint AI names the sheet and the rows, not the file

We run an AI assistant over a construction company's SharePoint: 865 sites, about 400,000 documents. For a year it answered from PDF and Word only. This month we added Excel and PowerPoint. The extraction took an afternoon. The citation format took the real thinking, and that is what this post is about.

An answer from a document assistant is only worth something if the reader can check it. For PDF that is easy: cite the page, the reader opens page 37 and compares. For a workbook, a link to the file is not a citation. Twelve sheets, four thousand rows, and the reader is expected to find the one cell the model used. Nobody does that. They either trust the number blindly or ignore the assistant. Both are bad.

So the rule we set: every citation must let a person verify the answer in seconds. Page for PDF. Sheet and row range for Excel. Slide number for PowerPoint.

We read workbooks with openpyxl in read-only mode and walk each sheet row by row. Rows are grouped into chunks, and each chunk carries where it came from:

chunk = { " text ": "... ", # the rows, rendered as text " source_name ": " Budget_2026.xlsx ", " sheet ": " Q3 ", " row_from ": 118, " row_to ": 142, " doc_version ": " 4.0 ", " modified ": " 2026-09-30T08:12:00Z ", } Enter fullscreen mode Exit fullscreen mode Three details that mattered in practice:

For PowerPoint the slide number plays the role of the page: title, text frames, tables and notes are read slide by slide, and the citation names the slide.

The answer shows the source name, the sheet and the rows, and a link that opens the file in SharePoint. If content approval is enabled on the library, the approval status is shown too, because a draft workbook and an approved workbook can contain different numbers for the same thing.

This is the same contract we already had for PDF: document, version, exact location, and, through the signed-in user's own permissions, only documents that person may open.

Because a fluent answer from the wrong place is worse than no answer. A reader who can check in seconds will check, and will catch the model when it picks the draft or the old version. A reader who cannot check will either stop trusting the tool or, worse, keep trusting it.

I wrote up the full set of checks we apply before an answer can be trusted, with the SharePoint and Graph details behind each one: Copilot, SharePoint and 400,000 construction documents: four checks before you trust an AI answer.

The assistant is Answergrove, built at SIA KSJ in Latvia. It runs alongside Microsoft 365 Copilot and does not need a licence per user.