Document compatibility with Microsoft Office.

See all the ways our productivity apps support popular Microsoft Office features.

Back to top

Sheet Properties

Microsoft Feature

Numbers Support

arranged objects

Item supported

background

Item not supported

frozen panes

Supported on export

grouped objects

Item supported

image border

Some borders may be removed or may look different

image effects

Some effects may be removed or may look different

Inserted Clip Art

Item supported

inserted image

Item supported

inserted shapes

Item supported

locked cell

Item not supported

margins

Item supported

page breaks

Item not supported

page orientation

Item supported

protected sheet

Item not supported

shape styles

Some styles may be removed or may look different

SmartArt Graphics

Imported as a shape

splits

Item not supported

worksheets

Item supported

Back to top

Table Properties

Microsoft Feature

Numbers Support

banded columns

Formatting is preserved

banded rows

Formatting is preserved

column width

Item supported

first column

Item supported

header row

Formatting is preserved

inserted equations

Item supported

inserted symbols

Item supported

last column

Item supported

merged cells

Item supported

row height

Item supported

table styles

Formatting is preserved

total row

Cell values are preserved, but formulas are removed

Back to top

Cell Type

Microsoft Feature

Numbers Support

accounting format

Imported as Custom Format

conditional formatting

Item supported

currency format

Item supported

custom formatting

Item supported

Date/Time Format

Item supported

fraction format

Item supported

general format

Item supported

number format

Item supported

percentage format

Item supported

scientific format

Item supported

special formatting

Item supported

text format

Item supported

Back to top

Data Manipulation

Microsoft Feature

Numbers Support

data validation

Item not supported

external data

Item not supported

filters

Formatting and results are preserved

pivot table

Most settings are preserved. Slicers and Timelines are removed. Learn more about importing pivot tables from Excel

slicers

Item not supported

sort table

Item supported

Back to top

Formatting

Microsoft Feature

Numbers Support

border formatting

Item supported

cell fill

Item supported

cell inset margin

Item supported

cell text wrap

Item supported

email hyperlinks

Item supported

font types

Fonts available for download are imported. Unsupported fonts are substituted.

Hide and Unhide Columns

Item supported

Hide and Unhide Rows

Item supported

Horizontal Alignment in Cell

Item supported

Rich Text in Cells

Item supported

stroke styles

Item supported

Vertical Alignment in Cell

Item supported

web hyperlinks

Item supported

Back to top

Chart Properties and Formatting

Microsoft Feature

Numbers Support

Category Axis Title

Item supported

Category/Series Labels

Item supported

chart data source

Item supported

chart layouts

Item supported

chart styles

Item supported

chart title

Item supported

fill

Item supported

series axis title

Item supported

series data source

Item supported

series order

Item supported

shadow

Item not supported

show data table

Item not supported

Show Legend Keys in Data Table

Item not supported

show series major gridline

Item supported

show series minor gridline

Item supported

spark lines

Item not supported

stroke styles

Item supported

value axis title

Item supported

Back to top

Charts

Microsoft Feature

Numbers Support

2D Column

Item supported

2D Stacked Column

Item supported

2D 100% Stacked Column

Item supported

2D Bar

Item supported

2D Stacked Bar

Item supported

2D 100% Stacked Bar

Item supported

2D Line

Item supported

2D Stacked Line

Imported as Line chart

2D Marked Line

Item supported

2D Stacked Marked Line

Imported as Line chart

2D 100% Stacked Marked Line

Imported as Line chart

2D 100% Stacked Line

Imported as Line chart

2D Area

Item supported

2D Stacked Area

Item supported

2D 100% Stacked Area

Item supported

2D Smooth Marked Scatter

Item supported

2D Smooth Lined Scatter

Item supported

2D Straight Marked Scatter

Item supported

2D Straight Lined Scatter

Item supported

2D Pie

Item supported

2D Exploded Pie

Item supported

2D Pie of Pie

Imported as Pie chart

2D Bar of Pie

Imported as Pie chart

2D Marked Scatter

Item supported

3D Column

Item supported

3D Stacked Column

Item supported

3D 100% Stacked Column

Item supported

3D Bar

Item supported

3D Stacked Bar

Item supported

3D 100% Stacked Bar

Item supported

3D Line

Item supported

3D Area

Item supported

3D Pie

Item supported

3D Exploded Pie

Item supported

3D Stacked Area

Item supported

3D 100% Stacked Area

Item supported

bubble charts

Item supported

doughnut

Imported as single-tier doughnut chart

exploded doughnut

