The job
You have a workbook with a few sheets, or a Google Sheet a colleague shared, and you need answers: total paid by region across both quarters, average deal size per rep, which rows are missing a value. You want the numbers computed, not estimated, and you want to ask in plain language from the side panel.
Why this is hard without Sephir
Google Sheets, Excel Online and SharePoint draw their cells on a canvas. A chatbot sidebar that "reads the page" sees the menu bar and the title, never a cell. So people paste ranges into a chat window, lose the column headers, and get sums the model added up in its head, which is where the wrong totals come from. Multi-sheet workbooks make it worse: each paste is one sheet, and the cross-sheet question never gets asked.
How Sephir does it
- Open the Sephir side panel with
Cmd+Shift+S. - Attach the file (CSV, XLSX, XLS, TSV, ODS) with the paperclip, or paste the Google Sheets link in your message. A SharePoint or OneDrive download link works too when you are signed in.
- Ask the question. "Which region has the highest paid total across Q1 and Q2? Show each region." "Average Amount per Rep, paid rows only." "Rows where Status is empty."
Sephir loads every sheet of the workbook, describes the columns and their types, and answers with query_table: filters, group-bys, sums, averages, counts, min and max are computed by an engine and quoted back with the matched row count. Numbers written the European way (1.234,56), with currency signs or as percentages are understood.
What you get
A Markdown table with the computed figures, the sheet and row count it came from, and any assumption stated (for example that blank amounts were treated as zero). Ask a follow-up and it queries again rather than re-reading the file.
Limits
Reading only. Writing values back to a Google Sheet or a live Excel Online workbook needs Google or Microsoft sign-in and is not in this release. Per sheet, the first 5,000 rows are loaded; the answer says so when a sheet is longer.