Importing data — Import into a table you already have

Importing into an existing workspace doesn't have to mean new tables. When the destination already has tables, each sheet gets an Into: picker — create a new table, or add these rows to one that's already there. Choose an existing table and two more things appear: • Column mapping. Every column gets a picker: fill an existing field, or add it as a new field on that table. Columns are matched up by name automatically, so you normally only fix the odd one. • Match on. The column that identifies a row already in the table — a SKU, an email, an order number. Rows whose value is already there are updated; the rest are added. Leave Match on empty and every row is simply added — which is what you want for a log or a list of new records, and what you very much don't want when re-importing a corrected export. The wizard spells out which of the two will happen before you commit, and the summary at the end reports how many records were updated as well as how many were added. The match key is the whole difference between tidying a table up and doubling it.