Spreadsheets

Use your XLSX and Google Sheets spreadsheets as web app data sources.

Get started Contact Us

Go from locked up spreadsheet data, to a dynamic data feed in minutes.

Spreadsheets

Use XLSX files and Google Sheets as data sources.
Explicitly control read/write data ranges. Spreadsheets auto-calculate behind the scenes, providing real-time formula and data results.
Administer Google Sheets connections and XLSX files (CRUD) via our Designer and/or API.
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

SPREADSHEETS

As for Google Sheets®, all functions are supported. For XLSX files, the functions below are supported.

XLSX-supported functions

  • ABS
  • ACOS
  • ACOSH
  • ADDRESS
  • AND
  • ASIN
  • ASINH
  • ATAN
  • ATAN2
  • ATANH
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • CEILING
  • CHAR
  • CHOOSE
  • COLUMN
  • COLUMNS
  • CONCATENATE
  • COS
  • COSH
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • DATE
  • DATEVALUE
  • DAVERAGE
  • DAY
  • DAYS360
  • DCOUNT
  • DCOUNTA
  • DEGREES
  • DGET
  • DMAX
  • DMIN
  • DSUM
  • DVAR
  • DVARP
  • EDATE
  • EOMONTH
  • ERROR.TYPE
  • EXACT
  • EXP
  • FACT
  • FALSE
  • FIND
  • FIXED
  • FLOOR
  • HLOOKUP
  • HOUR
  • HYPERLINK
  • IF
  • IFERROR
  • IFNA
  • INDEX
  • INDIRECT
  • INT
  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISLOGICAL
  • ISNA
  • ISNONTEXT
  • ISNUMBER
  • ISODD
  • ISOWEEKNUM
  • ISTEXT
  • LARGE
  • LEFT
  • LEN
  • LN
  • LOG
  • LOG10
  • LOOKUP
  • LOWER
  • MATCH
  • MAX
  • MAXA
  • MEDIAN
  • MID
  • MIN
  • MINA
  • MINUTE
  • MOD
  • MONTH
  • N
  • NA
  • NOT
  • NOW
  • OFFSET
  • OR
  • PI
  • POWER
  • PRODUCT
  • PROPER
  • QUOTIENT
  • RAND
  • RANDBETWEEN
  • RANK
  • RANK.AVG
  • RANK.EQ
  • REPLACE
  • REPT
  • RIGHT
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • ROW
  • ROWS
  • SEARCH
  • SECOND
  • SIGN
  • SIN
  • SINH
  • SMALL
  • SQRT
  • SQRTPI
  • STDEV
  • STDEV.P
  • STDEV.S
  • STDEVP
  • SUBSTITUTE
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • SUMSQ
  • T
  • TAN
  • TANH
  • TEXT
  • TIME
  • TIMEVALUE
  • TODAY
  • TRUE
  • TRUNC
  • UPPER
  • VALUE
  • VAR
  • VARP
  • VLOOKUP
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC

Start building in minutes.

Prevent headaches and save money.