These pages describe Calamo Pro 0.1 for Windows, Linux and macOS (beta). Download it and try it free for 14 days.
A file opened to browse can be changed: cells, rows and columns. The changes happen in Calamo's copy of the table, so even a file of millions of rows changes at once, and nothing reaches the file until you save. Every change can be undone (Ctrl+Z) and redone (Ctrl+Shift+Z). The title shows • while there are changes not saved, and Calamo asks before a file with changes is closed.
Cells
Click a cell, or move with the arrow keys; Shift with a click or an arrow selects a block, and a click on a row number selects whole rows. Start typing, press Enter or F2, or double-click to change a cell; Enter keeps it and goes down, Tab goes right, Esc leaves it as it was. Delete clears the cells selected.
Drag a block of selected cells by pressing inside it and moving: the values go where you drop them and the cells they left are cleared, or with Ctrl held when dropping, they are copied. Selected whole rows (by their row numbers) move the same way. Either is one change for undo.
Ctrl+C copies the selection as Excel copies it, and Ctrl+V pastes a block from Excel or another table at the cell cursor. One value pasted into a bigger selection fills it.
Rows and columns
Right-click the table, or use Edit ▾, to insert rows above or below, duplicate, delete, move (Alt+↑ ↓) or hide rows, and to insert, rename, delete or move columns. Drag a column header onto another to move it there. Rows go by the file's order, so moving or inserting rows needs the sort cleared; Put the sort in the file keeps a sort for good.
Tools
- Find and replace (Ctrl+H) shows how many cells change and the first ones before you replace: any part of a value or the whole cell, matching case or not, or a regular expression with groups (
\1). With a search or filter, only the rows shown change. - Text case: UPPER, lower, Title or Sentence case for the columns selected.
- Convert dates writes a column of dates another way, such as 4.11.2026 as 2026-11-04. Values that are not such a date stay as they are.
- Split column splits values at a delimiter into new columns next to it.
- Look up columns from another file brings columns of another file by a key, like VLOOKUP: spaces at the ends do not count, and when a key repeats there, its first row is used.
- Transpose turns rows into columns, for tables up to 10,000 rows.
- Pivot table summarises one column by the values of one or two others: rows, sum, mean, smallest, largest. Copy table copies it for Excel.
Saving
Save (Ctrl+S) writes a CSV in its own shape: the delimiter, encoding, byte order mark and line endings it had, the header as written for columns not renamed, and the lines above the header (a report title). Calamo writes a new file next to it and then puts it in place, so a failed save leaves the file as it was, and it will not save over a file that changed on disk since it was opened. Empty lines are left out, and Calamo says how many.
An Excel, Parquet, JSON or XML file is saved with Save as (Ctrl+Alt+S), so its formatting or types are not lost: as CSV, Excel, Parquet, JSON or XML, chosen by the name's extension. Print rows shown (Ctrl+P) prints the first 5,000 rows, or saves them as a PDF from the print dialog. The File menu can also duplicate, rename or delete the file.
Settings
File → Settings (Ctrl+,) sets, for .csv, .tsv and .txt files, the delimiter and encoding to open them with (or detect, as the web tool does), the line endings to save them with, and whether to quote every value. Strict (RFC 4180) reads a file only when it follows the standard: a field with a quote is wholly in quotes, every quote is closed, and every row has as many fields as the header; otherwise Calamo says on which lines it does not, instead of reading it the forgiving way. It can also read a file again by itself when it changes on disk, and change the keyboard shortcuts of every menu command.