Description
Visualise and analyse data from SharePoint lists, SQL, Excel, OData and more — directly inside SharePoint or Microsoft Teams — without writing any code.
Overview
Data Viewer is a modern, client-side web part that lets you connect to a wide range of data sources and display that data as tables, interactive reports or charts on SharePoint pages or Microsoft Teams tabs. It supports data from SharePoint lists, Excel workbooks, SQL Azure, OData services, external connectors (Graph, BCS, OData, etc.), allowing you to build dynamic dashboards, charts and grids with a few clicks.
Key Features & Benefits
- No-code configuration: Easy to set up and configure via a graphical interface — no development or scripting required. :contentReference[oaicite:2]{index=2}
- Flexible data source support: Connect data from SharePoint lists, Excel files, SQL Azure databases, OData feeds, external connectors or Business Connectivity Services (where supported). :contentReference[oaicite:3]{index=3}
- Multiple display modes: Display data in a grid/table view or as charts — including bar, column, line, pie, TreeMap, gauge / KPI views, geo-maps, and more. :contentReference[oaicite:4]{index=4}
- Customisable styling and formatting: Choose which columns to show, apply conditional formatting, use calculated columns, control grouping, sorting and layout — all without code. :contentReference[oaicite:5]{index=5}
- Interactive and refreshable data: Configure data refresh intervals for dynamic data sets, or allow users to filter, sort, and drill down directly in the interface. :contentReference[oaicite:6]{index=6}
- Seamless integration: Works smoothly on modern SharePoint pages, Microsoft Teams tabs, and (where supported) SharePoint on-premises using the client-side web part. :contentReference[oaicite:7]{index=7}
- Great alternative to heavier tools: Provides powerful data visualisation inside your existing SharePoint/Teams environment, without needing a full business-intelligence platform. :contentReference[oaicite:8]{index=8}
Use Cases
- Create dashboards showing combined data from SharePoint lists, Excel or external databases — ideal for reporting and analysis.
- Embed live charts and reports on SharePoint intranet or Teams channels so stakeholders see up-to-date information at a glance.
- Replace complex BI tools for smaller data visualisation needs — ideal for teams needing agility and lightweight reporting.
- Use calculated fields, conditional formatting and interactive chart views to highlight trends, KPIs or data anomalies without bespoke development.
- Aggregate data from multiple sources into unified views: great for organisations with data spread across systems who need a consolidated view.
Licensing & Trial
Data Viewer is offered with a free trial by Lightning Tools. After the trial, a licence key must be applied to continue using the web part. This allows you to test full functionality in your own environment before committing.
Why We Recommend It at AxioWorks
Though Lightning Tools Data Viewer is not an AxioWorks-developed product, we include it because it complements our own data-synchronisation tools perfectly. Once your data is synchronised into SQL or SharePoint via our tools, Data Viewer enables powerful visualisation and reporting — all within SharePoint or Teams. This combination offers a full, integrated data management and insight solution for modern organisations.
Support & Documentation
Full documentation, configuration guides and support are maintained by Lightning Tools, available to all licence holders. If you purchase via AxioWorks and need assistance, we’re also ready to help coordinate setup and integration with your existing environment.
Note: This product is provided by our trusted partner, LightningTools. AxioWorks acts as a reseller.



