Reading your data — Trusty CSV User Guide

User Guide for Reading CSV Files

Columns and Colours

Every column in its own colour and lined up under the others, without a single character of the file changing.

Hiding Columns

Put the columns you don’t need out of sight to read a wide table without scrolling sideways; they stay in the file, and come back with a click.

Numbers, Dates and Other Values

Number columns line up on their decimal point, email addresses on their @, times on their colon and dates group by group, all on their own.

Missing Values and Stray Spaces

Values that mean “nothing here” are shown in grey, and spaces at the edges of a value, or spaces that aren’t ordinary ones, are marked.

Long Values and Line Breaks

Values longer than their column fold into “…” and values with line breaks fold into one line, so that every row stays one aligned line. One click shows them whole.

Reading a Row Down

Row Details shows the row of the cursor as a list, a name and its value on each line, to read a wide table without scrolling sideways, and to edit any of its values.

Moving Around a File

Scrolling sideways, going to a line, a row or a column by name, and jumping from value to value.

Themes and Zoom

A dark or a light window, or whichever your system uses; a bigger or smaller text; and the colour themes of Visual Studio Code.