Chat with us, powered by LiveChat

Get a quick quote with our pricing calculator

Knowledge Base

Browse our knowledge base articles to quickly solve your issue.

Knowledgebase articles

Exporting Data

Workbooks enables you to export data from Workbooks grids in a format that’s compatible with Microsoft® Excel™ or in CSV format

Workbooks enables you to export data from Workbooks grids in a format that’s compatible with Microsoft® Excel™ or in CSV format.

In order to perform an export, you must have been granted the appropriate Export Capability, which is different for every record within Workbooks. 

NOTE: If you use the Export button in the left-hand view column, then entire record base will be exported, despite any filters applied to the Landing Page. Using the button at the top to export will only export data included in the filters.

To export a grid, simply click on the Export button and choose either CSV or Excel. The export will include all the columns and rows you’ve activated in the view.

If you choose to export to Excel, Workbooks will generate an XML Spreadsheet. Microsoft introduced this format in Excel 2002 and all modern versions of Excel can read it, but you may see a compatibility message that you need to accept when you open the file.

NOTE: If your export includes columns that are displayed as currencies, the export will include 2 extra columns for each currency column; one contains the amount as a value, i.e without a currency symbol and without any thousand separators; the other contains the currency code, rather than a symbol.  These columns will be appended to the right of the columns you’ve chosen to export, as shown in the screenshot below.

Previous Article Edit Grids Next Article Exporting to MS Excel