How to Use Capture Data?

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 use Capture Data as SpotlightXL Formulas to convert view data into formulas like SpotlightMetadata and SpotlightData. It also covers copying the data to a new sheet, converting it into an Excel Report, and using Refresh to display live data and labels.

In SpotlightXL, navigate to Analyze > Data.
Select a view from the folder structure; the tab displayed will be named Analyze.
Under the More menu on the ribbon, click the down arrow and select Capture Data as SpotlightXL Formulas.
All data items will show as #REFRESH, and cell contents will consist of SpotlightMetadata or SpotlightData formulas.

Note:
Clicking Get Data in the Analyze tab will trigger a warning. If you proceed, it will replace Spotlight formulas with data values from the model.
Copy the entire contents of the Analyze worksheet to a new blank worksheet.
Select Excel Report from the Select Task menu. The menu changes to reflect the options for Excel reports.
Click Refresh.
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

Understanding Which Cells are Associated with Which Model