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 |
webservice | Supported for JSON | 1 | |
weekday | Supported | Supported | 1, 2 |
weibull | Supported | 4 | |
workday | Supported | 2,3 | |
xirr | Supported | 2,3 | |
xnpv | Supported | 3 | |
year | Supported | Supported | 1 |