Data

Use Google Sheets, XLSX files and database queries to create dynamic web-friendly data models.

Get started Contact Us

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.

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

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.