A data room handles a signed contract easily: it is a PDF, people read it, nobody needs to edit it. A financial model is different. Its value lies in the formulas and assumptions, and the buyer’s analysts want to stress-test them. That tension makes spreadsheets the most argued-over files in many processes.
This guide covers how platforms display Excel files, what can leak through a workbook, and how to choose a setting for each group.
Sharing a financial model in a data room: four options compared
How do data rooms display Excel files?
Most modern data rooms render spreadsheets in a secure browser viewer. The reviewer sees a grid of cells, can switch between visible sheets and scroll, but cannot copy, save or print unless the group is allowed to. Watermarks with the viewer’s name and the time are typically overlaid.
Older or simpler platforms convert spreadsheets to PDF on upload. The reviewer sees pages of values. Formulas disappear, wide sheets get split across pages, and the result is often hard to read. It is safe, but it is rarely what an analyst wants.
What you should confirm in a trial:
- Do formulas show in the viewer’s cell bar, or only values?
- Are hidden sheets, rows and columns kept hidden, or does the viewer reveal them?
- Do very wide or long sheets render fully?
- Are charts and conditional formatting preserved?
- Does search index cell text, and does it index hidden sheets? Our article on data room search and OCR explains why that matters.
What can leak from a spreadsheet?
More than most sellers expect. A workbook built over months inside a finance team often carries:
| Hidden content | Why it matters | Fix before upload |
|---|---|---|
| Hidden sheets with old scenarios | A buyer sees the downside case you dropped | Delete, do not just hide |
| Formulas linked to other files | File paths reveal internal servers, names and other projects | Break links, paste values where needed |
| Comments and notes | Internal debate about numbers, sometimes candid | Remove all comments |
| Document properties | Author names, company, previous titles | Clear metadata |
| Named ranges and pivot caches | Can hold source data you thought was summarized | Refresh or remove caches |
| Very hidden sheets | Not visible in the normal unhide menu | Inspect with the workbook inspection tool |
Excel’s built-in document inspection tool finds most of this. Run it on every workbook before it goes into the room, and keep the uninspected original outside.
Hiding is not deleting
A hidden sheet is still in the file. If any group can download the workbook, assume hidden content will be found. If the viewer itself reveals hidden sheets, even view-only groups may see it.
Should buyers be allowed to download the financial model?
Usually, yes, for one group at the right stage. A serious buyer’s financial adviser needs to rebuild projections, run sensitivities and test the working capital calculation. A view-only grid does not allow that.
A sensible sequence:
- First round: view-only for all bidders. They can read the numbers and ask questions.
- Second round: protected or plain download for the shortlisted bidders’ financial advisers only.
- Confirmatory stage: download for the preferred buyer’s advisers, with the latest version.
Track the downloads. The audit trail should show which user downloaded which version and when. For the settings behind each option, see our guide to downloading from a data room.
What is a protected download?
Some platforms offer document rights control (DRM) for downloaded files. The workbook leaves the room but stays wrapped: it may open only in an approved application, carry a watermark, and lose access when you revoke it, even on the buyer’s machine.
It sounds like the best of both worlds, and for many files it is. For spreadsheets there are trade-offs. Protected files can limit what Excel features work, may not open on every operating system, and can frustrate analysts who need to link the model into their own workbooks. Ask the buyer’s adviser before you choose it; a protection that pushes them to retype the numbers by hand helps nobody.
DRM is on our feature checklist and is listed for most dedicated data rooms in our dataset, including Ellty, iDeals, Datasite and Intralinks. How it handles Excel specifically is worth checking in a trial.
Which option suits which file?
| File | Suggested setting | Reason |
|---|---|---|
| Three-year audited accounts | View-only or PDF | Final, signed numbers; no need to rework |
| Management accounts and KPIs | View-only, download for advisers later | Buyers will want trends in their own format |
| Operating model with projections | Protected or plain download for shortlisted advisers | The core of financial diligence |
| Customer-level revenue data | View-only, or anonymized download | Commercially sensitive, often subject to clean team rules |
| Payroll and HR data | View-only for a restricted group | Personal data; minimize copies |
| Cap table | View-only, download at confirmatory stage | Needs reconciling with legal documents |
How should you prepare a model before upload?
Prepare a dedicated data room version, never the live working file:
- Save a copy named for the room, with a version date.
- Delete hidden scenarios, scratch sheets and old tabs.
- Break external links and replace them with values or bring the source data in.
- Remove comments and clear document properties.
- Add a cover sheet that explains structure, sources and key assumptions. It cuts down on Q&A.
- Lock input cells if you want buyers to see but not easily change your assumptions.
When you update the model, upload the new version so the room keeps history, and post a note in Q&A so every group knows.
Do spreadsheets affect how we score data rooms?
Spreadsheet handling feeds into everyday usability and security posture in our scoring: how well files render for reviewers, and how much control the seller keeps over downloads. We base this on what providers document about their viewers and rights control, plus the checks above that any buyer can run in a trial. See our review method for the weights and our reviews for each provider’s feature map.
Frequently asked questions
Can you view Excel files in a data room without downloading them?
Yes. Most modern data rooms render spreadsheets in a secure browser viewer with watermarks. Some older platforms convert them to PDF instead, which loses formulas and can split wide sheets across pages.
Can buyers see formulas in a data room spreadsheet?
It depends on the platform and the setting. Some viewers show formulas in the cell bar, some show values only. If formulas are sensitive, check in a trial and consider pasting values in a data room copy.
Are hidden sheets safe in a data room?
No. A hidden sheet remains in the file and can be revealed by anyone who downloads it, and some viewers display it. Delete content you do not want seen rather than hiding it.
Should I let bidders download the financial model?
Usually only the shortlisted bidders' financial advisers, at the second round or later. Use view-only before that, and track every download in the audit trail.
What is the best way to share a financial model securely?
Prepare a cleaned data room copy, share it view-only by default, and allow a protected or plain download only to the group that needs to rework it. Keep the audit trail as your record.