When a spreadsheet system of record still works

Baltej SinghBaltej Singh8 min read
When a spreadsheet system of record still works

A spreadsheet system of record keeps the budget, hiring tracker, or model the team trusts in one place instead of three Excel copies in email. In Nautis that place is Sheets under Profile & Company: New sheet, Import from Excel or Google Sheets, Shared with team, public Share links, cell comments, and autosave with a conflict banner when the sheet changed elsewhere.

Why a spreadsheet system of record still belongs in Sheets

Jumping to a separate spreadsheet app for every model creates version drift. Sheets keeps the list and the editor in one two-pane workspace so the spreadsheet system of record sits next to the rest of the company OS.

Illustrative miss (composite only): three "Q4 budget final" files in Slack; nobody knows which formulas are current.

Illustrative win (composite only): one sheet titled "Q4 cash model"; Shared with team for finance; Share link for the advisor with Allow download off.

You need create permission for New sheet, Import, and Duplicate. Update edits the grid. Delete removes a sheet permanently. Monthly sheet caps count creates, duplicates, and imports. Personal sheets cannot use Shared with team; that needs an organization. Search the left list with Search sheets… when the catalog grows past a handful of Untitled leftovers. Folders (organizations only) beat long flat lists once you have separate finance, hiring, and GTM trackers. Color-coded folders make the filter list scannable during a Monday planning pass. Move finished experiments out of the working folder so the live spreadsheet system of record stays obvious. Keep only one pinned live model per topic so people stop asking which file is real.

Create, rename, and file the sheet before you model

Open Sheets. Click New sheet. An Untitled sheet opens immediately. Rename via the title pencil or ⋯ → Edit sheet: Title (required, up to 160 characters), Description (optional, up to 480), Folder (or Unfiled), Shared with team. Save.

Illustrative create (composite only): Title "Hiring tracker 2026"; Folder People; Shared with team founder plus people lead. Description should name the quarter and owner so Search stays useful months later. Shared with team should list people who edit formulas, not everyone who might glance once. Outsiders get Share links instead of organization seats when they only need periodic access. That split keeps the editor list short and the audit path clear. Add organization members only when they will own formulas week after week.

Pin important sheets from ⋯ → Pin so they stay at the top. Duplicate creates "(title) (copy)" and also counts toward the monthly limit. Delete only after you confirm; there is no undo. Rename Untitled sheet the same day you create it so the list never fills with anonymous grids. Pin the live system-of-record sheet so it stays above dated archives. Archive copies can stay Unfiled or in a Past quarter folder with Pin off. Name archives with the quarter in the Title so Search returns them without cluttering the pin list.

Import and export without leaving the list

Use the upload icon to Import. From system: up to 10 files of .xlsx, .xls, or .csv, each up to 10 MB. From Google Sheets: Connect Google account once, then pick up to 10 spreadsheets. Import inside the editor can replace the open sheet's content. Export from the download icon as Excel (.xlsx) or CSV (.csv).

Illustrative import (composite only): two .xlsx budgets From system; rename both; Shared with team before anyone edits. Export a dated .xlsx before a major formula rewrite so you can compare offline if needed. Do not treat Export as a daily backup habit if the Nautis sheet is already the source of truth. Use Export when counsel or a partner requires a file attachment outside the Share flow. Prefer a Share link for ongoing review; prefer Export for a one-time attachment.

There are no built-in templates yet. Import an existing file when you need a starting layout. Disconnect Google from the same dialog when you no longer need the connector. Keep imports under 10 MB per file. Split oversized workbooks before you upload. CSV imports are fine for flat tables. Prefer .xlsx when you need formatting and multiple sheets from the source file. Batch at most 10 files. Split larger migrations across days if you are near the monthly create limit. Check App usage before a bulk Import so the tenth file does not fail mid-batch.

Edit with autosave, then respect the conflict banner

Type in the grid. Formulas start with =. Work autosaves about 1.5 seconds after you stop typing. The pill shows Saving…, Saved, or Save failed. Press Ctrl/Cmd + S to save immediately. Click Refresh data to pull a teammate's latest version when you both have the sheet open.

There is no real-time co-editing. If the sheet changed elsewhere, a yellow banner appears: This sheet was changed elsewhere. Autosave pauses. Copy any cells you still need, then Reload (or Discard & reload). Keep editing if you must copy first. Guests on an editable Share link can trigger the same banner. Take turns on shared models. Two people typing without Reload is how silent loss happens. Refresh data is the polite check when you only need to read a teammate's latest Saved version. If Save failed with the yellow banner, do not keep typing as if autosave were still live. Copy critical cells first, then Discard & reload, then paste and continue.

