Publish a Google Sheet (or any CSV) to the web and paste the link. Show it as a table, list, one big KPI cell or a progress bar toward a target cell. Edit the sheet and the screens follow.
What it does
- Table, list, KPI number or progress designs
- Cell coordinates, prefix/suffix
- Refresh every 1–120 minutes
- Works with Google Sheets, Excel Online CSV and any CSV URL
How to add the Live sheet (Google Sheets) widget
- 1Open a screen or layout in the console and click Add.
- 2Choose Live sheet (Google Sheets) from the widget list and drag it onto the canvas.
- 3Fill in the settings in the inspector, pick a design and press Publish — the screen updates within a second.
Frequently asked questions
Is my sheet public?
Only the published CSV is public — publish a separate tab with just the data you want to show.
More widgets in Live data
Current weather
Live conditions for your city — no API key.
Weather forecast
3–7 day forecast: tiles, rows, today + next days or a strip.
Rain forecast
The next two hours in 15-minute steps.
Air quality
European AQI, PM2.5/PM10, UV and pollen for your city.
Sun & moon
Sunrise, sunset, golden hour and moon phase.
News & RSS
Headlines with pictures from curated sources or any feed.