PowerSheet.ai Screenshots
Excel Content Add-in, PowerSheet.ai Online
with Smart Reports, Forms, Tables & Dashboards
Easy Collaboration & Fuzzy Lookup and Automation for
Business Intelligence, Analytics, Finance, Accounting, Reconciliation & Reporting 
    Subscribe
    for Excel Content Add-in
    Early Access Release Notice

PowerSheet.ai Online Features Overview Video

Key Features & Benefits

  • No Install, 100% Excel
    • Simply insert PowerSheet.ai Excel Content Add-in into your spreadsheet in 1-click from "Insert > Get Add-ins" and anyone who opens it with Excel 2013+ or Excel Online or for iPad will automatically benefit from its features
  • No Code
    • BI & Automation without learning VBA, SQL, DAX, PowerQuery, Python, JavaScript or Microsoft Flow.
    • Easy, No Code BI and Smarts Reports, Forms & Databases – All 100% in Excel
  • No IT Needed
    • No coding or IT involvement required with easy AI guided creation & use of 100% Excel spreadsheet solutions for your BI, reporting needs, with PowerSheet.ai enhanced Excel and Excel Online spreadsheets, enabled simply by Insert > Get Add-ins available for Office 2013+, Office 365, Office for iPad and Office Online.
  • Single Sign-on & Active Directory
    • Single Sign-on without hassle of user account creation & management, with list of permitted email addresses and option to allow anyone with a corporate email account to use.
  • Dedupe
    • Remove near duplicate rows with fuzzy lookup / matching, intelligently considering other fields. "Suggestion" column shown when detects likely issue. Or use Dedupe / Duplicate Removal tool for data consolidation.
  • AI Quick Fix Suggestions
    • AI powered Quick or Auto Fix suggestions shown next to rows and values proactively or on-demand with Fuzzy AI detects likely duplicates, misspellings, abbreviations, old / alternative names, categories, account #'s or ID's.
  • Power Sheets
    • Embed rich, interactive smart tables. Tabbed Pivot tables.
  • Tabbed Pivot Tables
    • Automatically show "Saved View Tabs" for Saved Views of your Pivot Tables & Excel Tables and
    • Show different view tabs on Smart, Rich Pivot Tables for saved views.
  • Tabbed Report / Table Views
    • Insert a Power Sheet as a Tabbed Alternative to Pivot Tables
    • Replace dozens of copies of Spreadsheets, Pivot Tables, Slicers, Charts & Data Tables with a single Power Sheet embedded into your Report / Dashboard / Power Sheet / Power Table / Pivot Table.
    • Automatically show "Saved View Tabs" as a far easier, more powerful alternative to Slicers, replacing need
    • Saved Views of your Pivot Tables & Excel Tables and
  • Drag-drop
    • Drag-drop grouping, sorting, filtering, pivoting, reordering of rows and columns, applying of tags or labels to rows and saving rows into Selection Reports or Row Lists.
  • Easy Pivot Tables
  • Online Report Creation, BI & Report
    • Our Enterprise edition includes backed by security and performance of Microsoft Azure under the hood, for storage, hosting, syncing and publishing and online access with PowerSheet.ai Online to your data. Pro edition includes free Azure-based templates sharing and syncing.
  • Data Consolidation
  • Web Publish
  • Auto Reports
  • Filters
  • Collaboration
  • Smart Reports & Report Design
  • Report Templates
  • Show/Hide Rows
    • Include Rows in Selection Reports via checkbox selection or tagging or exclude, remove, hide or delete rows from all or some views, reports, subtotals and data, based on auto determined key columns.
      • optionally applying removing from output Tables or In-place synced input/output Source Table / Data Rows in Excel.
  • Link, Sync & Update Excel Rows
    • output Tables or In-place synced input/output Source Table / Data Rows in Excel.
  • Ad-hoc or Free-form Analysis and Drill-down
  • Export, Email & Print
    • Easily export all data, with or without BI data transformations to Excel, CSV, or Text. Print or Share from within Excel. Include auto-joined tables, edits, comments, tags, checkbox selection, for any Saved View or Report, or for all data or all Views/Reports at once. Export Templates (Report and BI Setup) or Workspaces (including Data) to files or Cloud to share. Share links or files via email, shared folder or cloud drive. Print views and reports.
    • from one or more Saved Views, Reports, All data and/or current dynamic user-configurable view, based on filtering, search, drag-drop grouping, and more, for Groups, Data Rows. Includes support for Auto Joining of tables.
  • Admin Tools
  • Tag Rows with Checkboxes, Selection Reports & Row Tagging
    • Use checkboxes, right click, at tags & labels, or drag-drop to easily add rows to Selection Reports or Lists, or assign tags (labels or folders). For Task Assignment, Follow-up Report, Reconciliation or anything.
  • Smart Comments
    • Add comments to rows, which stay with them even for rows which move or change, like with Power Query or Hyperion Refreshes, based on AI detection of key column(s).
  • Drag-drop Reordering
  • Dynamic Reports
  • Selection Reports
    • Rows you checkbox select, apply Tags or Labels to or drag-drop onto Tags or Selection Reports will stay there even if you refresh data, edit source rows or refresh source queries and connections. You can filter a table or report based on one or more tags or other columns and criteria. Then click + in Views/Reports tab bar shown above any Table or Report to add as a "Saved View" for 1-click dynamic smart report creation which always stays up-to-date.
  • Fuzzy Search & Power Filtering
    • Use easy boolean and/or criteria and contains/equals/greater than or less than criteria
  • Filters Sidebar & Auto Slicers
  • Dynamic Selection Reports
    • Search, Filter, Group and Sort, then save your view to the Saved Views & Reports tab bar shown above Power Sheet or Smart Power Table easily inserted into your Excel workbooks. Always up-to-date. Each row can have multiple tags or labels assigned to it.
    • Like Smart Comments, these stick with the row even if order or other columns changes, based on automatically detected IDs.
    •  with different Saved Views ow Selection Reports based on Tags, Checkbox Selection, Filtering, Grouping and other options.
  • Auto Row Keys & IDs
    • Automatically detects which column, or combination of columns, represents a unique key for your rows, so that your Row Selections, Tagging, Comments, Reconciliation and Decisions (for Quick Fix and Near Duplicate suggestions) stick with the row, even if it moves or changes, manually or when refreshing Power Query, Hyperion, Data Connection or Linked Tables or SQL or Access Databases
  • Single Sign-on
    • No user accounts needed. With Unlimited user, company-wide licenses, anyone with a corporate email account or device can use without separate login or per-user licensing.
  • No Sign-on for Viewers / Collaborators
  • Unlimited Users
  • Easy Business Intelligence
    • Business intelligence simplified. Get easy, lightweight BI dashboards, calculated fields, smart automatic data transformations (without Power Query).
  • Collaboration
  • Dashboards*
    • Include Interactive Charts in each View Tab for Report and Smart Table views
  • Office 2013+, Mac, Online & iPad
    • Full-featured support for Excel Office 365, Office 2019 and Office 2016 for Windows and Mac, Office Online, and Office for iPad. Core features supported for Office 2013.
  • PowerPoint & OneNote*
    • Easy copy & paste any current Power Sheet view or report into other Office Apps*, including PowerPoint & OneNote, online forms or docs, websites.
    • Upcoming Content Add-ins for Power Point and OneNote will provide interactive full-featured embedding as interactive content into presentations and pages, backed by free Azure-based data storage with PowerSheet.ai Online, Excel Online or optionally synced with Excel.
  • Publish, PDF, Print & Copy-Paste Embed
    • Save to image (as SVG, PNG or BMP), Print (online or in Excel), copy-paste as image into web, OneNote, emails or anywhere else, save or print to PDF via Excel.
    • Cloud-hosted or Excel Online Save Web Publish as image into PowerPoint, Upcoming support for embedded interactive Power Sheets into PowerPoint (.pptx) presentations and OneNote pages, with cloud synced data or
  • Backwards Compatible
    • Workbooks with Content Add-in can be opened with any version of Excel without issue. Power Sheet / Power Table Content Add-in will appear as an inserted image. Output data rows/tables (or in-place edited linked input/output table) will remain as is automatically kept in sync.
  • Install Free
  • Interactive Charts*
    • Click on bars and slices of charts to filter tables and reports or drill-down, as an intuitive alternative to Auto Slicers and Filter Sidebar
  • Spark Lines & Inline Charts
  • Conditional Formatting
  • PowerExcel.ai Integration
    • Visit PowerExcel.ai to learn more about our PowerExcel.ai Add-in for Excel, which is an install-free (workbook embedded or 1-click) Office 365 JavaScript Add-in extending Microsoft Excel with dozens of new Power Tools, including Power Query, Slicers & Pivot Table Generation & Templates and dozens of new Power Functions for Excel Formulas (for Dynamic Array formulas, Power Lookups, PowerSQL & beyond) and automated Data Prep, including Spreadsheet Merge, Split & Pivot.
  • Microsoft Access Integration with PowerAccess
    • Visit PowerAccess.net to learn more about our PowerAccess All-in-One Toolset (Add-in) & Framework (install-free referenced/embedded Class Library) which extends Microsoft Access with Power Reports, dozens of new tools (like Global Find & Replace and new Power SQL Editor) as well with its install-free Class Library providing 800+ new VBA Macro and Query functions, and dozens of common MS Access database features out-of-box to reduce need for boilerplate coding, along with support for JavaScript Macros and C# like TypeScript Macros with integrated Script Editor, and ability to use from VBA any of the 150,000 JavaScript libraries and Web Services / APIs, ranging from QuickBooks and Microsoft Graph to FTP and Active Directory security.

 * Upcoming Feature

Customer Testimonials & Featured in News

"We’ve been using PowerSheet.ai for a year and it has saved our accounting team about 40 hours a month on bank reconciliations. And it’s continually getting easier to use with the constant stream of improvements. I’d recommend it for every business. A user can get up to speed in less than an hour. Incredible ROI."

Brian Morales, 
​Senior Accountant, Andover Properties, LLC

Learn More about Power Sheet AI