data1.io uses a java based spreadsheet which is compatible with MS Excel, therefore Excel files can be uploaded into data1.io and used as frontend for the collector users.
Unfortunately, not all functions from MS Excel are supported in the data1.io Web Client. This is the list of the (known) unsupported Excel functions:
- Grouping of rows and columns (+/- icons)
- Charts and probably Sparklines
- PivotTables and PivotCharts
- Some (newer) formula functions
UNIQUE(), ... - Entry of formulas
a. Cell references in the formula editor cannot be set by clicking the requested cell
b. Formulas cannot be copied by pulling the green right bottom corner - Adhoc aggregations (sum, average, count) in the status bar for the marked cells
- Images sometimes are not rendered
Furthermore - probably not surprisingly - Macros, VBA Code, Power Queries and Power Pivot Datamodels are not supported.
In some cases the height of a row can be changed.