Use case
Spreadsheet analysis
Asking questions of tabular data in natural language — totals, trends, outliers, reconciliations — and getting an answer with the calculation behind it. Works best when the model writes code that runs, rather than reading numbers itself.
- Source
- Editorial ontology entry — no fetched document behind this page
- Evidence
- none on this page — it links to the pages that hold it
- Category
- Documents
- Typical risk
- medium
- Entry
- editorial · reviewed 25 Aug 2026
01What this is
Spreadsheet analysis takes a workbook or table and a question, generates the query or code that answers it, executes that code, and returns the result together with the code. The execution step is what makes the answer checkable and reproducible.
A good deployment shows the generated query, runs it in a sandbox with no network access, states the row count and filters applied, and refuses questions the data cannot support. Column meanings are documented once so the model is not guessing what "amt_2" holds.
Pitfalls: models that read a table token by token and arithmetic that is confidently wrong; merged cells and multi-row headers that break parsing; and financial answers with no visible calculation. Files uploaded for analysis often contain personal or financial data and need the same retention rules as any other document.
- Typical data
- spreadsheets, financial records, operational data, customer data
- Solution classes it admits
- Enterprise SaaS, Private cloud, Self-hosted
02Deployment options
- ASSESSMENT
On a neutral reading of this use case, Self-hosted is a strong alternative, Private cloud is a strong alternative and Enterprise SaaS is conditional.
- ASSESSMENT
Read as a generic reading of this page, not a recommendation: no organisation, size, jurisdiction, budget or technical capability has been supplied, so wherever an option depends on one of those, it says "unknown". Ask your own question to get a verdict that accounts for them.
Private cloud
STRONG ALTERNATIVEManaged model API or private model deployment in your cloud account
- ASSESSMENT
Two patterns fit inside one account in a region you name: call a managed foundation-model API such as Amazon Bedrock, Microsoft Foundry / Azure OpenAI, or Vertex AI; or deploy an open-weight model on GPU compute you control. Your application, retrieval layer, storage, identity and logs remain in your cloud boundary in both patterns.
- ASSESSMENT
The managed-API pattern can use closed-source frontier models without buying or operating GPUs. It is usually the fastest way to build a custom workflow, but prompts and retrieved context are processed by the managed service, so model availability, retention, abuse monitoring and regional routing must be checked for the exact feature and endpoint.
- ASSESSMENT
The private-model pattern gives more control over weights, serving and network paths, and can use managed endpoints or your own containers. It also makes your team responsible for capacity, patches, model upgrades, evaluation and failover.
- ASSESSMENT
The cloud provider becomes a data processor in either pattern: you need a DPA, a documented region, and an answer on cross-region routing and where support staff can access the environment from.
- RECOMMENDATION
Start with the managed-API pattern when the workflow is custom but model operations are not the source of competitive advantage; move to private model serving only if evaluation, volume, portability or the data boundary justifies the extra operations. Your stated technical capability is "unknown".
Self-hosted
STRONG ALTERNATIVEOpen-weight models on infrastructure you operate
- ASSESSMENT
Documents, queries and embeddings stay on machines you own, using an open-weight model whose licence you review. For a brief that involves confidential documents and personal data, that removes a model-API vendor from the data path rather than governing that transfer by contract.
- ASSESSMENT
It costs you the operational work instead: a GPU server, Docker, Linux, backups and a patching routine. Your stated technical capability is "unknown", which is the attribute this option most depends on.
- ASSESSMENT
No processor agreement, subprocessor list or cross-border transfer assessment is needed for the model itself, because no third party processes the content.
- RECOMMENDATION
Recommended where local processing is preferred (you did not say so) and the content is sensitive (confidential documents and personal data).
Enterprise SaaS
CONSIDER IFFinished closed-source cloud product with enterprise controls
- ASSESSMENT
This is a complete vendor application, not a model API: examples include an enterprise assistant, coding copilot or document product with the workflow, interface, connectors and administration already built. It can use closed-source cloud models while requiring no model hosting or application engineering from your team.
- RECOMMENDATION
Choose it when the product already performs the actual workflow and its controls meet your requirements. Do not choose it only because its underlying model is strong: a finished SaaS product is less flexible than building against a managed API when your process, integrations or review steps are organisation-specific.
- ASSESSMENT
Vendor commitments are treated as unverified until we have fetched the page that makes them. Until then this option carries questions to ask, not assurances: a signed data processing agreement covering the data you will actually put in; a documented data residency commitment naming the region, in the contract rather than a blog post; a written no-training commitment for your content, including uploads and connected sources; stated retention periods and a deletion path you can exercise; an administrative audit log you can export, and SSO with group-based access control.
- RECOMMENDATION
No jurisdiction was named, so this is the check rather than the conclusion: compare the vendor's stated processing locations and subprocessor list against the cross-border transfer rules wherever you operate before uploading anything.
03Deployment stacks
No deployment stack has been written up for this use case yet.
04Tools by hosting option
Vendor cloud4
- SaaSChatGPT EnterpriseOpenAI’s administered ChatGPT tier with SSO, workspace controls, retention settings, connectors to company systems and business terms that differ from the consumer product.
- SaaSClaudeAnthropic’s assistant, available as a team and enterprise product with SSO, audit logs, project workspaces and commercial terms, and as an API for building applications.
- SaaSGemini for Google WorkspaceGemini features inside Gmail, Docs, Sheets and Meet, grounded in Workspace content under the existing Workspace agreement and admin controls.
- SaaSMicrosoft 365 CopilotAssistant embedded in Word, Excel, Outlook and Teams, grounded in the tenant’s own content through Microsoft Graph and governed by existing Microsoft 365 permissions.
05Compliance hot spots
This use case usually raises personal data, confidentiality, retention, auditability, data residency.
- Personal data
- No published jurisdiction page names this topic yet
- Confidentiality
- No published jurisdiction page names this topic yet
- Retention
- No published jurisdiction page names this topic yet
- Auditability
- No published jurisdiction page names this topic yet
- Data residency
- No published jurisdiction page names this topic yet
06Example questions
Each of these opens the question box with the text already in it. The answer is researched for your organisation, not for this page.
07Related use cases
- DocumentsRFP draftingAnswering tenders and security questionnaires from a library of previous answers. The work is retrieval plus reuse: most questions have been answered before, in a form somebody already approved.
- DocumentsReport generationProducing a recurring document — a management pack, client update, board summary, compliance return — from data and prior text. The template and the data are fixed; the narrative around them is what takes the time.
- DocumentsOCRTurning images of text — scans, photographs, faxes, historic files — into machine-readable text with layout. The step everything else depends on: no extraction, search or classification pipeline is better than the text layer underneath it.
- DocumentsInvoice extractionReading supplier invoices — header fields, line items, tax, totals — into structured records. The extraction step only. What happens to the record afterwards is invoice processing automation.
- DocumentsDocument classificationSorting incoming documents into types and routing them — which team, which folder, which workflow, which retention rule. Usually the first step of a larger pipeline and the cheapest place to remove manual handling.
- DocumentsData extractionPulling defined fields out of unstructured text into a schema — from forms, reports, emails, filings or web pages. The general case of invoice extraction, and the step that turns documents into something a database can hold.
Improve this page
Sign in to contribute
From the field
0 deployments · 0 questions
Nobody has reported deploying this here yet, and no question has been opened against this page. Both appear once a reviewer accepts them.