You can use most of Excel’s built-in functions in the spreadsheets you want to convert to web apps. During conversion, SpreadsheetConverter generates the program code required for the function to work in a web page.
SpreadsheetConverter can convert Excel functions for mathematical operations, text operations and advanced lookup operations into web format, automatically creating JavaScript or JScript program code.
If you are concerned that your spreadsheet may not be fully supported by SpreadsheetConverter, just send it to us and we’ll test if we can convert it to a webpage for you, for free.
You may use any output from SpreadsheetConverter, including automatically generated program code, for as long as you like without any extra cost except for the one-time license fee. Read more in the license agreement.
Here is the list of functions currently supported in the converted web pages.
| Function name | Std Ed | Pro Ed | Arguments |
|---|---|---|---|
| abs | Supported | Supported | 1 |
| accrint | Supported | 6, 7 | |
| acos | Supported | Supported | 1 |
| acosh | Supported | Supported | 1 |
| and | Supported | Supported | > 0 |
| asc | Supported | Supported | 1 |
| asin | Supported | Supported | 1 |
| asinh | Supported | Supported | 1 |
| atan | Supported | Supported | 1 |
| atan2 | Supported | Supported | 2 |
| atanh | Supported | Supported | 1 |
| avedev | Supported | Supported | > 0 |
| average | Supported | Supported | > 0 |
| averagea | Supported | Supported | > 0 |
| bessely | Supported | 2 | |
| betadist | Supported | 3, 4, 5 | |
| bin2dec | Supported | 1 | |
| bin2hex | Supported | 1,2 | |
| bin2oct | Supported | 1,2 | |
| binomdist | Supported | 4 | |
| ceiling | Supported | Supported | 2 |
| char | Supported | Supported | 1 |
| chidist | Supported | 2 | |
| chiinv | Supported | 2 | |
| choose | Supported | Supported | > 1 |
| clean | Supported | Supported | 1 |
| code | Supported | Supported | 1 |
| column | Supported | Supported | 0, 1 |
| columns | Supported | Supported | 1 |
| combin | Supported | Supported | 2 |
| concatenate | Supported | Supported | > 0 |
| confidence | Supported | 3 | |
| correl | Supported | 2 | |
| cos | Supported | Supported | 1 |
| cosh | Supported | Supported | 1 |
| count | Supported | Supported | > 0 |
| counta | Supported | Supported | > 0 |
| countif | Supported | Supported | 2 |
| covar | Supported | 2 | |
| cumipmt | Supported | 6 | |
| cumprinc | Supported | 6 | |
| date | Supported | Supported | 3 |
| datedif | Supported | Supported | 3 |
| datevalue | Supported | Supported | 1 |
| day | Supported | Supported | 1 |
| days360 | Supported | Supported | 2, 3 |
| db | Supported | Supported | 4, 5 |
| ddb | Supported | Supported | 3, 4, 5 |
| dec2bin | Supported | 1,2 | |
| dec2hex | Supported | 1,2 | |
| dec2oct | Supported | 1,2 | |
| degrees | Supported | Supported | 1 |
| delta | Supported | 1, 2 | |
| disc | Supported | 4, 5 | |
| dollar | Supported | Supported | 1, 2 |
| dollarde | Supported | 2 | |
| dollarfr | Supported | 2 | |
| edate | Supported | 2 | |
| effect | Supported | 2 | |
| eomonth | Supported | 2 | |
| erf | Supported | 1,2 | |
| erfc | Supported | 1 | |
| even | Supported | Supported | 1 |
| exact | Supported | Supported | 2 |
| exp | Supported | Supported | 1 |
| fact | Supported | Supported | 1 |
| FALSE | Supported | Supported | 0 |
| fdist | Supported | 3 | |
| find | Supported | Supported | 2,3 |
| finv | Supported | 3 | |
| fisher | Supported | 1 | |
| fisherinv | Supported | 1 | |
| fixed | Supported | Supported | 1, 2, 3 |
| floor | Supported | Supported | 2 |
| forecast | Supported | 3 | |
| ftest | Supported | 2 | |
| fv | Supported | Supported | 2, 3, 4, 5 |
| fvschedule | Supported | 2 | |
| gammaln | Supported | 1 | |
| hex2bin | Supported | 1,2 | |
| hex2dec | Supported | 1 | |
| hex2oct | Supported | 1,2 | |
| hlookup | Supported | Supported | 3, 4 |
| hour | Supported | Supported | 1 |
| hyperlink | Supported | Supported | 1,2 |
| hypgeomdist | Supported | Supported | 4 |
| if | Supported | Supported | 2,3 |
| iferror | Supported | Supported | 2 |
| index | Supported | Supported | 2,3 |
| int | Supported | Supported | 1 |
| intercept | Supported | 2 | |
| intrate | Supported | 4, 5 | |
| ipmt | Supported | Supported | 4, 5, 6 |
| irr | Supported | Supported | 1, 2 |
| isblank | Supported | Supported | 1 |
| iserr | Supported | Supported | 1 |
| iserror | Supported | Supported | 1 |
| iseven | Supported | Supported | 1 |
| islogical | Supported | Supported | 1 |
| isna | Supported | Supported | 1 |
| isnontext | Supported | Supported | 1 |
| isnumber | Supported | Supported | 1 |
| isodd | Supported | Supported | 1 |
| ispmt | Supported | Supported | 4 |
| isref | Supported | Supported | 1 |
| istext | Supported | Supported | 1 |
| large | Supported | Supported | 2 |
| left | Supported | Supported | 1, 2 |
| len | Supported | Supported | 1 |
| ln | Supported | Supported | 1 |
| log | Supported | Supported | 1,2 |
| log10 | Supported | Supported | 1 |
| loginv | Supported | 3 | |
| lognormdist | Supported | 3 | |
| lookup | Supported | Supported | 2,3 |
| lower | Supported | Supported | 1 |
| match | Supported | Supported | 2, 3 |
| max | Supported | Supported | > 0 |
| mid | Supported | Supported | 3 |
| min | Supported | Supported | > 0 |
| minute | Supported | Supported | 1 |
| mirr | Supported | Supported | 3 |
| mod | Supported | Supported | 2 |
| month | Supported | Supported | 1 |
| mround | Supported | 2 | |
| n | Supported | Supported | 1 |
| na | Supported | Supported | 0 |
| negbinomdist | Supported | 3 | |
| networkdays | Supported | Supported | 2,3 |
| nominal | Supported | 2 | |
| normdist | Supported | 4 | |
| norminv | Supported | 3 | |
| normsdist | Supported | 1 | |
| normsinv | Supported | 1 | |
| not | Supported | Supported | 1 |
| now | Supported | Supported | 0 |
| nper | Supported | Supported | 2, 3, 4, 5 |
| npv | Supported | Supported | >1 |
| oct2bin | Supported | 1,2 | |
| oct2dec | Supported | 1 | |
| oct2hex | Supported | 1,2 | |
| odd | Supported | Supported | 1 |
| or | Supported | Supported | > 0 |
| pearson | Supported | 2 | |
| percentile | Supported | 2 | |
| percentrank | Supported | 2, 3 | |
| permut | Supported | 2 | |
| pi | Supported | Supported | 0 |
| pmt | Supported | Supported | 3, 4, 5 |
| power | Supported | Supported | 2 |
| ppmt | Supported | Supported | 4, 5, 6 |
| pricedisc | Supported | 4, 5 | |
| product | Supported | Supported | > 0 |
| proper | Supported | Supported | 1 |
| pv | Supported | Supported | 2, 3, 4, 5 |
| quartile | Supported | 2 | |
| quotient | Supported | 2 | |
| radians | Supported | Supported | 1 |
| rand | Supported | Supported | 0 |
| randbetween | Supported | Supported | 2 |
| rank | Supported | Supported | 2, 3 |
| rate | Supported | Supported | 3, 4, 5, 6 |
| replace | Supported | Supported | 4 |
| rept | Supported | Supported | 2 |
| right | Supported | Supported | 1, 2 |
| roman | Supported | Supported | 1,2 |
| round | Supported | Supported | 2 |
| rounddown | Supported | Supported | 2 |
| roundup | Supported | Supported | 2 |
| row | Supported | Supported | 0, 1 |
| rows | Supported | Supported | 1 |
| rsq | Supported | 2 | |
| search | Supported | Supported | 2, 3 |
| second | Supported | Supported | 1 |
| sign | Supported | Supported | 1 |
| sin | Supported | Supported | 1 |
| sinh | Supported | Supported | 1 |
| sln | Supported | Supported | 3 |
| slope | Supported | 2 | |
| small | Supported | Supported | 2 |
| sqrt | Supported | Supported | 1 |
| standardize | Supported | 3 | |
| stdev | Supported | Supported | > 0 |
| stdeva | Supported | Supported | > 0 |
| stdevp | Supported | Supported | > 0 |
| stdevpa | Supported | Supported | > 0 |
| substitute | Supported | Supported | 3,4 |
| subtotal | |||
| sum | Supported | Supported | > 0 |
| sumif | Supported | Supported | 2,3 |
| sumproduct | Supported | Supported | > 0 |
| sumsq | Supported | Supported | > 0 |
| syd | Supported | Supported | 4 |
| t | Supported | Supported | 1 |
| tan | Supported | Supported | 1 |
| tanh | Supported | Supported | 1 |
| text | Supported | Supported | 2 |
| time | Supported | Supported | 3 |
| timevalue | Supported | Supported | 1 |
| today | Supported | Supported | 0 |
| trim | Supported | Supported | 1 |
| trimmean | Supported | 2 | |
| TRUE | Supported | Supported | 0 |
| trunc | Supported | Supported | 1,2 |
| upper | Supported | Supported | 1 |
| value | Supported | Supported | 1 |
| var | Supported | Supported | > 0 |
| vara | Supported | Supported | > 0 |
| varp | Supported | Supported | > 0 |
| varpa | Supported | Supported | > 0 |
| vlookup | Supported | Supported | 3, 4 |
| weekday | Supported | Supported | 1, 2 |
| weibull | Supported | 4 | |
| workday | Supported | 2,3 | |
| xirr | Supported | 2,3 | |
| xnpv | Supported | 3 | |
| year | Supported | Supported | 1 |