How to Create an Excel Report Based On a View in SpotlightXL?

1 Minute to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Article Summary

This article explains how to convert a SpotlightXL view into an Excel Report using the Design With > Excel Report option. It covers initializing the report with SpotlightMetadata andFinancial Reporting SpotlightData formulas, refreshing to display labels, and basic formatting steps.

In SpotlightXL, navigate to Analyze > Data.
Select a view from the folder structure. Notice that the tab displayed is called Analyze.
Under the Data subtask, select Design With > Excel Report to convert the view into an Excel Report. This action creates a new worksheet named after the view. The menu will update to show Excel Report options, with all data items displaying #REFRESH and cell contents containing SpotlightMetadata or SpotlightData formulas.
Format and lay out your Excel Report.

Note:

If your view uses Display Label, the resulting Excel Report does not display the label initially after conversion. After you click Refresh, the labels appear.

Was this article helpful?

What's Next

How to Use Capture Data?