AI Sheets

Yes. Upload a CSV file (up to 10 MB) when creating a new sheet or into an existing one, import from a public Google Sheets URL set to 'Anyone with the link', or paste rows directly from Excel or Google Sheets into the grid. Google imports have a 30-second fetch timeout and a 50 MB content cap.

The default limit is 5,000 rows per sheet, and an administrator can configure it anywhere from 100 to 50,000. Each sheet supports up to 100 columns, and each row is capped at 64 KB of data.

AI can generate a column schema from a description, answer natural-language questions about your data (filters, sorts, summaries, charts), and compute exact aggregates — counts, totals, averages, group-by breakdowns — as SQL over every row, with provenance. It can also edit your data on instruction: update, add, or delete rows, add or rename columns, and clean up duplicates, always through a preview you confirm and can undo. Beyond that, it fills whole columns in the background (classify, extract, translate, normalize), writes formula expressions from plain English, maps CSV headers on import, builds automation rules from a written description, and runs AI automation actions (fill-on-new-row, scheduled digests, anomaly alerts). The Ask AI agent brings the same read and write capabilities into chat, with confirmation required for every write. Administrators control all of this per business with a master AI switch plus separate toggles for AI edits, enrichment, and AI automations.

Yes — as formula columns. Add a column of type Formula and write an expression that computes per row: arithmetic (+, -, *, /, %), comparisons, if(), round(), abs(), min(), max(), sum(), concat(), upper(), lower(), trim(), coalesce(), days_between(), today(), year(), month(), day(), and more. You can also just describe the formula in English ("20% tip on total") and AI writes the expression for you, with a live preview against your data. Values are computed on the fly — they update automatically as row data changes and are included in exports. There are no per-cell formulas like =SUM(A1:A5) and no cross-sheet references; for whole-column totals, ask the AI ("what is the total by category?") and get an exact computed answer.

Yes, with guardrails. When you ask for a change ("mark all overdue rows as escalated", "delete the duplicate contacts"), the AI proposes a structured edit; the system selects the target rows deterministically and shows you a preview — how many rows are affected and sample before/after values — before anything is written. You confirm to apply, and every applied AI edit is snapshotted to the activity log so it can be undone with one click. The AI never writes directly to your rows, edits are capped at 1,000 rows per operation, and an administrator can disable AI edits entirely while keeping AI questions and analysis on.

Yes. Share a sheet internally with viewer, editor, or owner roles; edits sync live between users. You can add cell- and row-level comments, and—if your administrator has enabled public links—generate a read-only public URL for people outside your business.

AI Sheets requires a license and is opt-in per tenant—an administrator enables it for your business from the Apps Marketplace. It is disabled by default until then. Contact your MangoApps administrator about enabling it for your organization.

Forms collects structured submissions from many respondents through a published form you distribute. AI Sheets is a working spreadsheet you and your team edit directly—rows, columns, imports, and analysis. They connect through the Forms-to-Sheet bridge, which builds a sheet's columns automatically from an existing form's fields so you can manage responses in a grid.