Situation

What you see

What to do

You alone edit after a pause

Saved pill

Keep working; Ctrl/Cmd + S if you want an instant write

Teammate saved while you edit

Changed elsewhere banner; Save failed

Copy needed cells; Reload; paste back if required

AI assistant added rows

Same banner

Reload before you overwrite their update

Guest edited via Share link

Same banner

Reload; review their cells before more edits

You need a teammate's view without conflict

Refresh data

Coordinate turns on shared models

Illustrative conflict (composite only): AI adds hiring rows; banner appears; Reload; then adjust formulas on the new rows. The first open in a session may wait while the spreadsheet engine downloads. That delay is normal on a slow link. If the engine fails to load, check the network and CDN access, then reload the page. Mobile can edit, but large models are easier on a desktop screen. Use mobile for quick number checks; use desktop for formula rebuilds.

Click Share. Create new link: Public or Private (password or recipient email). Optional expiry 1, 7, 30, or 90 days, or no expiry. Optional Message. Viewing is always on; Allow comments defaults on; Allow editing and Allow download default off. Create the link and copy it. Manage links to copy, revoke, reset passwords, change permissions, and see view counts. Recipients need no Nautis account.

Illustrative share (composite only): Private password link for an advisor; Allow comments on; Allow editing off; 30-day expiry. Revoke links on Manage links when diligence ends. View counts help you see who still opens the model. Default Allow editing off for investor links unless they must change cells with you. Password Private links beat Public when the model includes cash or headcount detail. Reset the password from Manage links if the link was forwarded too widely.

Comments: open Comments, type, optionally Attach selected cells for a range, then resolve or delete. Guests can comment when the link allows it. Anchor comments with Attach selected cells when the debate is about a specific range, not the whole tab. Resolve threads when the decision lands so the sidebar stays scannable. Reopen a comment only when the assumption behind the cell changed. Otherwise leave the thread resolved so new readers see a clean sidebar.

Keep the list honest with folders, search, and limits

Search sheets… filters by title or content excerpt. Folder filter: All sheets, Unfiled, or a folder. Manage folders for color-coded folders (organizations). Move via ⋯ → Move to folder. When New sheet fails, check create permission and the monthly sheet-creation limit in App usage. Duplicates and imports count toward the same monthly cap as New sheet. Ask an admin when create permission is missing. Do not invent a shadow Google Sheet for the same tracker. The point of a spreadsheet system of record is one live grid, not a new tool every time permission blocks you. Fix permission once, then keep building in Sheets.

A spreadsheet system of record works when one titled sheet holds the live model, Shared with team matches editors, Share links match outsiders, and conflict reloads beat silent overwrites. Retire parallel desktop copies the week the Nautis sheet becomes the live source. A spreadsheet system of record earns trust when conflict banners are respected and Share permissions stay intentional. Review Manage links monthly the same way you review Shared with team on sensitive models. Revoke stale Public links before they outlive the deal that needed them. A short monthly revoke pass is cheaper than explaining an old Public budget link later.

Broader product docs sit in the Help Center. Notes remain separate when the artifact is prose rather than a grid: see Notes.

Sources

Frequently asked questions

Do changes save automatically?

Yes. Sheets autosaves shortly after you stop typing, and the pill next to the title shows Saved. You can also press Ctrl/Cmd + S.

Can two people edit live at once?

Not live. Use Refresh data to see a teammate's saves. If they saved first, the changed elsewhere banner asks you to Reload before your next save.

Can I import Excel files?

Yes. Import .xlsx, .xls, or .csv up to 10 MB each, up to 10 files per batch, or connect Google Sheets and import from there.

Can I share with someone who has no Nautis account?

Yes. Create a Share link (Public, password, or email). Control comments, editing, download, and expiry, then revoke from Manage links when done.

Sources

Baltej Singh
Baltej Singh

Baltej Singh is a serial entrepreneur, technology leader, and Founder & CEO of Nautis and DemoVexa, with over 16 years of experience building software products, SaaS platforms, and startups. Previously the Co-Founder & CTO of SanchiConnect, he has worked extensively in the DeepTech startup ecosystem, connecting with 200+ venture capital firms and supporting a network of 4,000+ startups. Passionate about AI, automation, and entrepreneurship, he focuses on building innovative products that solve real-world problems and help businesses grow.