reading your data

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.

When every value in a column is of one kind, Trusty CSV lines the column up the way that kind of value reads best. There is nothing to set: it looks at the values, and does it as soon as a column qualifies.

orders.csv
order,date,time,customer,amount,status
1041,3/1/2026,9:05,ada@example.org,12.50,paid
1042,3/2/2026,14:30,grace@example.com,1240.00,NA
1043,3/9/2026,8:15,alan@example.org,7.25,paid
1044,3/12/2026,16:45,hedy@example.at,310.80,-
1045,3/15/2026,11:00,katherine@example.com,95.00,paid
5 rows × 6 columns
Dates group by group, times on the colon, emails on the @, amounts on the decimal point; NA and - in grey.

Numbers

In a column of numbers, the decimal points are one under another: whole parts end at the same place, and decimals start there. A number with no decimals ends where the decimal point would be; an empty cell is where its digits would end, so that typing in it grows the number to the left, as in a calculator.

Both ways of writing numbers are read:

  • 1,234.56: decimal point, commas between thousands (English).
  • 1.234,56: decimal comma, points between thousands (most of Europe and Latin America).

When a column’s values could be either (12, 1,500), it goes with the other number columns of the file and, if there are none, with the delimiter: semicolon-separated files are nearly always written with a decimal comma.

Numbers written with the digits of Arabic (٣٫٥) or of Persian and Urdu (۳٫۵) are numbers too: they line up, sort and add up as the others do, with their own separators (٫ for decimals, ٬ for thousands) or with a point and a comma. So are dates and times written with those digits (١/٥/٢٠٢٦, ٩:٠٥).

Numbers can carry what usually goes with them: a sign, a currency before or after ($12, 12 €, USD 1,200.00, 1.200,00 EUR), a percentage, an exponent (1.5e-3) and a unit from a list of common ones: 12 kg, 3.5GB, $1.2M, 120 km/h, 20 °C, 1st. The list is closed on purpose: 3 apples is text.

So that what matters most in each number stands out, only its sign and its whole part are drawn in full colour: the currency, the decimal separator and the decimals, the percentage and the unit are fainter (in $-1,250.75 kg, the -1,250). View › Appearance › Dim Decimals and Units turns this off.

Email addresses

A column of email addresses lines up on the @: the names end at the same place, and the domains start there. An address that is still being typed, or is a bit wrong, still counts (ana@, ana@example, maria.@example.org), so that the column doesn’t jump while you edit it.

Times and durations

Times line up on their last colon: 9:05, 14:30:00, 4:05.32, 9:05 pm. So do durations longer than a day (125:00) and ratios like 16:9. The last one, so that durations of different lengths keep their seconds one under the other: in 45:00 (minutes and seconds) and 1:05:30, the 00 is under the 30, and the hours stand out to the left.

Dates

Dates are aligned group by group: in 1/5/2026 and 12/11/2026 the days, the months and the years each take the same room, so that 1/5/2026 lines up with 12/11/2026, and a time after the date (1/7/2026 9:05 AM) lines up too. Day, month and year can come in any of the usual orders (31/12/2026, 12/31/2026, 2026-12-31), with /, . or - between them. Dates written in full with leading zeros (2026-03-01) are already aligned and stay as they are.

Trusty CSV doesn’t decide whether 1/5/2026 is the first of May or the fifth of January: it lines up what is written.

Dates with the month’s name in English (3 May 2026, May 3, 2026, 3-May-26) stay at the left, as text does, since their groups aren’t of numbers. They are still dates for everything else: sorting, the conditions on dates of the filter, the Column Profile, the Quality Check and the minimum and maximum of Summarize, so a column that Reformat Dates has written with the month’s name is still a column of dates.

When a column isn’t lined up

A single value of another kind sends the column back to the left: a column of amounts with one pending in it is a column of text. Missing values don’t count: NA, null, - and the like are allowed in any column (see Missing values and stray spaces). The header row doesn’t count either, and its names always start at the left edge of their column.

The cell you are typing in doesn’t count until you leave it. If you start an email address with ana, the column stays lined up on the @ and ana sits where its name will be; if you move away and the value is still not an email address, the column goes back to the left.