Source: https://spooly.eu/en/docs/api/spreadsheet-link

# Spreadsheet link

A link that Excel, Google Sheets or Power BI use to fetch your active spools as CSV. It is read-only.

## 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.

> Do not share publicly: Anyone with the link sees your spool list without signing in. You can revoke it at any time.

## 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_hex`, `color_name`, `remaining_grams`, `spool_size_grams`, `fill_level`, `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` (Path): A key of the type Spreadsheet. Other keys do not work here.

```bash
curl "https://spooly.eu/api/v1/feed/spk_dein_tabellen_schluessel/spools.csv"
```

Response (200):

```
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 vorne
```

## In 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). |

Google Sheets: formula:

```
=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.