Documentation
Getting started with Sumio
Talk to your data in three steps. Here's how it works and what you can ask for.
Step 1
Upload a file
Drag in a .xlsx, .xlsm, or .csv (or click “Try sample data” in the Workspace).
Step 2
Type an instruction
In plain language — English, Hindi, Urdu, or a mix. e.g. “remove duplicate rows on Email, then sort by revenue desc.”
Step 3
Review & download
Check the AI's plan and confidence, run it, then download a file with live Excel formulas.
Example instructions
Copy one, open the Workspace, paste, run. Any language works.
Remove duplicate rows on Email, then sort by Revenue descendingFilter Region equals North and Price greater than 500Add a column Total = {Units} * {Unit Price}, format as currencyरेवेन्यू के हिसाब से घटते क्रम में सॉर्ट करो और टॉप 10 दिखाओMerge all sheets into one table and flag rows missing a GST numberPrompt tips
- Be specific: name the column and the comparison — “Filter Region equals North.”
- Chain steps in one go: separate them with “then”, new lines, or numbers.
- Reference real column names; Sumio asks a clarifying question if something is ambiguous.
- Numbers stay numbers and dates stay dates — formulas and formatting are preserved on download.
Supported operations
SortFilterRemove duplicatesFill / drop blanksAdd formula columnLookup (across sheets)Aggregate / group byFind & replaceRename / drop / select columnsFormat cells (currency, %, dates)Merge & combine sheetsTrim spacesKeep top NEdit cells inline
API access
Everything the app does goes through a documented HTTP API. The interactive reference (OpenAPI / Swagger) is generated straight from the running engine, so it can't drift from reality.
Open the API referenceManage keys under API Platform in the app. Production servers may require a key.