Export Data from BrioQuery into Excel
Option 1: Use BrioQuery Export functionality
- Retrieve query results.
- Follow the menu path File > Export > Section
Note: If no section of the results are selected, BrioQuery will by default export all results.
Result: A dialog box opens prompting you to choose file name and location. - Browse to the location on your Windows machine where you'd like to save the file, and enter a file name.
Result: Data will be saved in an Excel spreadsheet.
See also:
Open or save files in Citrix Workspace
Data and Reporting Services - Using BrioQuery via Citrix Receiver on Mac OS X
Option 2: Copy from a pivot table and paste into Excel
To copy data from a BrioQuery pivot table into an Excel spreadsheet, you can use keyboard shortcuts.
- Click into the pivot table in BrioQuery and press Ctr + A (select all).
- Press Ctr + C (copy).
- Click into the Excel spreadsheet and press Ctr + V (paste).