Imported as single-tier doughnut chart

surface charts

Item not supported

radar charts

Item supported

High-Low-Close Stock

Imported as Line chart

Open-High-Low-Close Stock

Imported as Line chart

Volume-High-Low-Close Stock

Imported as Bar chart

Volume-Open-High-Low-Close Stock

Imported as Bar chart

column cylinder

Item supported

stacked column cylinder

Item supported

3D Column Cylinder

Item supported

column cone

Imported as 3D Column Cylinder chart

stacked column cone

Imported as 3D Column Cylinder chart

100% Stacked Column Cone

Imported as 3D Column Cylinder chart

3D Column Cone

Imported as 3D Column Cylinder chart

column pyramid

Imported as 3D Rectangle Column chart

stacked column pyramid

Imported as 3D Rectangle Column chart

100% Stacked Column Pyramid

Imported as 3D Rectangle Column chart

3D Column Pyramid

Imported as 3D Rectangle Column chart

bar cylinder

Item supported

stacked bar cylinder

Item supported

100% Stacked Bar Cylinder

Item supported

bar cone

Imported as Bar Cylinder chart

stacked bar cone

Imported as Bar Cylinder chart

100% Stacked Bar Cone

Imported as Bar Cylinder chart

bar pyramid

Imported as 3D Rectangle Bar chart

stacked bar pyramid

Imported as 3D Rectangle Bar chart

100% Stacked Bar Pyramid

Imported as 3D Rectangle Bar chart

Back to top

Date and Time Functions

Microsoft Feature

Numbers Support

date

Item supported

datedif

Item supported

datevalue

Item supported

day

Item supported

days360

Item supported

edate

Item supported

eomonth

Item supported

hour

Item supported

isoweeknum

Item supported

minute

Item supported

month

Item supported

networkdays

Item supported

networkdays.intl

Item not supported

now

Item supported

second

Item supported

time

Item supported

timevalue

Item supported

today

Item supported

weekday

Item supported

weeknum

Item supported

workday

Item supported

workday.intl

Item not supported

year

Item supported

yearfrac

Item supported

Back to top

Engineering Functions

Microsoft Feature

Numbers Support

besseli

Item not supported

besselj

Item supported

besselk

Item not supported

bessely

Item supported

bin2dec

Item supported

bin2hex

Item supported

bin2oct

Item supported

bitand

Item supported

bitlshift

Item supported

bitor

Item supported

bitrshift

Item supported

bitxor

Item supported

complex

Item not supported

convert

Item supported

dec2bin

Item supported

dec2hex

Item supported

dec2oct

Item supported

delta

Item supported

erf

Item supported

erf.precise

Item not supported

erfc

Item supported

erfc.precise

Item not supported

gestep

Item supported

hex2bin

Item supported

hex2dec

Item supported

hex2oct

Item supported

imabs

Item not supported

imaginary

Item not supported

imargument

Item not supported

imconjugate

Item not supported

imcos

Item not supported

imdiv

Item not supported

imexp

Item not supported

imln

Item not supported

imlog10

Item not supported

imlog2

Item not supported

impower

Item not supported

improduct

Item not supported

imreal

Item not supported

imsin

Item not supported

imsqrt

Item not supported

imsub

Item not supported

imsum

Item not supported

oct2bin

Item supported

oct2dec

Item supported

oct2hex

Item supported

Back to top

Financial Functions

Microsoft Feature

Numbers Support

accrint

Item supported

accrintm

Item supported

amordegrc

Item not supported

amorlinc

Item not supported

coupdaybs

Item supported

coupdays

Item supported

coupdaysnc

Item supported

coupncd

Item not supported

coupnum

Item supported

couppcd

Item not supported

cumipmt

Item supported

cumprinc

Item supported

db

Item supported

ddb

Item supported

disc

Item supported

dollarde

Item not supported

dollarfr

Item not supported

duration

Item supported

effect

Item supported

fv

Item supported

fvschedule

Item not supported

intrate

Item supported

ipmt

Item supported

irr

Item supported

ispmt

Item supported

mduration

Item supported

mirr

Item supported

nominal

Item supported

nper

Item supported

npv

Item supported

oddfprice

Item not supported

oddfyield

Item not supported

oddlprice

Item not supported

oddlyield

Item not supported

pmt

Item supported

ppmt

Item supported

price

Item supported

pricedisc

Item supported

pricemat

Item supported

pv

Item supported

rate

Item supported

received

Item supported

sln

Item supported

syd

Item supported

tbilleq

