Create your spreadsheet
In JSON, using our HTTP API.
| A | B | |
| 1 | Gross income | Item(s) sold |
| 2 | =SUM(sale.value) | =COUNT(sale) |
| 3 | ||
| 4 | Net income | Tax rate |
| 5 | =A2*(1-B5) | =0.3 |
| 6 | ||
| 7 | Average sale | Biggest sale |
| 8 | =A2/B2 | =MAX(sale.value) |
Push your records
No schema, just use your raw JSON data.
Export the result
In JSON or CSV.
| A | B | |
| 1 | Gross income | Item(s) sold |
| 2 | ||
| 3 | ||
| 4 | Net income | Tax rate |
| 5 | 0.3 | |
| 6 | ||
| 7 | Average sale | Biggest sale |
| 8 |
Include spreadsheetdb.js
To compute spreadsheets from your web pages.
spreadsheetdb.get({
spreadsheet: "sales",
key: "aGVsbG93b3JsZAo",
cb: function(error, spreadsheet) {
// ...
}
});
Build charts
On your web pages, using any library.
Hook to external services
Make HTTP requests directly into your cells.
| A | |
| 1 | =JSONGET("example.com/foo.json") |
| 2 | =JSONLOOKUP(A1, "foo", "bar") |
| A | |
| 1 | {"foo": {"bar": 42, "baz": 43}} |
| 2 | 42 |
Overview
HTTP API
Use our HTTP API to manipulate your spreadsheets and push your records.
Complete documentation
To help you build your project step by step, just follow the guide.
Free plan
That allows you to test SpreadsheetDB with all the features since it is only volume limited. See the pricing page for more details.
Records aggregation
Use the available functions to aggregate and filter your records directly into your spreadsheets.
99.9% uptime
SpreadsheetDB includes a 99.9% uptime guarantee with all paid plans. For more information you can read our Terms of Service.
Simple demo
Available on Github.