Viewing and Customizing Data Files
You can view data files, raw data, and CSV and TSV files in tabular or comma-delimited view. You also can sort, filter, and show or hide columns in some CSV and TSV files, and edit text files you own. The information that is viewable or editable is dependent on the type of file chosen. Before you begin, you may want to watch a YouTube video on file creation, editing, and tabular views.
In the Data window, find the file to view.
If you get a message that there are no items to display, it is possible the folder or file has a special character in its name.
Click to open the file.
- Save is available only for editable files for which you are the owner.
- Refresh allows you to update the window.
- Wrap Text displays the text wrapped within the window.
- Not Editable is displayed for files that are displayed on more than one page.
Editable is displayed only when the entire contents of the file fit on only one page (adjusted using the Page Size (KB) slider). To save changes to the file, you must be an owner of it. - The page slider allows you to view more or less of the file.
- Page navigation allows you to easily navigate between pages of the file.
Viewing and customizing CSV and TSV files
In addition to the default (delimited) tab view for CSV and TSV files, files that have been defined with an info-type of CSV or TSV also display a Tabular View tab, within which you can add or remove rows, skip first lines, define the first row header, as well as sort, filter, and show or hide columns.
In the Data window, click to open the CSV or TSV file to view:
- Save is available only for editable files for which you are the owner.
- Refresh allows you to update the tab.
- (Add Row and Delete Row), available only when the file is Editable, allows you to add or remove rows from the table.
- Skip First N Lines(s) hides the specified number of lines.
- First Row Header displays the first row of the table as the table header.
- Not Editable is displayed for files that are displayed on more than one page.
Editable is displayed only when the entire contents of the file fit on only one page (adjusted using the Page Size (KB) slider). To save changes to the file, you must be an owner of it. - The page slider allows you to view more or less of the file.
- Page navigation allows you to easily navigate between pages of the file.
Sorting, filtering, and customizing columns in CSV and TSV files
In CSV and TSV files with the Tabular View tab (the file must be defined with an info-type of either CSV or TSV), you can sort and filter columns, and hide or show columns to customize the look of your list.
- In the open CSV or TSV file, hover over the file's column header until a down arrow is displayed:
Click the down arrow:
- Sort Ascending or Sort Descending: To sort on the column, click either Sort Ascending or Sort Descending.
- Columns: To hide or show a column, point to Columns and then select or clear the checkbox for the column to show or hide.
- To filter on data in the column:
- Point to Filters.
In the text box, enter the filter text (not case-sensitive). The list is filtered for the query you entered.