Lightning Tools Data Viewer

Lightning Tools Data Viewer

Score 9.1 out of 10
Lightning Tools Data Viewer


What is Lightning Tools Data Viewer?

The Data Viewer provides data visualization in the form of reports or charts that can be created and customized to suit a business's needs. Silos of data exist in most organizations and yet contain valuable insights into how well the...
Read more

Recent Reviews

Read all reviews

Reviewer Pros & Cons

View all pros & cons
Return to navigation


View all pricing

Data Viewer OnPrem


On Premise
per year Per installation, 1 x WFE

Data Viewer Online


per year per installation

Data Viewer OnPrem Enterprise Edition


On Premise
per year Per installation, 4+ WFE

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visit…


  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Starting price (does not include set up fee)

  • $1,250 per year per installation
Return to navigation

Product Details

What is Lightning Tools Data Viewer?

The Data Viewer provides data visualization in the form of reports or charts that can be created and customized to suit a business's needs. Silos of data exist in most organizations and yet contain valuable insights into how well the organization is performing and where action is needed. Those silos often include Microsoft Excel workbooks, Microsoft SQL Azure databases, On-Premises data sources accessible through OData or Business Connectivity Services and even SharePoint Lists. These data sources can be connected to, to produce reports displayed in SharePoint or Teams.

Lightning Tools Data Viewer Features

Data Discovery and Visualization Features

  • Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)

BI Standard Reporting Features

  • Supported: Customizable dashboards
  • Supported: Report Formatting Templates

Ad-hoc Reporting Features

  • Supported: Drill-down analysis
  • Supported: Formatting capabilities
  • Supported: Report sharing and collaboration

Report Output and Scheduling Features

  • Supported: Publish to Web
  • Supported: Output Raw Supporting Data
  • Supported: Report Versioning

Lightning Tools Data Viewer Screenshots

The Data Viewer Client Side Web Part can be configured by Business Users within a few minutes to display Line of Business Data from Data Sources such as Excel,  SQL Azure, Business Connectivity Services, OData and SharePoint Lists.  Connections to an organizations data such as Customer Relationship Management Systems, Accounting Systems, or Custom Databases can be connected, giving business users a live up-to-date view of business information within the context of their SharePoint Team Sites or Microsoft Teams Tabs.Screenshot of HIGHLIGHTING KEY BUSINESS DATA (NO CODE)
Conditional formatting can be used to highlight key business data. Overdue Tasks, Low Stock, Currency Exchange Rates, Sales Revenue are examples of data to highlight visually allowing for a quick reaction time. Key Financial Indicators and Key Performance Indicators can be configured with a simple dialog and no need to write any code. Choose colours, icons or data bars to highlight key data.Screenshot of SELECTING AND STYLING ICONS
Choose Icons as part of the conditional formatting to make data stand out. The Office 365 Fabric icons can be selected and styled and applied to cell values. Pepper pots, Smileys, Envelopes and more icons are available. There are hundreds of options to choose from to highlight data that needs to be acted upon.Screenshot of DATA VIEWER CAN BE A GRID OF DATA OR A CHART IN SHAREPOINT OR MICROSOFT TEAMS
The Data Viewer can be used within Microsoft SharePoint Modern Sites or Microsoft Teams Tabs as a Grid of Data with styling or as a Chart which can be configured. The Charting Feature allows for Pie, Donut, Column, Line, Area, and Scatter Charts which can all be configured and displayed in 2D or 3D.Screenshot of TREEMAPS
summary information can be displayed within a TreeMap next to the detail. Users will be able to see trends, and how the business is performing  using the TreeMap view of data.Screenshot of CHARTS AND GAUGES
The Data Viewer is used to represent data in multiple ways using Gauges, TreeMaps, Multiple Series Charts, and Pie Charts.Screenshot of BUILDING DASHBOARDS
The Data Viewer can be a grid view or a chart enabling users to build a dashboard within the context of a SharePoint Team Site or Microsoft Teams Tab.

Lightning Tools Data Viewer Videos

Data Viewer
Data Viewer Webinar December 2021

Lightning Tools Data Viewer Integrations

Lightning Tools Data Viewer Competitors

Lightning Tools Data Viewer Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Microsoft SharePoint And Teams
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish, French, German, Spanish, Dutch, Japanese

Lightning Tools Data Viewer Customer Size Distribution

Small Businesses (1-50 employees)10%
Mid-Size Companies (51-500 employees)52%
Enterprises (more than 500 employees)38%
Return to navigation


View all alternatives
Return to navigation

Reviews and Ratings



(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Tom Phillips | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
We have over 16 SharePoint Online sites. Lightning Tools DataViewer allows me to resurface a list from one site to others where users need to see that information on their main page. Lightning Tools DataViewer is absolutely essential for doing that. SharePoint's built-in viewer is very limited.
  • Shows Lists created on different sites to be seen and controlled on another site in a Tenant
  • Allows selection of layouts and coloring way beyond what other programs do.
  • Easy to learn and very functional.
  • Data Viewer has a graph feature that is old school flat design. We loved the In House real 3D graph Lightning Tools program.
Lightning Tools Data Viewer is well suited for re-surfacing data and customizing its look and feel.
Data Discovery and Visualization (1)
Pre-built visualization formats (heatmaps, scatter plots etc.)
BI Standard Reporting (2)
Customizable dashboards
Report Formatting Templates
Ad-hoc Reporting (3)
Drill-down analysis
Formatting capabilities
Report sharing and collaboration
Report Output and Scheduling (2)
Publish to Web
Report Versioning
  • It allows us to do things that would take a great deal more time to duplicate in SharePoint
  • It cuts down on ugly looking built in SP list layouts
  • Users find it easy to access, thus this product is more productive
Lightning Tools Data Viewer is much easier and more powerful than Infowise similar viewer in their lineup. In this case, we use Data Viewer over the one offered by Infowise.
Return to navigation