Item not supported

tbillprice

Item not supported

tbillyield

Item not supported

vdb

Item supported

xirr

Item supported

xnpv

Item supported

yield

Item supported

yielddisc

Item supported

yieldmat

Item supported

Back to top

Information Functions

Microsoft Feature

Numbers Support

cell

Item not supported

error.type

Item not supported

info

Item not supported

isblank

Item supported

iserr

Item not supported

iserror

Item supported

iseven

Item supported

islogical

Item not supported

isna

Item not supported

isnontext

Item not supported

isnumber

Item supported

isodd

Item supported

isref

Item not supported

istext

Item supported

n

Item not supported

na

Item not supported

type

Item not supported

Back to top

Logical Functions

Microsoft Feature

Numbers Support

and

Item supported

false

Item supported

if

Item supported

iferror

Item supported

not

Item supported

or

Item supported

switch

Item supported

true

Item supported

Back to top

Lookup and Reference Functions

Microsoft Feature

Numbers Support

address

Last calculated value is preserved and the function may or may not be removed depending on the values used

areas

Item supported

choose

Item supported

aggregate

Item not supported

column

Item supported

columns

Item supported

hlookup

Item supported

hyperlink

Item supported

INDEX (array)

Item supported

INDEX (reference)

Item supported

indirect

Item supported

LOOKUP (array)

Item supported

LOOKUP (vector)

Item supported

match

Item supported

offset

Item supported

row

Item supported

rows

Item supported

transpose

Item supported

vlookup

Item supported

xlookup

Item supported

Back to top

Maths and Trigonometry Functions

Microsoft Feature

Numbers Support

abs

Item supported

acos

Item supported

acosh

Item supported

aggregate

Item not supported

asin

Item supported

asinh

Item supported

atan

Item supported

atan2

Item supported

atanh

Item supported

ceiling

Item supported

ceiling.precise

Item not supported

combin

Item supported

cos

Item supported

cosh

Item supported

degrees

Item supported

even

Item supported

exp

Item supported

fact

Item supported

factdouble

Item supported

floor

Item supported

floor.precise

Item not supported

gcd

Item supported

int

Item supported

iso.ceiling

Item not supported

lcm

Item supported

ln

Item supported

log

Item supported

log10

Item supported

mdeterm

Item not supported

minverse

Item not supported

mmult

Item not supported

mod

Item supported

mround

Item supported

multinomial

Item supported

odd

Item supported

pi

Item supported

power

Item supported

product

Item supported

quotient

Item supported

radians

Item supported

rand

Item supported

randbetween

Item supported

roman

Item supported

round

Item supported

rounddown

Item supported

roundup

Item supported

seriessum

Item supported

sign

Item supported

sin

Item supported

sinh

Item supported

sqrt

Item supported

sqrtpi

Item supported

subtotal

Item supported

sum

Item supported

sumif

Item supported

sumifs

Item supported

sumproduct

Item supported

sumsq

Item supported

sumx2my2

Item supported

sumx2py2

Item supported

sumxmy2

Item supported

tan

Item supported

tanh

Item supported

trunc

Item supported

Back to top

Statistical Functions

Microsoft Feature

Numbers Support

avedev

Item supported

average

Item supported

averagea

Item supported

averageif

Item supported

averageifs

Item supported

beta.dist

Item not supported

beta.inv

Item not supported

betadist

Item supported

betainv

Item supported

binom.dist

Item supported

binom.inv

Item not supported

binomdist

Item supported

chidist

Item supported

chiinv

Item supported

chisq.dist

Item not supported

chisq.dist.rt

Item not supported

chisq.inv

Item not supported

chisq.inv.rt

Item not supported

chisq.test

Item not supported

chitest

Item supported

confidence

Item supported

confidence.norm

Item not supported

confidence.t

Item not supported

correl

Item supported

count

Item supported

counta

Item supported

countblank

Item supported

countif

Item supported

countifs

Item supported

covar

Item supported

covariance.p

Item not supported

covariance.s

Item not supported

critbinom

Item supported

devsq

Item supported

expon.dist

Item not supported

expondist

Item supported

f.dist

Item not supported

f.dist.rt

Item not supported

f.inv

Item not supported

f.inv.rt

Item not supported

f.test

Item not supported

fdist

Item supported

finv

Item supported

fisher

Item not supported

fisherinv

Item not supported

forecast

Item supported

frequency

Item supported

ftest

Item not supported

gamma.dist

Item supported

gamma.inv

Item supported

gammadist

Item supported

gammainv

