5 Exporting Filtered Data

While rudimentary data navigation and filtering are possible within a web browser, users may want to export the data found within the Main Data Table (Chapter 3) for visualization in other software or analysis in other data platforms. The two buttons below the Main Data Table allow users to select which columns to export and then to save their data to a local file (column separated value, .csv file). We recommend ALWAYS performing some sort of basic filtering before exporting your dataset. Users who would like the full, unfiltered Main Data Table can find this at our Zenodo repository.

Buttons for exporting the currently displayed Main Data Table

Figure 5.1: Buttons for exporting the currently displayed Main Data Table

5.1 Select Columns to Export Button

The “Select Columns to Export” botton brings up a dialog box (Figure 5.1A) where users can manually select which columns of the data table are to be exported. If no columns are selected, ALL data is exported by default. We strongly recommend exporting ALL data columns and selecting/filtering further in other data analysis programs, but this function is provided as a convenience.

Any or all Main Data Columns can be selected for export

Figure 5.2: Any or all Main Data Columns can be selected for export

5.2 Download Filtered Data Button

The “Download filtered data” button (Figure 5.1B) will trigger a “Save As” dialog box, prompting the user to name and save their comma separated value (.csv) file containing their exported data. The data exported will depend on whether the user has selected any columns using the “Select Columns to Export” button (5.1A) and based on the number of entries in the Data Table (5.1C). The number of entries that will be exported will depend on Basic Filtering (covered in Chapter 4 and if the Search Box is used (also covered in Chapter4. As an example, if users selected the “Download filtered data” button based on Figure 5.1A, 15,848 rows/entries would be exported.