
Spreadsheet Server is an insightsoftware Excel add-in that pulls live general ledger and subledger data from 140+ ERPs and data sources into formula-driven reports, built for mid-market controllers and finance teams on systems such as JD Edwards, Oracle, SAP and Infor.
Independently scored, one dimension at a time. Every dimension is sourced, and we say whether a claim is published, reported, or estimated.
Written by the Audit Friendly research team. No vendor edits, no sponsored placement.
What you are really buying is a Windows Excel add-in plus an admin console. Formulas such as GXL, GEXD and GEXQ return balances and query results from your ERP, and any number drills down to journals and subledger detail. Distribution Manager and Profile Scheduler refresh workbooks and send them by email or to SharePoint on a schedule. Query Designer, on the Platinum license, builds queries over any relational database. insightsoftware says it connects to 140+ data sources and served over 2,000 manufacturing and distribution customers in May 2025.
The catch is scope. Spreadsheet Server reports on actuals; it has no driver-based models, scenarios or workforce planning, so budgets come from ERP budget tables or a separate product such as Bizview. It needs desktop Excel 365 on Windows, and cloud ERPs such as Sage Intacct reach it through insightsoftware's Cloud Connector, which replicates data on a schedule. There is no public API or MCP server. Since 16 June 2026 insightsoftware has also marketed Reporting Intelligence, a cloud product, as the upgrade for Spreadsheet Server customers.
Confirm in writing before signing: the price of each license key tier (Silver or Limited, Gold, Platinum) and whether Query Designer is included; whether you are on Platform, subscription license key or maintenance licensing, since that decides which AI features you get; the renewal cap; how often the Cloud Connector replicates your cloud ERP; and how long insightsoftware commits to support Spreadsheet Server alongside Reporting Intelligence.
Jobs, mapped to how finance teams actually buy.
Forget the 40-row feature grid. Pick a finance workflow and see how this tool and its closest peers actually do it, with our verdict on who wins for whom.
Here's what it really costs: published rates where a vendor lists them, aggregated quote data where they don't, plus a path to your own number.
Scored on what an outside agent can actually reach: the documented API, how it authenticates, and whether the vendor ships an MCP server.
Exists: No. Spreadsheet Server's product page, its v25 help center, the v26 release notes and the official MCP registry (searched for insightsoftware, Lineos and Spreadsheet Server on 1 November 2026) show no first-party MCP server, and no public insightsoftware MCP repository turned up on GitHub. Sister brand Simba markets governed API and MCP access to enterprise data through Simba Intelligence, a separate product that the Spreadsheet Server docs do not mention.
Scope: None for agents. No public REST API is documented. The Platform Login API Key added in version 25.1 is a sign-in method for Profile Scheduler jobs. The add-in runs inside desktop Excel and queries ERP databases, or Cloud Connector replicas, with credentials an administrator stores in Application Configurator.
Turnkey: Not applicable. An agent can only work with workbooks or exports that people save from Spreadsheet Server.
In-product AI: Doc Assist answers product-help questions from insightsoftware documentation, and Data Assist summarises trends and anomalies in report data. Per the v25.4 release notes (10 December 2025), Platform customers get both, regular subscription license key customers get Doc Assist only, and maintenance customers get neither; admins can disable either. Threshold alerts and autonomous insights sit in Reporting Intelligence, a separate cloud product launched 16 June 2026.
ERP & data connectivity
Breadth is the core strength: 140+ data sources, direct database connections to systems such as JD Edwards, Oracle EBS, SAP, Infor, Epicor, Yardi and MRI, a direct Snowflake connection since v25.4 (10 December 2025) and Infor M3 Cloud since May 2025. Cloud ERPs such as Sage Intacct run through scheduled Cloud Connector replication, and write-back is JD Edwards only.
Implementation
The vendor says most customers build reports within days. The getting-started page lists four steps: IT supplies connection details, users install the add-in, teams build reports with guided emails and videos, and support helps from there. Cloud ERPs add a Cloud Connector replication setup, and Sage Intacct also needs Web Services sender credentials from insightsoftware (v25 docs).
Support
Customers get a community portal for support cases, help articles, enhancement ideas and new versions, which arrive typically each quarter (getting-started page). insightsoftware runs virtual courses and two-day regional classes in Raleigh and Denver, with 7 CPE credits per training day as a NASBA-registered sponsor. Training is priced on request, and partners such as HIT Technology and RPI Consultants also host Spreadsheet Server sessions.
Scalability
The product page claims 140+ ERP connections, and the May 2025 release cites over 2,000 manufacturing and distribution customers. Scale is bounded by Excel and the ERP: v25.4 added GXL batch execution to avoid SQL timeouts in larger workbooks, and v25.4.3 lets admins lock timeouts that can affect transactional system performance. Every user needs a local install on Windows.
Compliance depth
insightsoftware's trust page (checked 1 November 2026) describes company-level SOC 1 Type 2 and SOC 2 Type 2 audits and says only that specific products meet ISO 27001; none of it names Spreadsheet Server, which runs as desktop software. Product controls are admin-level: license keys per user, Accounts Profiles, profile encryption and password-locked timeouts (v25.4.3). The Accounts Profile does not apply to Infinium, JD Edwards or Oracle ledgers, and there is no plan versioning or budget approval workflow, since the product holds no plans.
Modeling depth
Spreadsheet Server feeds actuals and budget data into Excel models that your team builds; it has no driver-based engine, scenarios, rolling forecast logic or workforce module of its own. Write-back is limited to Spreadsheet Writeback for JD Edwards (installation docs), and planning sits in separate products such as Bizview.
Pricing transparency
No prices are published; the Request a Price page asks for a form, and ERP Research reports the same (checked 1 November 2026). The only public structure is one license key per user (Application Configurator docs) and the Silver or Limited, Gold and Platinum tiers named in a training FAQ. No public benchmark isolates this product.
AI / agent readiness
No first-party MCP server and no public API turned up in insightsoftware's site, the v25 help center, the official MCP registry or GitHub on 1 November 2026. In-product AI is Lineos Doc Assist (product help) and Data Assist (trend and anomaly summaries), and the v25.4 notes limit Data Assist to Platform customers and give maintenance customers no AI at all.
NE-XT Technologies runs Spreadsheet Server on Epicor. insightsoftware's case study quotes its CFO saying a one- to two-day manual process now produces financials in under 5 minutes. The figure is vendor-claimed.
American Asset Corporation reports to lenders and investors from Yardi Voyager. insightsoftware's case study says reports that took 30 days to create now take 3. The number is vendor-claimed.
Driven Brands combined Oracle Cloud data with point-of-sale and data lake sources in Excel. insightsoftware's case study says an AR process that took two days now takes one to two hours. The outcome is vendor-claimed.
Distribution Manager builds email, print or file-archive jobs, and Profile Scheduler runs them on a timetable. insightsoftware's 25.3 webinar page adds SharePoint locations and names monthly board packets as a use.
Query Designer is a visual tool for building queries over any relational database, then combining them with GL formulas in one sheet. insightsoftware's training FAQ ties it to the Platinum license.
Spreadsheet Server Webinar - Hosted by HIT Technology - July 2026
A partner-hosted webinar, run with insightsoftware on 7 July 2026, on turning SYSPRO ERP data into Excel reports with Spreadsheet Server. It is the most recent long-form look at the product in use with a mid-market ERP. Runs 52:46, posted 13 July 2026, about 20 views. HIT Technology co-hosted it with insightsoftware, so treat it as a sales session. Transcript not read.
Spreadsheet Server for Oracle NetSuite Overview
An official overview of reporting on NetSuite data directly in Excel with drill-down. Relevant for NetSuite teams weighing Spreadsheet Server against NetSuite-native reporting tools or Reporting Intelligence. Runs 2:20, posted 6 June 2024, about 700 views. It is a short vendor overview, so confirm the NetSuite connection method and refresh timing in writing. Transcript not read.
Spreadsheet Server's AI Assistant
Shows the AI Assistant on the Spreadsheet Server ribbon, covering Doc Assistant help and data analysis of report figures. A finance lead can see how far the in-product AI goes before relying on it. Runs 2:41, posted 23 October 2024, about 1,000 views. Vendor-made and two years old, so check current license limits on AI features. Transcript not read.
Query Designer - Spreadsheet Server
An official demo of Query Designer, the visual tool for designing, maintaining and running queries that feed Excel. It matters to buyers deciding whether they need the Platinum license. Runs 7:14, posted 21 January 2025, about 3,000 views. Made by the vendor; the Platinum license requirement is stated in insightsoftware's training FAQ. Transcript not read.
Product Flyover - Spreadsheet Server
A short official tour of real-time reporting from 140+ ERPs in Excel, with refreshes, ad hoc inquiries and drill-down. Useful for a quick sense of the interface before a demo call. Runs 2:23, posted 31 July 2024, about 563,000 views. It is vendor marketing, so pricing and setup effort need a sales call. Transcript not read.
Spreadsheet Server 101
An official walkthrough of building a first report with Spreadsheet Server formulas against live ERP data. It is the quickest way for a controller to judge whether the formula approach suits the team. Runs 7:32, posted 28 March 2025, about 6,300 views. Made by insightsoftware, so it presents the vendor's own workflow; check installation and connection needs separately. Transcript not read.
Compliance depth
No product-specific SOC report or ISO certificate is named; controls are per-user license keys, account profiles, profile encryption and admin locks.
Scalability
Claims 140+ data sources and 2,000+ manufacturing and distribution customers; bounded by Excel and ERP load, with batch execution added in v25.4.
AI / agent readiness
No MCP server or public API; Lineos Doc Assist and Data Assist work in-product, and maintenance licenses get no AI (v25.4 notes, Dec 2025).
Support
Community portal for cases and quarterly releases; virtual courses and two-day regional classes with 7 CPE credits per day; training priced on request.
Implementation
Vendor says most customers build reports within days; IT supplies connections, each user installs the add-in, and cloud ERPs need replication.
Pricing transparency
Quote only; one license key per user, with Silver or Limited, Gold and Platinum tiers named only in a training FAQ. No product benchmark.
Modeling depth
Feeds actuals and budget data into your Excel models; no driver-based engine, scenarios or workforce module, and write-back is JD Edwards only.
ERP & data connectivity
140+ sources with direct database links to JD Edwards, Oracle, SAP, Infor and Epicor; Snowflake direct since v25.4; cloud ERPs via replication.
AF Score
Audit Friendly score for Spreadsheet Server across eight dimensions, 5 November 2026.
Data sources
ERP and data source connections claimed on the Spreadsheet Server page, checked 1 November 2026.
Mfg and distribution customers
Spreadsheet Server customers in manufacturing and distribution alone, per insightsoftware's 16 May 2025 Infor M3 Cloud release; a segment count, not the product total.
Silver or Limited license
Entry license named in insightsoftware's training FAQ; Gold and Platinum add features beyond it.
Gold license
GL reporting functionality, the level covered by the two-day Regional GL training.
Platinum license
Adds Query Designer for custom queries over any relational database, covered by Regional QD training.
Platform licensing
Licensing model that includes AI Doc Assist and Data Assist and platform data sharing with Angles business views (v25 docs).
Training (virtual or regional)
Instructor-led courses on GL and Query Designer; regional classes run two days in Raleigh or Denver. Pricing on request.
Reporting Intelligence upgrade
Separate cloud product (Essential and Professional packages) offered to current Spreadsheet Server customers.
Windows desktop Excel only
The v25 system requirements list Windows 11 or Windows Server 2016, desktop Excel 365, .NET Framework 4.8 and an Access Runtime (checked 1 November 2026). Off-premises data stores may need a VPN. The installation docs say Excel's legacy Shared Workbooks feature is not supported. Browser and Office Online access is sold in Reporting Intelligence, a separate product.
Cloud ERPs are replicated on a schedule
The Sage Intacct Cloud Connector guide states that cloud ERPs need API consumption that Spreadsheet Server cannot provide directly, so the Cloud Connector replicates tables to a cloud database on a replication schedule. The connector is available from v25.4 (10 December 2025), and Sage Intacct customers without a Web Services license need sender credentials from insightsoftware. Ask how fresh the replica will be at close.
AI features depend on your license
The v25.4 release notes (10 December 2025) say Platform customers have AI Doc Assist and AI Data Assist, regular subscription license key customers have Doc Assist only, and maintenance customers have no AI features. Admins can disable either feature. Check which licensing model your quote uses.
insightsoftware is steering customers to Reporting Intelligence
insightsoftware launched Reporting Intelligence on 16 June 2026 as a cloud product that connects ERP data to Excel with AI alerts. Its product page offers an Upgrade path for current Spreadsheet Server or Jet Reports customers, and an insightsoftware brochure page calls it the natural upgrade. The Spreadsheet Server page pitches it to companies on NetSuite, Oracle Cloud ERP, Infor FSM or Infor M3, and the Reporting Intelligence page says it connects to cloud ERPs, with more added on a rolling basis (checked 1 November 2026). Spreadsheet Server is still sold and updated (v26.3.1 shipped 21 October 2026), but ask for the support horizon in writing.
No planning engine
Spreadsheet Server returns actuals and stored budget data into Excel; it has no driver-based models, scenarios or workforce planning. Write-back is Spreadsheet Writeback for JD Edwards only, per the v25 installation docs. insightsoftware positions Bizview, a separate product, for Spreadsheet Server users who want automated planning.
Account-level security has gaps
The v25 Account Security article says an Accounts Profile controls which account strings a user can see, but it does not apply to Infinium, JD Edwards or Oracle ledgers, nor to queries in Query Designer or Excel. On those systems, row-level restrictions must come from ERP or database permissions. Confirm the design with your auditors before rollout.
Spreadsheet Server v26.3.1 released
Adds silent MSI installation and a custom password for Administrator Timeout Controls, and fixes Expand GL Row totals, protected workbook refresh and Cloud Connector sign-in prompts.
Spreadsheet Server v26.2.1 released
Fixes NetSuite GXL balances, Oracle EBS binding variables, duplicate SAP logins in Query Designer and installs that use Platform Storage.
insightsoftware launches Reporting Intelligence
A cloud reporting product that connects ERP data to Excel with AI alerts and insights, offered as an upgrade path for Spreadsheet Server and Jet Reports customers.
Spreadsheet Server v25.4.4 released
Fixes for Distribution Manager file paths, JD Edwards and SAP drill-down, and Snowflake identifier quoting in Query Designer.
v25.4 adds direct Snowflake connection and AI controls
Snowflake connects without ODBC drivers, admins can disable AI features, and connections can use role-specific usernames. The Sage Intacct Cloud Connector is available from this version.
Infor M3 Cloud integration announced
insightsoftware announced that Spreadsheet Server now integrates with Infor M3 Cloud, citing over 2,000 manufacturing and distribution customers.
insightsoftware does not publish a price. Pricing runs through a Request a Price form, and the docs say each user needs a license key, so the number scales with users and license tier (checked 1 November 2026).
Ask for the price of Silver or Limited, Gold and Platinum keys, whether Query Designer is included, and what Platform licensing adds. Training is quoted separately. No public benchmark isolates this product, so compare written quotes line by line.
Contract length and renewal terms are not published, so get the term, renewal cap and licensing model (Platform, subscription license key or maintenance) in writing.
Exit is simpler than with a planning database. Reports are ordinary Excel workbooks, and the Convert Spreadsheet Server Formulas tool turns GXL, GEXD, GEXQ and similar formulas into static values for a sheet or workbook. Source data stays in your ERP or the Cloud Connector replica. Without a license, the formulas stop refreshing.
insightsoftware says most customers build reports within days. IT gathers the ERP or database connection details, an administrator sets up Application Configurator, and each user installs the add-in.
Cloud ERPs need a Cloud Connector replication job first. insightsoftware offers virtual courses and two-day regional classes in Raleigh or Denver with CPE credit, and partners such as HIT Technology and RPI Consultants also run Spreadsheet Server sessions.
Not directly. As of 1 November 2026 there is no first-party MCP server and no documented public API, so an agent cannot refresh reports, run queries or trigger distribution.
Claude can work with workbooks and exports people save. Inside the product, Lineos Doc Assist answers how-to questions and Data Assist summarises trends and anomalies, depending on license type.
Answered only from our own published research on this tool, never from general internet noise. If we cannot answer it well, our research agents will dig in and publish a sourced answer.