Column profile
A panel at the side with what a column holds: its type, empty and missing values, distinct values, figures and a histogram for numbers and dates, and every value with how many cells have it, to select or correct them all at once.

opens a panel at the right of the file with the profile of the cursor’s column: what it holds, and every value it has with how many cells have it. Move the cursor to another column and the panel follows it. It’s the quickest way to see what needs cleaning before you change anything: the misspelled country, the city with a space at the end, the n/a among the prices.
The panel stays open, also the next time you open the editor, until you close it with its × or with the same menu item. It shares its place with the Quality Check panel: opening one closes the other. Drag its left edge to make it wider or narrower.
The figures
Under the column’s name, in its colour, the panel says which column it is and what most of its values are: numbers (with their decimal point or comma), dates, times, email addresses or text. Then:
| Figure | What it counts |
|---|---|
| Rows | the rows below the header; empty lines aren’t rows |
| Empty | cells with nothing in them, or only spaces |
| Missing | missing values: NA, null, N/A, - and the like (see Missing values and stray spaces) |
| Distinct | how many different values there are, empty and missing ones left out |
| Unique | how many values appear only once |
| Minimum, Maximum, Sum, Average | in a column of numbers, of the values that are numbers, read with the column’s decimal separator |
| Length | the shortest and the longest value, in characters |
The number of empty cells, the number of missing values and, when a column of numbers, dates or times has values of another kind, how many there are, are links: a click selects those cells. With the cells selected, an operation of the Cells menu changes just them (see Finding the cells to fix).
The values
Below the figures are the column’s values, each with how many cells have it and a bar to compare them (in a column of numbers or dates, under Values: it opens with a histogram, of numbers or of dates). They are listed exactly as they are written, so Madrid and Madrid with a space after it are two values: the spaces at the edges show as dots, an empty cell as (empty), and missing values in grey. The most common come first; the button at the right of Values sorts them by value instead, in the order a person would use (Item 2 before Item 10), as numbers in a column of numbers and as dates in one of dates.
The list shows the first 200. To find any other, type part of it in Filter values.
- A click on a value selects every cell that has it, with a cursor in each. Type to replace them all, or run an operation on them. A bar at the bottom of the panel says how many values are chosen, and how many cells have them. Click the value again and it isn’t chosen any more.
- Ctrl+Click⌘Click adds another value to the selection, or takes it out.
- Merge…, in that bar once two or more values are chosen, makes them all one: see Merging values by hand.
- A double click, or F2 on a value, lets you edit it right there. Press Enter and every cell with that value changes to the new one, in one step of Ctrl+Z⌘Z; Esc leaves it as it was. It’s how you correct
Madirdin a hundred rows at once, or mergeUSAintoUnited States.
Values with line breaks inside them are edited in the file, not in the list.
The histogram of a column of numbers

In a column of numbers, the panel shows a histogram instead of the list of values: the numbers grouped in ranges of the same width, from the smallest, each with how many cells fall in it and a bar to compare them.
- The ranges start at multiples of their width and say which is their last number:
0 – 9,10 – 19,20 – 29. With decimals, the last number has them too:0.00 – 49.99. In a column with more than three decimals, such as coordinates, a range says where it starts and where the next one does:40.5 – 41holds 40.5, not 41. From 10,000 on, the thousands are grouped (5,000,000 – 9,999,999), with points in a column with a decimal comma. - Bin width chooses how wide the ranges are. Automatic splits most of the numbers into about ten ranges of a round width (1, 2, 5, 10, 20, 25, 50…), leaving out the few lowest and highest as it chooses. So a number far from the rest, such as an age typed as
4500, doesn’t squeeze all the others into one range: it gets a range of its own, after a line in italics for the empty ranges in between. It’s often the first sign of a value to fix. - A click on a range selects every cell in it, with a cursor in each, and Ctrl+Click⌘Click adds another range or takes it out. The bar at the bottom of the panel says how many ranges are chosen, and how many cells they have. A click on the only range chosen takes it out too.
- Values, at the top, shows the list of values instead, to edit or merge them; Histogram brings the ranges back. Your choice holds for every column of numbers and of dates until you change it.
Empty cells, missing values and values that aren’t numbers aren’t in the histogram: the figures above count them, and their links select them.
The histogram of a column of dates

In a column of dates, the histogram counts the dates by period instead: a line per day, week, month, quarter or number of years, from the earliest, each with how many cells have a date in it. It reads the dates however they are written (2026-05-03, 03/05/2026, 3 May 2026) and with the order the column uses, the day or the month first, as sorting does; the time of day doesn’t count.
- The lines say which days they hold, with the month’s name so that they can’t be read two ways:
3 May 2026,4 – 10 May 2026(a week, from Monday to Sunday),May 2026,Q2 2026,2026,2020 – 2029. - Period chooses how long they are: day, week, month, quarter, year, 5, 10, 50 or 100 years. Automatic chooses the one that splits most of the dates into about ten lines: a year of dates goes by month, three months by week, thirty years five at a time. As with numbers, a date far from the rest, such as a
1926among the dates of 2026, gets a line of its own after a line in italics for the empty periods in between. - A click on a period selects every cell in it, and Ctrl+Click⌘Click adds another or takes it out. The bar at the bottom of the panel says how many periods are chosen, and how many cells they have.
Empty cells, missing values, values that aren’t dates and dates that aren’t in the calendar (31/02/2026) aren’t in it: the figures above count them.
Merging values by hand
Some values are the same thing and no rule could know it: USA, United States and America; Bcn and Barcelona. Click one in the list, Ctrl+Click⌘Click the others, and press Merge… in the bar at the bottom of the panel. It proposes the value most cells have; keep it or type another, and press Enter: every cell with one of the chosen values takes it, in one step of Ctrl+Z⌘Z. Esc leaves them as they were.
Group similar…, above the list, looks for the values that are the same one written in different ways (Madrid, madrid, MADRID.) and merges them, so start there: see Grouping similar values. Merging by hand is for what it can’t find.
Large files
The panel reads the column in the background, a part at a time, so a large file doesn’t freeze the editor: until it has read it all, the top of the panel says how far it has got. After you change the file, it reads the column again once you stop typing, and meanwhile shows the last profile, dimmed.