Item supported

gammaln

Item supported

gammaln.precise

Item not supported

geomean

Item supported

growth

Item not supported

harmean

Item supported

hypgeomdist

Item not supported

intercept

Item supported

kurt

Item not supported

large

Item supported

linest

Item supported

logest

Item not supported

loginv

Item supported

lognorm.dist

Item not supported

lognorm.inv

Item not supported

lognormdist

Item supported

max

Item supported

maxa

Item supported

median

Item supported

min

Item supported

mina

Item supported

mode

Item supported

mode.mult

Item not supported

mode.sngl

Item not supported

negbinom.dist

Item not supported

negbinomdist

Item supported

norm.dist

Item not supported

norm.inv

Item not supported

norm.s.dist

Item not supported

norm.s.inv

Item not supported

normdist

Item supported

norminv

Item supported

normsdist

Item supported

normsinv

Item supported

pearson

Item not supported

percentile

Item supported

percentile.exc

Item not supported

percentile.inc

Item supported

percentrank

Item supported

percentrank.exc

Item not supported

percentrank.inc

Item supported

permut

Item supported

poisson

Item supported

poisson.dist

Item supported

prob

Item supported

quartile

Item supported

quartile.exc

Item not supported

quartile.inc

Item supported

rank

Item supported

rank.avg

Item not supported

rank.eq

Item supported

rsq

Item not supported

skew

Item not supported

slope

Item supported

small

Item supported

standardize

Item supported

stdev

Item supported

stdev.p

Item supported

stdev.s

Item not supported

stdeva

Item supported

stdevp

Item supported

stdevpa

Item supported

steyx

Item not supported

t.dist

Item not supported

t.dist.2t

Item not supported

t.dist.rt

Item not supported

t.inv

Item not supported

t.inv.2t

Item not supported

tdist

Item supported

tinv

Item supported

trend

Item not supported

trimmean

Item not supported

ttest

Item supported

var

Item supported

var.p

Item supported

var.s

Item supported

vara

Item supported

varp

Item supported

varpa

Item supported

weibull

Item supported

weibull.dist

Item not supported

z.test

Item supported

ztest

Item supported

Back to top

Text Functions

Microsoft Feature

Numbers Support

asc

Item not supported

char

Last calculated value is preserved and the function may or may not be removed depending on the values used

clean

Item supported

code

Last calculated value is preserved and the function may or may not be removed depending on the values used

concat

Item supported

concatenate

Item supported

dollar

Item supported

exact

Item supported

find

Item supported

findb

Item not supported

fixed

Item supported

jis

Item not supported

left

Item supported

leftb

Item not supported

len

Item supported

lenb

Item not supported

lower

Item supported

mid

Item supported

midb

Item not supported

phonetic

Item not supported

proper

Item supported

replace

Item supported

replaceb

Item not supported

rept

Item supported

right

Item supported

rightb

Item not supported

search

Item supported

searchb

Item not supported

substitute

Item supported

t

Item supported

text

Item not supported

textjoin

Item supported

trim

Item supported

upper

Item supported

value

Item supported

yen

Item not supported

Back to top

Numbers has over 250 built-in functions that can perform calculations, retrieve information or manipulate data. Learn more

Cube Functions

Microsoft Feature

Numbers Support

cubekpimember

Item not supported

cubemember

Item not supported

cubememberproperty

Item not supported

cuberankedmember

Item not supported

cubeset

Item not supported

cubesetcount

Item not supported

cubevalue

Item not supported

Back to top

Database Functions

Microsoft Feature

Numbers Support

daverage

Item not supported

dcount

Item not supported

dcounta

Item not supported

dget

Item not supported

dmax

Item not supported

dmin

Item not supported

dproduct

Item not supported

dstdev

Item not supported

dstdevp

Item not supported

dsum

Item not supported

dvar

Item not supported

dvarp

Item not supported

getpivotdata

Item not supported

Back to top

Miscellaneous

Microsoft Feature

Numbers Support

comments

Item supported

ink annotations

Imported as drawings

macros

Item not supported

ole objects

Item not supported

protected workbook

Item supported

tracked changes

Item not supported

Pages Compatibility

Learn more about Microsoft Word compatibility

Keynote Compatibility

Learn more about Microsoft PowerPoint compatibility

Pages

Create documents that are, in a word, beautiful.

Learn more about Pages

Numbers

Build spreadsheets that are
bottom-line brilliant.

Learn more about Numbers

Keynote

Design stunning, memorable
presentations.

Learn more about Keynote