| Sheet Properties |
Supported |
Partially Supported |
Not Supported |
| Arranged objects |
 |
|
|
| Background |
|
|
|
| Frozen panes |
|
|
|
| Grouped objects |
|
|
|
| Image border |
|
Some borders may be removed or may look different |
|
| Image effects |
|
Some effects may be removed or may look different |
|
| Image layout |
|
|
|
| Inserted clip art |
|
|
|
| Inserted image |
|
|
|
| Inserted shapes |
|
|
|
| Locked cell |
|
|
|
| Margins |
|
|
|
| Page breaks |
|
|
|
| Page orientation |
|
|
|
| Protected sheet |
|
|
|
| Shape styles |
|
Some styles may be removed or may look different |
|
| SmartArt Graphics |
|
|
|
| Splits |
|
|
|
| Worksheets |
|
|
|
| Table Properties |
Supported |
Partially Supported |
Not Supported |
| Banded columns |
|
Formatting is preserved |
|
| Banded rows |
|
Formatting is preserved |
|
| Column width |
|
|
|
| First column |
|
|
|
| Header row |
|
|
|
| Inserted equations |
|
|
|
| Inserted symbols |
|
|
|
| Last column |
|
|
|
| Merged cells |
|
|
|
| Row height |
|
|
|
| Table styles |
|
Formatting is preserved |
|
| Total row |
|
Cell values are preserved, but formulas are removed |
|
| Cell Type |
Supported |
Partially Supported |
Not Supported |
| Accounting format |
|
|
|
| Conditional formatting |
|
|
|
| Currency format |
|
|
|
| Custom formatting |
|
Custom formatting is preserved, but formats are not editable |
|
| Date/Time format |
|
|
|
| Fraction format |
|
|
|
| General format |
|
|
|
| Number format |
|
|
|
| Percentage format |
|
|
|
| Scientific format |
|
|
|
| Special formatting |
|
Special formatting is preserved, but formats are not editable |
|
| Text format |
|
|
|
| Data Manipulation |
Supported |
Partially Supported |
Not Supported |
| Data validation |
|
|
|
| External data |
|
|
|
| Filters |
|
|
|
| Pivot table |
|
|
|
| Slicers |
|
|
|
| Sort table |
|
|
|
| Formatting |
Supported |
Partially Supported |
Not Supported |
| Border formatting |
|
|
|
| Cell fill |
|
|
|
| Cell inset margin |
|
Margin is preserved on import, but not editable |
|
| Cell text wrap |
|
|
|
| Email hyperlinks |
|
|
|
| Font types |
|
Fonts available on iOS are imported. Unsupported fonts are substituted. Learn more |
|
| Hide and unhide columns |
|
|
|
| Hide and unhide rows |
|
|
|
| Horizontal alignment in cell |
|
|
|
| Rich text in cells |
|
Rich text formatting is removed when the cell is edited |
|
| Stroke styles |
|
|
|
| Vertical alignment in cell |
|
|
|
| Web hyperlinks |
|
|
|
| Chart Properties and Formatting |
Supported |
Partially Supported |
Not Supported |
| Category axis title |
|
|
|
| Category/series labels |
|
|
|
| Chart data source |
|
|
|
| Chart layouts |
|
|
|
| Chart styles |
|
|
|
| Chart title |
|
|
|
| Fill |
|
|
|
| Series axis title |
|
|
|
| Series data source |
|
|
|
| Series order |
|
|
|
| Shadow |
|
|
|
| Show data table |
|
|
|
| Show legend keys in data table |
|
|
|
| Show series major gridline |
|
|
|
| Show series minor gridline |
|
|
|
| Spark lines |
|
|
|
| Stroke styles |
|
|
|
| Value axis title |
|
|
|
| Charts |
Supported |
Partially Supported |
Not Supported |
| 2D Column |
|
|
|
| 2D Stacked Column |
|
|
|
| 2D 100% Stacked Column |
|
|
|
| 2D Bar |
|
|
|
| 2D Stacked Bar |
|
|
|
| 2D 100% Stacked Bar |
|
|
|
| 2D Line |
|
|
|
| 2D Stacked Line |
|
Imported as Line chart |
|
| 2D Marked Line |
|
|
|
| 2D Stacked Marked Line |
|
|
|
| 2D 100% Stacked Marked Line |
|
|
|
| 2D 100% Stacked Line |
|
Imported as Line chart |
|
| 2D Area |
|
|
|
| 2D Stacked Area |
|
|
|
| 2D 100% Stacked Area |
|
|
|
| 2D Smooth Marked Scatter |
|
|
|
| 2D Smooth Lined Scatter |
|
|
|
| 2D Straight Marked Scatter |
|
|
|
| 2D Straight Lined Scatter |
|
|
|
| 2D Pie |
|
|
|
| 2D Exploded Pie |
|
|
|
| 2D Pie of Pie |
|
Imported as Pie chart |
|
| 2D Bar of Pie |
|
Imported as Pie chart |
|
| 2D Marked Scatter |
|
|
|
| 3D Column |
|
|
|
| 3D Stacked Column |
|
|
|
| 3D 100% Stacked Column |
|
|
|
| 3D Bar |
|
|
|
| 3D Stacked Bar |
|
|
|
| 3D 100% Stacked Bar |
|
|
|
| 3D Line |
|
|
|
| 3D Area |
|
|
|
| 3D Pie |
|
|
|
| 3D Exploded Pie |
|
|
|
| 3D Stacked Area |
|
|
|
| 3D 100% Stacked Area |
|
|
|
| Bubble charts |
|
|
|
| Doughnut |
|
Imported as Pie chart |
|
| Exploded Doughnut |
|
Imported as Pie chart |
|
| Surface charts |
|
|
|
| Radar charts |
|
|
|
| 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 |
|
|
|
| Stacked Column Cylinder |
|
|
|
| 100% Stacked Column Cylinder |
|
|
|
| 3D Column Cylinder |
|
|
|
| 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 |
|
|
|
| Stacked Bar Cylinder |
|
|
|
| 100% Stacked Column Cylinder |
|
|
|
| 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 |
|
| Miscellaneous |
Supported |
Partially Supported |
Not Supported |
| Comments |
|
|
|
| Ink annotations |
|
|
|
| Macros |
|
|
|
| OLE objects |
|
|
|
| Protected workbook |
|
|
|
| Tracked changes |
|
|
|
| Cube Functions |
Supported |
Partially Supported |
Not Supported |
| CUBEKPIMEMBER |
|
|
|
| CUBEMEMBER |
|
|
|
| CUBEMEMBERPROPERTY |
|
|
|
| CUBERANKEDMEMBER |
|
|
|
| CUBESET |
|
|
|
| CUBESETCOUNT |
|
|
|
| CUBEVALUE |
|
|
|
| Database Functions |
Supported |
Partially Supported |
Not Supported |
| DAVERAGE |
|
|
|
| DCOUNT |
|
|
|
| DCOUNTA |
|
|
|
| DGET |
|
|
|
| DMAX |
|
|
|
| DMIN |
|
|
|
| DPRODUCT |
|
|
|
| DSTDEV |
|
|
|
| DSTDEVP |
|
|
|
| DSUM |
|
|
|
| DVAR |
|
|
|
| DVARP |
|
|
|
| GETPIVOTDATA |
|
|
|
| Date and Time Functions |
Supported |
Partially Supported |
Not Supported |
| DATE |
|
|
|
| DATEDIF |
|
|
|
| DATEVALUE |
|
|
|
| DAY |
|
|
|
| DAYS360 |
|
|
|
| EDATE |
|
|
|
| EOMONTH |
|
|
|
| HOUR |
|
|
|
| MINUTE |
|
|
|
| MONTH |
|
|
|
| NETWORKDAYS |
|
|
|
| NETWORKDAYS.INTL |
|
|
|
| NOW |
|
|
|
| SECOND |
|
|
|
| TIME |
|
|
|
| TIMEVALUE |
|
|
|
| TODAY |
|
|
|
| WEEKDAY |
|
|
|
| WEEKNUM |
|
|
|
| WORKDAY |
|
|
|
| WORKDAY.INTL |
|
|
|
| YEAR |
|
|
|
| YEARFRAC |
|
|
|
| Engineering Functions |
Supported |
Partially Supported |
Not Supported |
| BESSELI |
|
|
|
| BESSELJ |
|
|
|
| BESSELK |
|
|
|
| BESSELY |
|
|
|
| BIN2DEC |
|
|
|
| BIN2HEX |
|
|
|
| BIN2OCT |
|
|
|
| COMPLEX |
|
|
|
| CONVERT |
|
|
|
| DEC2BIN |
|
|
|
| DEC2HEX |
|
|
|
| DEC2OCT |
|
|
|
| DELTA |
|
|
|
| ERF |
|
|
|
| ERF.PRECISE |
|
|
|
| ERFC |
|
|
|
| ERFC.PRECISE |
|
|
|
| GESTEP |
|
|
|
| HEX2BIN |
|
|
|
| HEX2DEC |
|
|
|
| HEX2OCT |
|
|
|
| IMABS |
|
|
|
| IMAGINARY |
|
|
|
| IMARGUMENT |
|
|
|
| IMCONJUGATE |
|
|
|
| IMCOS |
|
|
|
| IMDIV |
|
|
|
| IMEXP |
|
|
|
| IMLN |
|
|
|
| IMLOG10 |
|
|
|
| IMLOG2 |
|
|
|
| IMPOWER |
|
|
|
| IMPRODUCT |
|
|
|
| IMREAL |
|
|
|
| IMSIN |
|
|
|
| IMSQRT |
|
|
|
| IMSUB |
|
|
|
| IMSUM |
|
|
|
| OCT2BIN |
|
|
|
| OCT2DEC |
|
|
|
| OCT2HEX |
|
|
|
| Financial Functions |
Supported |
Partially Supported |
Not Supported |
| ACCRINT |
|
|
|
| ACCRINTM |
|
|
|
| AMORDEGRC |
|
|
|
| AMORLINC |
|
|
|
| COUPDAYBS |
|
|
|
| COUPDAYS |
|
|
|
| COUPDAYSNC |
|
|
|
| COUPNCD |
|
|
|
| COUPNUM |
|
|
|
| COUPPCD |
|
|
|
| CUMIPMT |
|
|
|
| CUMPRINC |
|
|
|
| DB |
|
|
|
| DDB |
|
|
|
| DISC |
|
|
|
| DOLLARDE |
|
|
|
| DOLLARFR |
|
|
|
| DURATION |
|
|
|
| EFFECT |
|
|
|
| FV |
|
|
|
| FVSCHEDULE |
|
|
|
| INTRATE |
|
|
|
| IPMT |
|
|
|
| IRR |
|
|
|
| ISPMT |
|
|
|
| MDURATION |
|
|
|
| MIRR |
|
|
|
| NOMINAL |
|
|
|
| NPER |
|
|
|
| NPV |
|
|
|
| ODDFPRICE |
|
|
|
| ODDFYIELD |
|
|
|
| ODDLPRICE |
|
|
|
| ODDLYIELD |
|
|
|
| PMT |
|
|
|
| PPMT |
|
|
|
| PRICE |
|
|
|
| PRICEDISC |
|
|
|
| PRICEMAT |
|
|
|
| PV |
|
|
|
| RATE |
|
|
|
| RECEIVED |
|
|
|
| SLN |
|
|
|
| SYD |
|
|
|
| TBILLEQ |
|
|
|
| TBILLPRICE |
|
|
|
| TBILLYIELD |
|
|
|
| VDB |
|
|
|
| XIRR |
|
|
|
| XNPV |
|
|
|
| YIELD |
|
|
|
| YIELDDISC |
|
|
|
| YIELDMAT |
|
|
|
| Information Functions |
Supported |
Partially Supported |
Not Supported |
| CELL |
|
|
|
| ERROR.TYPE |
|
|
|
| INFO |
|
|
|
| ISBLANK |
|
|
|
| ISERR |
|
|
|
| ISERROR |
|
|
|
| ISEVEN |
|
|
|
| ISLOGICAL |
|
|
|
| ISNA |
|
|
|
| ISNONTEXT |
|
|
|
| ISNUMBER |
|
|
|
| ISODD |
|
|
|
| ISREF |
|
|
|
| ISTEXT |
|
|
|
| N |
|
|
|
| NA |
|
|
|
| TYPE |
|
|
|
| Logical Functions |
Supported |
Partially Supported |
Not Supported |
| AND |
|
|
|
| FALSE |
|
|
|
| IF |
|
|
|
| IFERROR |
|
|
|
| NOT |
|
|
|
| OR |
|
|
|
| TRUE |
|
|
|
| Lookup and Reference Functions |
Supported |
Partially Supported |
Not Supported |
| ADDRESS |
|
Last calculated value is preserved and the function may or may not be removed depending on the values used |
|
| AREAS |
|
|
|
| CHOOSE |
|
|
|
| AGGREGATE |
|
|
|
| COLUMN |
|
|
|
| COLUMNS |
|
|
|
| HLOOKUP |
|
|
|
| HYPERLINK |
|
|
|
| INDEX (array) |
|
|
|
| INDEX (reference) |
|
|
|
| INDIRECT |
|
|
|
| LOOKUP (array) |
|
|
|
| LOOKUP (vector) |
|
|
|
| MATCH |
|
|
|
| OFFSET |
|
|
|
| ROW |
|
|
|
| ROWS |
|
|
|
| TRANSPOSE |
|
|
|
| VLOOKUP |
|
|
|
| Math and Trigonometry Functions |
Supported |
Partially Supported |
Not Supported |
| ABS |
|
|
|
| ACOS |
|
|
|
| ACOSH |
|
|
|
| AGGREGATE |
|
|
|
| ASIN |
|
|
|
| ASINH |
|
|
|
| ATAN |
|
|
|
| ATAN2 |
|
|
|
| ATANH |
|
|
|
| CEILING |
|
|
|
| CEILING.PRECISE |
|
|
|
| COMBIN |
|
|
|
| COS |
|
|
|
| COSH |
|
|
|
| DEGREES |
|
|
|
| EVEN |
|
|
|
| EXP |
|
|
|
| FACT |
|
|
|
| FACTDOUBLE |
|
|
|
| FLOOR |
|
|
|
| FLOOR.PRECISE |
|
|
|
| GCD |
|
|
|
| INT |
|
|
|
| ISO.CEILING |
|
|
|
| LCM |
|
|
|
| LN |
|
|
|
| LOG |
|
|
|
| LOG10 |
|
|
|
| MDETERM |
|
|
|
| MINVERSE |
|
|
|
| MMULT |
|
|
|
| MOD |
|
|
|
| MROUND |
|
|
|
| MULTINOMIAL |
|
|
|
| ODD |
|
|
|
| PI |
|
|
|
| POWER |
|
|
|
| PRODUCT |
|
|
|
| QUOTIENT |
|
|
|
| RADIANS |
|
|
|
| RAND |
|
|
|
| RANDBETWEEN |
|
|
|
| ROMAN |
|
|
|
| ROUND |
|
|
|
| ROUNDDOWN |
|
|
|
| ROUNDUP |
|
|
|
| SERIESSUM |
|
|
|
| SIGN |
|
|
|
| SIN |
|
|
|
| SINH |
|
|
|
| SQRT |
|
|
|
| SQRTPI |
|
|
|
| SUBTOTAL |
|
|
|
| SUM |
|
|
|
| SUMIF |
|
|
|
| SUMIFS |
|
|
|
| SUMPRODUCT |
|
|
|
| SUMSQ |
|
|
|
| SUMX2MY2 |
|
|
|
| SUMX2PY2 |
|
|
|
| SUMXMY2 |
|
|
|
| TAN |
|
|
|
| TANH |
|
|
|
| TRUNC |
|
|
|
| Statistical Functions |
Supported |
Partially Supported |
Not Supported |
| AVEDEV |
|
|
|
| AVERAGE |
|
|
|
| AVERAGEA |
|
|
|
| AVERAGEIF |
|
|
|
| AVERAGEIFS |
|
|
|
| BETA.DIST |
|
|
|
| BETA.INV |
|
|
|
| BETADIST |
|
|
|
| BETAINV |
|
|
|
| BINOM.DIST |
|
|
|
| BINOM.INV |
|
|
|
| BINOMDIST |
|
|
|
| CHIDIST |
|
|
|
| CHIINV |
|
|
|
| CHISQ.DIST |
|
|
|
| CHISQ.DIST.RT |
|
|
|
| CHISQ.INV |
|
|
|
| CHISQ.INV.RT |
|
|
|
| CHISQ.TEST |
|
|
|
| CHITEST |
|
|
|
| CONFIDENCE |
|
|
|
| CONFIDENCE.NORM |
|
|
|
| CONFIDENCE.T |
|
|
|
| CORREL |
|
|
|
| COUNT |
|
|
|
| COUNTA |
|
|
|
| COUNTBLANK |
|
|
|
| COUNTIF |
|
|
|
| COUNTIFS |
|
|
|
| COVAR |
|
|
|
| COVARIANCE.P |
|
|
|
| COVARIANCE.S |
|
|
|
| CRITBINOM |
|
|
|
| DEVSQ |
|
|
|
| EXPON.DIST |
|
|
|
| EXPONDIST |
|
|
|
| F.DIST |
|
|
|
| F.DIST.RT |
|
|
|
| F.INV |
|
|
|
| F.INV.RT |
|
|
|
| F.TEST |
|
|
|
| FDIST |
|
|
|
| FINV |
|
|
|
| FISHER |
|
|
|
| FISHERINV |
|
|
|
| FORECAST |
|
|
|
| FREQUENCY |
|
|
|
| FTEST |
|
|
|
| GAMMA.DIST |
|
|
|
| GAMMA.INV |
|
|
|
| GAMMADIST |
|
|
|
| GAMMAINV |
|
|
|
| GAMMALN |
|
|
|
| GAMMALN.PRECISE |
|
|
|
| GEOMEAN |
|
|
|
| GROWTH |
|
|
|
| HARMEAN |
|
|
|
| HYPGEOMDIST |
|
|
|
| INTERCEPT |
|
|
|
| KURT |
|
|
|
| LARGE |
|
|
|
| LINEST |
|
|
|
| LOGEST |
|
|
|
| LOGINV |
|
|
|
| LOGNORM.DIST |
|
|
|
| LOGNORM.INV |
|
|
|
| LOGNORMDIST |
|
|
|
| MAX |
|
|
|
| MAXA |
|
|
|
| MEDIAN |
|
|
|
| MIN |
|
|
|
| MINA |
|
|
|
| MODE |
|
|
|
| MODE.MULT |
|
|
|
| MODE.SNGL |
|
|
|
| NEGBINOM.DIST |
|
|
|
| NEGBINOMDIST |
|
|
|
| NORM.DIST |
|
|
|
| NORM.INV |
|
|
|
| NORM.S.DIST |
|
|
|
| NORM.S.INV |
|
|
|
| NORMDIST |
|
|
|
| NORMINV |
|
|
|
| NORMSDIST |
|
|
|
| NORMSINV |
|
|
|
| PEARSON |
|
|
|
| PERCENTILE |
|
|
|
| PERCENTILE.EXC |
|
|
|
| PERCENTILE.INC |
|
|
|
| PERCENTRANK |
|
|
|
| PERCENTRANK.EXC |
|
|
|
| PERCENTRANK.INC |
|
|
|
| PERMUT |
|
|
|
| POISSON |
|
|
|
| POISSON.DIST |
|
|
|
| PROB |
|
|
|
| QUARTILE |
|
|
|
| QUARTILE.EXC |
|
|
|
| QUARTILE.INC |
|
|
|
| RANK |
|
|
|
| RANK.AVG |
|
|
|
| RANK.EQ |
|
|
|
| RSQ |
|
|
|
| SKEW |
|
|
|
| SLOPE |
|
|
|
| SMALL |
|
|
|
| STANDARDIZE |
|
|
|
| STDEV |
|
|
|
| STDEV.P |
|
|
|
| STDEV.S |
|
|
|
| STDEVA |
|
|
|
| STDEVP |
|
|
|
| STDEVPA |
|
|
|
| STEYX |
|
|
|
| T.DIST |
|
|
|
| T.DIST.2T |
|
|
|
| T.DIST.RT |
|
|
|
| T.INV |
|
|
|
| T.INV.2T |
|
|
|
| TDIST |
|
|
|
| TINV |
|
|
|
| TREND |
|
|
|
| TRIMMEAN |
|
|
|
| TTEST |
|
|
|
| VAR |
|
|
|
| VAR.P |
|
|
|
| VAR.S |
|
|
|
| VARA |
|
|
|
| VARP |
|
|
|
| VARPA |
|
|
|
| WEIBULL |
|
|
|
| WEIBULL.DIST |
|
|
|
| Z.TEST |
|
|
|
| ZTEST |
|
|
|
| Text Functions |
Supported |
Partially Supported |
Not Supported |
| ASC |
|
|
|
| CHAR |
|
Last calculated value is preserved and the function may or may not be removed depending on the values used |
|
| CLEAN |
|
|
|
| CODE |
|
Last calculated value is preserved and the function may or may not be removed depending on the values used |
|
| CONCATENATE |
|
|
|
| DOLLAR |
|
|
|
| EXACT |
|
|
|
| FIND |
|
|
|
| FINDB |
|
|
|
| FIXED |
|
|
|
| JIS |
|
|
|
| LEFT |
|
|
|
| LEFTB |
|
|
|
| LEN |
|
|
|
| LENB |
|
|
|
| LOWER |
|
|
|
| MID |
|
|
|
| MIDB |
|
|
|
| PHONETIC |
|
|
|
| PROPER |
|
|
|
| REPLACE |
|
|
|
| REPLACEB |
|
|
|
| REPT |
|
|
|
| RIGHT |
|
|
|
| RIGHTB |
|
|
|
| SEARCH |
|
|
|
| SEARCHB |
|
|
|
| SUBSTITUTE |
|
|
|
| T |
|
|
|
| TEXT |
|
|
|
| TRIM |
|
|
|
| UPPER |
|
|
|
| VALUE |
|
|
|
| YEN |
|
|
|
