Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Image RemovedQ: How can I export table data to CSV or Excel File Format.
A: Most data tables include a CSV button and an Excel button. The CSV button exports the data table to the CSV file format while the Excel exports the data table to an Excel file making it the better choice if you intend to edit or manipulate the data in Excel. The exported data will include “All” entries regardless of number selected in the Show entries drop-down list for the table.
For example:
1. Click the CSV button or the Excel button.
Image Added2. You The CSV and Excel download data table buttons display on many STRATUS pages. Notice that Loaded entries inform you how many rows have loaded out of how many entries will be loaded.
Image Added2a. If you click either the CSV or Excel download data table button before all entries have been loaded, the following message will display.
Image Added2b. Generate - If the user clicks the Generate button, a partial file will download indicated with (Partial) in the file name.
2c. Cancel - Click Cancel to wait for all data table records to load.
3. The file will either download to your Downloads folder or you will be prompted for the output format.
33a. Open with - To Open with, select Open with radio button with Excel selected regardless of which button was clicked. If the CSV button was clicked in STRATUS, the file will open in the CSV file format. If the Excel button was clicked in STRATUS, the file will open in the Excel file format.
43b. Save File -To save the file, click the Save File radio button. If the CSV button was clicked in STRATUS, the file will save in the CSV file format. If the Excel button was clicked in STRATUS, the file will save in the Excel file format.