Putting files together
Add the rows of other files after the ones of this one, matching their columns by name, or bring columns from another file beside its rows, matched by an id.
Two commands of the Table menu put the tables of several files into one. Both work with the tabs you have open: open the files first, each in its tab (several at once from the file window, or by dropping them on the editor).
| Command | What it does |
|---|---|
| Append Rows from Other Tabs… | adds the rows of other tabs after the last row of this one: January, February and March in one file |
| Join with Another Tab… | adds columns of another tab beside the rows of this one, matched by a column they share: the orders, with the city of each customer |
Only the tab you are in changes, in one step of Ctrl+Z⌘Z. The other tabs are read as they are now, saved or not, and never touched; neither is any file until you save. Each window shows the first rows of the result before you press its button.
Values come as they are written in their file. If one file writes 1,5 and the other 1.5, or dates in another order, make them alike afterwards with Reformat Numbers and Reformat Dates.
Appending rows
lists the other open tabs, with their number of rows. The ones that look like this one (half their columns or more are called like columns of this tab) come ticked; tick the ones you want.
Match columns says which column of the other file goes under which column of this one:
- By name:
totalgoes undertotal, wherever it is in each file. Capitals and the spaces around a name don’t count. - By position: the first column under the first, the second under the second, whatever they are called. It is also what happens when one of the two files has no header row.
A column that this tab doesn’t have is added after its last one, and the rows that have nothing for a column get an empty cell. The window says which columns are new, and which columns each file lacks. Look at both: when the same thing is called city here and town there, the result has two columns, each half empty. Rename the column in one of the files before appending, or put the two together afterwards with Merge Columns.
Add a column that says which file each row comes from adds a last column, file, with the name of the tab of each row, this tab’s included. It is what tells January’s rows from February’s once they are together.
The header rows of the other files aren’t added: only their rows. Afterwards the cursor is in the first row added.
Joining two files
is for two files about the same things: a list of orders with a customer id in each, and a list of customers with their id, name and city. It writes, beside each order, the columns of its customer. (It is what a spreadsheet does with VLOOKUP or XLOOKUP, and a database with a join.)
- Other file: the tab the columns come from.
- Match … with its: the column of this file and the column of the other one that hold the same values, the id. The window proposes the column of the cursor, if the other file has one with its name, or the first name they share.
- Keep: which rows the result has.
- Every row of this file: the rows that have no match get empty cells.
- Only the rows with a match: the others are removed.
- Every row of both files: after the rows of this file, the rows of the other one that nothing matched, with their id.
- Only the rows without a match: nothing is added; the rows that have a match are removed. It is the way to see which ones are missing in the other file.
- Capitals and the spaces around don’t count, ticked to begin with:
ana,AnaandAnaare the same id. Untick it for ids where capitals matter. - Bring: the columns of the other file to add, all but its id to begin with. A column whose name this file already has gets a number:
city,city_2.
The new columns go after the last one. A row with an empty id matches nothing.
The ids that don’t match

Under the first rows of the result, the window says how many rows have a match and shows a few of the values that don’t, from each file. It is the part worth a look before joining, because the reasons are nearly always the same: a space at the end, another spelling (Köln, Cologne), a code that lost its zeros (8001, 08001), an abbreviation. Close the window, fix them, and come back:
- Quality Check finds spaces, codes without their zeros and the same value with other capitals.
- Group Similar Values finds the values that are nearly the same.
- Only the rows without a match leaves just the rows to fix, to see them all; Ctrl+Z⌘Z brings the others back.
When an id is there twice
If the other file has the id in several rows (a customer with two addresses), the row of this file is repeated, once for each: that is what a join does, and the window says how many rows more there will be. If you expected one match per row, the other file has duplicates: Remove Duplicate Rows there first, by its id column.