Hiding columns — Trusty CSV User Guide

Hiding Columns in CSV Files

A table with many columns doesn’t fit in the window, and the two columns you want to compare are seldom side by side. Hide the ones in between: they take no room, the columns after them move left, and the file doesn’t change. A hidden column is still there, and it is saved with the rest.

To leave rows out instead, filter them.

Hiding a column

One column always stays in sight: the last one can’t be hidden.

Each column keeps its number and its colour, so the numbers of the column bar skip the hidden ones: 1, 2, 5 says that columns 3 and 4 are there, out of sight.

Showing them again

Going to a hidden column shows it again: Go › Go to Column…, the next change of a comparison, a problem of the Quality Check.

Which columns are hidden is remembered with the tab, so they are still hidden after you reload the page or restart the app. They are shown again if you change the delimiter or the header row, and after an operation that leaves the table with other columns (one inserted, deleted, moved, split…), or its undo: the numbers would no longer be of the same columns.

Working with columns hidden

Hiding is a way of looking at the table, not a way of choosing what to work on (a filter is that, for rows).

A row that has values only in hidden columns (a row cut short, or the first value of a row you are typing) is shown whole: there would be nothing of it to see.

Exporting the columns that show

Ctrl + S ⌘ S always saves every column. With columns hidden, File › Save As… and the formats of File › Download as (File › Export as in the desktop app) have one more option, Columns: every column, or only the columns not hidden. It works for every format, and together with Rows, the option for the rows a filter shows.

A file with only those columns is an export: the tab stays with its own file and all its columns, and the name it proposes ends in “(visible columns)”, so that it doesn’t go over the original. The values are written again from what they hold, so a value between quotes that doesn’t need them is written without them.