Using Excel to analyze wrap data

You can export ExcelWraps data to Excel using MyWraps. Importing wraps into Excel makes it easy to analyze large amounts of data.

Some users find it a powerful option to manipulate wrap data as a spreadsheet in Excel. There are several ways to transfer data between ExcelWraps and Excel.

Exporting Wraps to an XML file

Wrapsite administrators can export data in the Wrapsite to an XML file using the Request Export actions in the Actions menu. The export file is in XML format (Extensible Markup Language) and can be read by Excel. The exported file is compressed in the ZIP format.

You can open the exported file directly in Excel. Select to open it As an XML table. If Excel asks you if it’s OK to create an XML schema, click OK.

Using the deprecated export actions

During the transition to new export file formats, we still support previous methods to export wrap data from Administration dashboard > ExcelWraps > Wrap instances, e.g. “Export wrap definition with all/selected instances” and “Export selected instances”. For these deprecated file formats, we offer additional tools.

To ease you into learning how Excel manages XML data files we have prepared some workbooks that can read any XML exported from your ExcelWraps subdomain. Our WrapReader.xlsm workbook splits the data in the XML file into Excel filtered lists and pivot tables presented on separate tabs.

  • The workbook reads the whole data set but native Excel Filter controls allow you to filter down to single items or multiple data items.
  • It is easy to determine aggregate values over the selected data items using functions like AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR and VARP.
  • Our Worksheet contains macros that will find the source URL of any data item, we even highlight the data item so it is easily identified.

Signature data has a slightly different data structure but is similarly interrogated using our WrapReaderSig.xlsm workbook.

Note: both the above .xlsm files contain Excel macros written in Visual Basic. Excel considers downloaded files with macros to be potentially harmful. If you cannot open or use the macro-enabled files as expected you may need to change your Options > Trust Center settings for Excel so that Excel allows the embedded macros to run.

These tools can be used offline to generate both simple and complex reports and they can be completely customized using Excel’s native commands.

Export reports to Excel as CSV or HTML files

The Download button in the toolbar allows you to export any MyWraps report as a CSV file that contains the bare numbers with no formatting, or as an HTML file that contains all the numbers and hyperlinks to take you back to the source information on your Wrapsite. Excel can open both filetypes as spreadsheets via File > Open.

Dynamic link to MyWraps

Excel has an embedded browser that can open a MyWraps link and pull the data through to Excel for additional calculations and charting. The connection is dynamic and a Refresh button immediately updates your Excel workbook with live information from the Wrapsite.

The Export to Excel widget

When you view a Wrap, you can save content from it as a spreadsheet in xlsx format using the Export to Excel widget.