Power Sheet can even embed a secure database into your Excel .XLSX file, providing row/column-level user access control, along with single sign-on (or with no login, based on Active Directory or Enterprise Login or your Office login), along with Slack-like collaboration tools with threaded comments, row sharing/assignments, and email and in-app notifications, along with Google Docs-easy sharing and fine-grained access control.  You can even provide user-tailored views and dynamically and securely show, hide or restrict editing of different dynamic rows, columns and view tabs (for different tables, reports and forms).

 

This makes it possible for you to email out or share a single Excel workbook with automatic data entry forms, with the security of knowing each person will only be able to see and edit those tables, reports, forms, rows and columns which they are supposed to have access to, or which they had created themselves, with automatic on/offline editing merging (without having to store in SharePoint) and row/column-level access control based on email address matched to Created By (Automatic), Department or Account columns and hierarchies (together with Active Directory and SSO).

 

Just by enabling Cloud Sync for you Power Sheet-enhanced Excel workbook, you can get Real-time Collaborative Editing (anywhere, even for emailed copies of workbooks outside of SharePoint) and organization-wide sharing and syncing of data (with Power Sheet Cloud or On-Premises) with Intelligent Versioning (even for moved/renamed/resorted rows and columns, fuzzy matching, and per row/sheet/table version history and edit/access logs and automatic Last Created/Edited By Columns) – providing the benefits of centralized storage without sacrificing the ease of use, power and flexibility of Excel, or the hundreds of add-ins and connectors available for it.

 

Power Sheet also brings Auto Web Publishing (for private links to share your reports, dashboards, spreadsheets, apps, and automatic data entry forms) for cloud-synced workbooks. Power Sheet can also be embedded into PowerPoint presentations for (for the first time ever) truly interactive, always up-to-date data, reports and visuals, with dynamic slicing, filtering and drill-down.

 

Power Sheet makes it easy to share, collect and collaborate on data, spreadsheets, templates and reports organization-wide, and, with unlimited free users and no user licenses required, even outside of your organization. It auto-generates private web sharing links with auto-published apps, reports, dashboards and data entry forms for your cloud-synced Excel spreadsheets.

 

Power Sheet also brings first-class support for Child Rows and Hierarchies, as well as Auto-Grouping, Auto Slicers, and Drill-down/through for everything from OLAP to sub-tasks and sub-sub-task lists in Excel. Together with Smart Fields, Threaded Comments, SSO and Notifications; this transforms Excel into a tool to easily manage your projects, tasks, timesheets and assignments.

 

Power Sheet makes it possible to easily embed snippets of JavaScript, C#-like TypeScript or (with upcoming support) Python for cross-platform Excel automation, macros, BI, analytics, data science, queries, web/DB connectors, data transformations, user-defined formula functions, interactive visuals, and calculated columns/measures/KPIs.

 

Power Sheet even allows you to even use JavaScript functions and APIs, as well as Regular Expression (RegEx), web APIs, and more, from standard Excel cell formulas as well as Power Sheet calculated columns (which blend Excel Formulas + JavaScript, for cross-platform use even for Web Published apps, dashboards and reports). 

 

Power Sheet also extends Excel with many new Power Functions, including support for inline SQL queries (with its embedded in-memory SQL engine) in Excel formulas, RegEx (for powerful and easy text matching/splitting/replacement) and Power Query-like data transformation dynamic array functions for Excel formulas. 

 

Power Sheet also provides easy automatic AI-guided data preparation, cleaning, fuzzy logic based deduplication, consolidation, splitting and transformation tools for the most common uses, without the complexity of Power Query and intelligently handling moved, renamed and reordered columns without breaking.