Spreadsheets

Explore, edit and write-back.

Update records, plan forecasts, and collaborate right where your data lives. Write changes back to your databases and trigger workflows that keep work moving.

Try it yourself

Type a formula. Watch the chart follow.

This is the Spreadsheet visual in Trulyp Analytics. Change a forecast and the formula cells and the chart that uses the spreadsheet as its data source follow at once. Every save is written back to your database and shows up in the schema audits in WriteBackExtreme.

Floraya | Forecast 2026Saved 09:12
FLORAYA

Forecast 2026

Commercial planning / EUR reporting

Actual 2025

Primary data · EUR

Forecast 2026

Sum of the spreadsheet · EUR

Growth vs 2025

Forecast ÷ actual − 1

Forecast 2026 by region

Edit the quarters. Totals and growth are formulas.

Autosave on6 rows

Actual vs forecast

Reads Forecast 2026 (spreadsheet) · EUR thousands

Actual 2025Forecast 2026

Audits Forecast 2026 · WriteBackExtreme schema

0
MemberStatusRecordChangesCreated at
Changes you save appear here.

Click a forecast cell and type a number or a formula such as =C1*1.1. Press Enter to save.

Writeback

Plan and write back.

Sometimes you need to change the numbers, not just analyze them. Type budgets, targets and scenarios next to live actuals, edit cells or paste rows from Excel, and every change is written back to a table in your warehouse with a full audit trail. Your source data stays untouched.

Budget 2027Floraya · Sales planning

Budget 2027 by region

Autosave on
FLORAYA.PLANNING.BUDGET_2027Writeback table in Snowflake

Source FLORAYA.SALES.ACTUALS is read only. Nothing is written there.

Audits

    Try it: click a Budget or Target cell and type, orCopying cells from Excel and pressing Ctrl+V works too. Actuals are locked.

    Audit logs

    Every change, on the record.

    Unlike Excel, every change is tracked: who edited what, and when. You get a complete audit trail for compliance and rollback, without the version confusion of emailed files. For a longer-running activity record, keep your audits in your own database.

    Audits

    Track all changes made from the extension and management console.

    Hover or tap a record to see what was saved. Filter by member or status, or export the log to CSV.

    Add Data form

    Capture what your data is missing.

    Some input doesn't belong in a grid. Add an Add Data form to your app and relate it to your data: select a product in a chart or table and the form fills in its key and loads what was saved for it. Add a supplier, a reorder level or a note, and the record is written back to a dataset on your own connection. Use those fields in your charts and tables right next to the live source data, which stays untouched.

    Floraya | Product planning

    Saved 16/10/2026, 16:14:18

    Reorder level by product

    Product details

    Supplier
    Seasonal

    Click a bar or enter a product name, then fill in the form and save.

    Connect to data wherever it lives.

    Read from and write back to major databases, including Snowflake, Databricks, Amazon Redshift, Google BigQuery, and SAP HANA. Connect to Tableau VDS or build your own semantic models in Trulyp. More semantic providers are on the way.

    Supported databases

    Keep work moving with workflows.

    Turn data changes into action with Zapier, Salesforce Flow, or Microsoft Power Automate. Choose a trigger, select the data to send, and automate the next step. Connect custom workflows through webhooks or stored procedures.

    Jane saves a new forecast proposal in Trulyp, a workflow sends it through Zapier, and Slack posts “Jane has created a new forecast proposal, please review!” in #sales-planning.

    No data leaves your dashboard

    Write back to your own databases

    Set permissions for full control

    SSO available

    Two ways to write back

    Write back where your team works.

    Edit in the Spreadsheet visual in Trulyp Analytics, or with the WriteBackExtreme extension inside the Tableau dashboards you already have. Both write to your own database.

    In Trulyp Analytics

    The Spreadsheet visual.

    Everything people expect from a spreadsheet, connected to your data and your charts.

    • Excel-style formulas

      Type =C2*1.1 or =SUM(C2:F2) in a cell, then drag the fill handle to copy it down. Trulyp saves the formula and the result.

    • Filter and sort

      Work through large tables the Excel way, then update values in place and write them back.

    • Autosave, undo and redo

      Every edit saves on its own. Undo and redo restore the saved values, and each change lands in the audits.

    • Lock columns

      Show actual months next to an editable forecast without allowing edits. Typing, paste, fill and delete skip locked columns.

    • Create the table from the visual

      Choose a connection, name the table and click Create table. Add Number or Text columns later; Trulyp creates them in your database.

    • Feeds your other charts

      Use “Sales Plan (spreadsheet)” as the datasource for other charts. They update as soon as you save.

    • Cell colors and number formats

      Color cells with one color, by dimension or as a gradient by value. Show numbers as K, M or B, with currency, prefix or suffix.

    • Built by Vizzy

      Ask Vizzy for an editable spreadsheet and it creates the visual and its writeback table for you.

      Meet Vizzy →