Sheets
  • Introduction
  • REST API
    • Authentication
    • Reading / updating a workbook
    • Creating / uploading a workbook
    • Simulation API
  • GraphQL API
  • Authentication in production
  • Embedding example
  • Excel compatibility
  • Example apps
Powered by GitBook
On this page

Excel compatibility

We support:

  • 182 Excel functions (out of ~450)

  • Cell styling and formatting

Partial support (we’re working on it):

  • Merged cells

  • Defined names

  • Excel Tables

  • Arrays and array formulas

We don’t support (TODO):

  • Pivot tables

  • Conditional formatting

  • Dynamic array functions, such as FILTER()

  • Borders

  • Charts

We have no plans to support:

  • VBA

  • Power Query

Full list of Excel functions that we support:

  • ABS

  • ACOS

  • ACOSH

  • AND

  • ASIN

  • ASINH

  • ATAN

  • ATAN2

  • ATANH

  • AVERAGE

  • AVERAGEA

  • AVERAGEIF

  • AVERAGEIFS

  • BESSELI

  • BESSELJ

  • BESSELK

  • BESSELY

  • BIN2DEC

  • BIN2HEX

  • BIN2OCT

  • BITAND

  • BITLSHIFT

  • BITOR

  • BITRSHIFT

  • BITXOR

  • CHOOSE

  • COLUMN

  • COLUMNS

  • COMPLEX

  • CONCAT

  • CONCATENATE

  • CONVERT

  • COS

  • COSH

  • COUNT

  • COUNTA

  • COUNTBLANK

  • COUNTIF

  • COUNTIFS

  • CUMIPMT

  • CUMPRINC

  • DATE

  • DAY

  • DB

  • DDB

  • DEC2BIN

  • DEC2HEX

  • DEC2OCT

  • DELTA

  • DOLLARDE

  • DOLLARFR

  • EDATE

  • EFFECT

  • ERF

  • ERFC

  • ERFCPRECISE

  • ERFPRECISE

  • EXACT

  • FALSE

  • FIND

  • FV

  • GESTEP

  • HEX2BIN

  • HEX2DEC

  • HEX2OCT

  • HLOOKUP

  • IF

  • IFERROR

  • IFNA

  • IFS

  • IMABS

  • IMAGINARY

  • IMARGUMENT

  • IMCONJUGATE

  • IMCOS

  • IMCOSH

  • IMCOT

  • IMCSC

  • IMCSCH

  • IMDIV

  • IMEXP

  • IMLN

  • IMLOG10

  • IMLOG2

  • IMPOWER

  • IMPRODUCT

  • IMREAL

  • IMSEC

  • IMSECH

  • IMSIN

  • IMSINH

  • IMSQRT

  • IMSUB

  • IMSUM

  • IMTAN

  • INDEX

  • INDIRECT

  • IPMT

  • IRR

  • ISBLANK

  • ISERR

  • ISERROR

  • ISLOGICAL

  • ISNA

  • ISNONTEXT

  • ISNUMBER

  • ISPMT

  • ISTEXT

  • LEFT

  • LEN

  • LOOKUP

  • LOWER

  • MATCH

  • MAX

  • MAXIFS

  • MID

  • MIN

  • MINIFS

  • MIRR

  • MONTH

  • NA

  • NOMINAL

  • NOT

  • NOW

  • NPER

  • NPV

  • OCT2BIN

  • OCT2DEC

  • OCT2HEX

  • OFFSET

  • OR

  • PDURATION

  • PI

  • PMT

  • POWER

  • PPMT

  • PRODUCT

  • PV

  • RATE

  • REPT

  • RIGHT

  • ROUND

  • ROUNDDOWN

  • ROUNDUP

  • ROW

  • ROWS

  • RRI

  • SEARCH

  • SIN

  • SINH

  • SLN

  • SQRT

  • SQRTPI

  • SUBSTITUTE

  • SUBTOTAL

  • SUM

  • SUMIF

  • SUMIFS

  • SWITCH

  • SYD

  • T

  • TAN

  • TANH

  • TBILLEQ

  • TBILLPRICE

  • TBILLYIELD

  • TEXT

  • TEXTAFTER

  • TEXTBEFORE

  • TEXTJOIN

  • TODAY

  • TRIM

  • TRUE

  • UPPER

  • VALUE

  • VALUETOTEXT

  • VLOOKUP

  • XIRR

  • XLOOKUP

  • XNPV

  • XOR

  • YEAR

PreviousEmbedding exampleNextExample apps

Last updated 2 years ago