Databases

Combine database queries with XLSX and Google Sheets data sources, or just get the database data back.

Get started Contact Us

Databases

Create freeform database queries to read and write data. Database query data can also be dynamically mapped to spreadsheet range(s), allowing data from disparate sources to be combined and used in a Spreadsheet.

Use SQL Server, PostgreSQL and MySQL as data sources.
Feed in parameter values and get values back as JSON.
Alternatively map your database query results data to spreadsheet range(s), creating dynamic data models that pull from disparate sources.
Consistent input/output regardless of database type.
Administer database connections (CRUD) via our Designer and/or API.
Feed in parameter values and get values back as JSON. e.g.

{parameters:[{name:"fiscalYearAndQuarter", value:"q42020"}]}

All-in-one-solution

A one-stop-shop for communicating with spreadsheets and databases via REST.

API

A Simple Yet Powerful REST API & API Designer for Google Sheets®, XLSX Files and a number of popular databases.

Scalable

Anywhere REST is Supported

Easily Get/Set Spreadsheet Cell and 1D & 2D range data all in one call. You explicitly control Read and Write data ranges.

CRUD Spreadsheet Files

CRUD REST Services

CRUD Database Connections and Queries

Query REST Services

Complete Programmatic Control via REST API

Security

Spreadsheet and Connection Files are Always Encrypted

HTTPS ONLY

Use password-protected XLSX files if desired

Must explicitly approve domains via our Designer or API, to communicate with the REST API. All non-approved Domains are automatically rejected before they even reach our Network.

Constantly Monitored, including Audit Log trails on all REST/Spreadsheet/API access

Storage

Spreadsheets and Connection Files are Always Encrypted

Blazing Fast Read/Write all over HTTPS. Your data stays in our private, secured Cloud and is only accessible via the API over HTTPs, via approved Domains.

Scalable storage - If you need more, you can always upgrade

Start building in minutes.

Prevent headaches and save money.