What is normalization ?
Normalization is a standard representation of datas in database systems. It involves adding a unique identifier to each row.
Why normalization ?
Normalization ensures that updates or relationships apply to the correct row, even if the row has been moved.
How it works ?
A column contains the unique identifier. It is named as the “Primary Key”. If the corresponding cell is empty, the row will be ignored.
If this column does not yet exist, it is created and initialized during import (it may also already exist in the sheet and must then be referenced as the primary key during import).
Once the sheet is imported into the X-Sheets application, to insert a new data row directly in the sheet, you can force the generation of a unique identifier by entering the “?” character in the identifier cell, otherwise the row will be ignored.