Import changes from Excel or CSV
Export a list, change values in Excel, and bring the file back: Keel shows what would change, nothing is written until you press Start, and then a job on the server saves the changes as you. It updates items only: no file creates, deletes, publishes or moves anything.
The round trip
In a list where you may save items, the list's button says Export / Import, and its panel has two halves: Export at the top, Import below it. Everyone else sees the plain Export button.
- In a list open Export / Import (the button next to Columns). In the Export half tick For re-import under Edit in Excel, and download. Excel or CSV both work.
- Change values in the file. Keep the ID column. You may delete columns, reorder them and sort the rows.
- Open Export / Import again and press Import changes… in the Import half. Pick the file.
- Read the preview: how many items change, each changed cell with its old and new value, and every row that was refused with the reason. Nothing has been saved at this point.
- Press Start. The job runs on the server: you can leave the page, it shows on the usual progress card with Cancel, and its report lists every item.
The file gets one more column at the far right, hidden in Excel and visible in CSV. Leave it as it is: it holds what Keel needs to recognise the file and its rows. A file exported without the tick can't be imported.
What is written
- Only the cells you changed. A cell that says what the item holds is not touched, whatever Excel did to its format.
- Empty cells leave the value alone, and the preview counts them. To clear values, tick Empty cells clear values.
- A row is all or nothing. One bad cell refuses the whole row, so an item is never half changed. The other rows go on.
- An item changed after your export is refused, by name, even if the change was in a field that is not in your file. Export it again and redo the change. The same check runs again when the job reaches the item. A file can't be applied twice, as the items it changed count as changed.
- Texts with languages go into the language of the file (the column title says which, the preview too), not the language you are looking at when you import.
Variants: a cell that shows the parent's value stays inherited, so a variant gets no copy of it. If you set a different value, the variant has its own value. With Empty cells clear values, an empty cell makes the field take the parent's value again.
Without the publish right, a published item stays as it is and your change becomes a new version, as in the editor. History shows one entry per import, which can be reverted while it holds at most 5,000 items.
What can be changed
| Field | In the file |
|---|---|
| Text, long text | As typed. Longer than the field allows is refused, not cut |
| Number | See below. Fractions in a whole-number field and more decimals than the field keeps are refused, not rounded |
| Date, date and time | See below |
| Yes / No | Yes, No, Da, Ne, Ja, Nein, true, false, 1, 0, or Excel's TRUE and FALSE |
| Choice, country | The option's label or its value. Unknown options are refused |
| Several choices | The same, separated by commas or semicolons |
These can't be changed from a file, and a change there refuses the row: linked items, images, Changed, Publication, a field you may only read, and a workflow's status (it changes through workflow steps). The score, Assigned to and the picture are not read at all, since they change on their own. Rich text, bricks, classification stores and field collections are not in a list, so not in the file.
Numbers and dates, in Croatian Excel too
Cells Excel holds as numbers and dates are exact, whatever your Excel shows. Text is read like this:
| You see | Read as |
|---|---|
1234,5 1234.5 | 1234.5 |
1.234,50 1,234.50 1 234,50 | 1234.5: the last mark is the decimal one |
1.234.567 | 1234567 |
1.234 1,234 | Refused: this could be either. Write 1234 or 1,234 with a fourth digit, or keep the Excel number |
12 € 50% 1E5 | Refused |
2026-11-07 7.11.2026 7.11.2026. 7. 11. 2026. | 7 November 2026, day first, four-digit year, with an optional 10:30 |
11/7/2026 7.11.26 31.2.2026 | Refused |
Excel files are safest. For CSV use CSV UTF-8 when saving: the older CSV format is refused, as it would turn č, š and ž
into something else. Semicolons from Excel with Croatian settings are fine. Excel can change values when it opens a CSV (it
drops the leading zero in 007). That shows in the preview as a change.
A cell with a formula is refused: paste it as a value. Keel never runs a formula or macro or uses a formula's stored result. Only the first sheet is read.
Who may change what
The file gives no extra rights. Every cell is checked for you, in the preview and again when the job reaches the item: your right to save the item, field access, the languages you may edit. A value you may not see is empty in your file and never appears in a preview. A row for an item you can't reach says the same whether the item exists or not. A file exported by a colleague can be imported, with your rights: columns you can't use are ignored, and the preview names them.
Limits
At most 10,000 rows and 20 MB per file (import.max_rows, import.max_file_mb in keel.yaml).
The preview of 5,000 changed rows takes about a minute, of an unchanged file about ten seconds.