Spreadsheet link
A link that Excel, Google Sheets or Power BI use to fetch your active spools as CSV. It is read-only.
On this page
Create the link
Under Settings, Devices & keys, create a key of the type Spreadsheet. You get a link that can only read and returns only the active spools.
Spools as CSV
GET/feed/{key}/spools.csv
The key is in the path, no header is needed. Columns: id, number, title, manufacturer, material, finish, color_, color_, remaining_, spool_, fill_, location. Comma as separator, period as decimal mark, UTF-8 without BOM. A spool name that looks like a formula does not become a formula in the spreadsheet. Errors come back as short plain text.
Parameters
key- A key of the type Spreadsheet. Other keys do not work here.
curl "https://spooly.eu/api/v1/feed/spk_dein_tabellen_schluessel/spools.csv"id,number,title,manufacturer,material,finish,color_hex,color_name,remaining_grams,spool_size_grams,fill_level,location
7f3c2a10-5e1b-4c8e-9a44-2d6b1f0c7e21,1,Jade White,Bambu Lab,PLA,matte,#E8E9DF,342,1000,low,Schrank 01 · Fach vorneIn your program
| Program | How you get the link |
|---|---|
| Google Sheets | A formula, see below. |
| Excel | Data from the web through Power Query. Set the locale to English (United States) when importing, otherwise Excel reads the period wrong. |
| Power BI | Data from the web with the same link, locale English (United States). |
=IMPORTDATA("https://spooly.eu/api/v1/feed/spk_dein_tabellen_schluessel/spools.csv", ",", "en_US")The formula is for Google Sheets with English settings. If your Google Sheets is set to German, separate the parts with a semicolon instead of a comma.