Import guide
Prepare your spreadsheet in ten minutes.
Dueclear reads most registers as they are. A few minutes of tidying makes the first import perfect. Here is what to check.
Columns
What Dueclear looks for.
| Column | Needed? | Examples of header names |
|---|---|---|
| Item | Yes | Item, Certificate, Description, Descrizione, Bezeichnung, Designação |
| Expiry date | Yes | Expiry, Due, Valid until, Scadenza, Ablaufdatum, Vencimiento, Validade |
| Site or building | Recommended | Site, Building, Property, Immobile, Objekt, Edificio, Local |
| Owner | Recommended | Owner, Responsible, Who, Responsabile, Zuständig, Responsável |
| Interval | Optional | Interval, Frequency, How often, Periodicità, Turnus, Frecuencia |
| Notes | Optional | Notes, Comments, Note, Bemerkung, Observaciones |
| Anything else | Kept | Contractor, contract number, block or floor become custom fields |
Before you import
A five-point checklist.
One row per renewal
Each recurring certificate at each building gets its own row.
One date per row
Put the next expiry in one column. Past dates can stay in another column.
Consistent dates
Use one date format throughout the column, whichever format you prefer.
Register on the first sheet
Only the first worksheet is imported.
Names spelled the same way
Write each building and person the same way every time so they group correctly.
Common problems
What you'll see, and what to do.
| You see | Why | What to do |
|---|---|---|
| "Skipped 2 rows above the header" | Your file starts with a title or export date. | Nothing. Dueclear found the real headers. |
| "No expiry date column" | No column was recognised as the expiry date. | Choose Expiry date next to the right column. |
| "Can't read date" | The value is not a real date, such as 31/02/2027. | Type the correct date in the box on that row. |
| "No date" | The expiry cell is empty. | Add the date, or leave the row out. |
| "Different format, check" | This date uses a different separator from the rest. | Check the date reads correctly. |
| A column marked "new field" | The column is not one of the core fields. | Keep it as a custom field, or choose Don't import. |