Getting set up
How to move from Excel
Six steps, one week of overlap and one important detail: changing system does not free you from keeping the earlier records.
In short
When you change system, the obligation to keep the earlier records does not move to the new system: article 34.9 of the Estatuto de los Trabajadores requires records to be kept for four years. The Excel, the paper or the export from the previous program are kept as they are, without touching them up, and immediately accessible from the workplace. Bringing the history into the new system is optional: it enters marked as «importado» (imported), without mixing with live clock-ins, and it does not replace the original file.
Official source: Estatuto de los Trabajadores, art. 34.9; Guía sobre el registro de jornada del Ministerio de Trabajo
That said, the migration itself is less work than it looks. What you have to do is close the old properly, set up the new and leave no days in between. Bringing the history into the new system is optional and does not replace the original file. If you had no record and are starting from scratch, the order is in how to implement working-time recording (in Spanish).
If you are still deciding whether to leave your current program, you have the comparison with Sesame HR, Factorial, Woffu and Bizneo HR.
How to keep the earlier records
The Ministry’s guide (in Spanish) accepts «any means of storage as long as its preservation and the reliability and unalterability of its content afterwards are guaranteed». For a migration that comes down to three things:
- The Excel, the paper or the export from the previous program are kept as they are, without touching them up: no cleaning rows or redoing totals.
- Daily records are kept, not a summary: the guide does not provide for replacing them with totals for longer periods, except what overtime requires.
- They must be showable without delay. According to the guide, «available» means «being and remaining physically at the workplace, or being accessible from it immediately».
The six steps
01
Freeze the old, do not delete it
Close the Excel or the paper folder with the date of the last day and keep it as it is, touching nothing. That file remains your record for the period it covers, and the obligation to keep it for four years does not move to the new system: it stays where it is.
02
Add the people and their working hours
People, workplaces and each person’s agreed working hours, with their collective agreement. It is the step that decides whether the balances come out right: annual hours entered wrongly produce overtime that does not exist, or hide it.
03
Choose how each team will clock in
The app on the phone for whoever carries it, the PIN kiosk at the bar or the warehouse for whoever does not (with real data, in preparation), the NFC card for whoever prefers not to take out their phone. Not everyone has to clock in the same way.
04
Inform staff and their legal representatives
Before going live, not after. If there will be geolocation or any control measure, prior information is mandatory, and you have a template ready to fill in. It is the step most often skipped and the one received worst when discovered afterwards.
05
Start on a Monday and overlap for a week
In the first week people clock in on the new system while the old one is kept running in parallel. It helps spot what does not fit — odd shifts, people without cover, breaks nobody had defined — with a net underneath.
06
Write the protocol
How entries are made, what happens when someone forgets to clock in and who authorises a correction. A generator produces it from a few questions. It is not mandatory today, but it is the first thing you will be asked for the day it is.
Depending on where you come from
From paper
The most obvious improvement. The earlier record is digitised or filed under lock, noting where it is: if the Inspección de Trabajo (Labour Inspectorate) requests it, you must be able to hand it over on the spot.
From Excel
Keep the file as it is, without cleaning or reordering it, and stop editing it: an Excel whose modification date is later than the period it records offers no guarantee that it has not been modified.
From another program
Before cancelling, export the whole history as CSV or Excel and keep it yourself. The obligation to keep it for four years is yours, not your provider’s, and recovering data from a cancelled account rarely goes well.
From a time clock
Export the punches before removing it: usually one row per punch with the person, the date, the time and whether it is in or out. That file, untouched, is the record of the earlier period.
From a fingerprint clock
It is two migrations in one: the data and the method. The punch history is kept like any other, but you should review the legal basis on which the biometric data was being processed and delete the templates once they are no longer used.
The CSV template in a migration
We publish a working-time recording template in CSV (in Spanish) that opens with Excel, LibreOffice or Google Sheets. Why it has each column is explained in the guide to the working-time recording template (in Spanish). In a migration it is useful at two moments:
- If you come from paper and have not yet chosen a system, moving to the template puts the daily record in order: date, person, start time and end time, which is what article 34.9 asks for, plus the recommended columns.
- During the overlap week, if the earlier record was paper, the template can serve as that record in parallel while the new system is checked.
What it is not: the import format. The template has one row per person and day with the start and end time; the history import asks for one row per punch with the NIF/NIE, the date, the time and the type. A spreadsheet, besides, can be changed without leaving a trace: the Ministry’s guide asks that the system provide «reliable, unalterable information that cannot be manipulated afterwards, whether by the employer or by the worker».
If you want to bring the history in
It is not mandatory. If you want to consult the earlier records from the same place, the application imports a clock-in history from an Excel workbook (.xlsx) or a CSV file (if the workbook has several sheets, you choose which one; old .xls files and password-protected workbooks are not read: save them as .xlsx or CSV): one row per punch with the person’s NIF/NIE, the date, the time and the type (in, out, start or end of break).
- There are two generic formats: spreadsheet, with one column per item, and time clock, with the date and time together and the type as E/S or IN/OUT. There are no formats for specific programs: we do not promise compatibility with any without having checked it against a real file.
- Before importing you see how the file is read, choose the separator and the encoding, and each row with a problem is shown with its number and its reason. Nothing is imported until you confirm it.
- What is imported enters at the end of the record marked as «importado» (imported), with the file’s fingerprint, without mixing with live clock-ins or touching anything earlier. Importing the same file twice duplicates nothing.
- Fingerprint or special-category columns that the file may contain are neither read nor stored.
What the import does not do: turn the history into a record made with this system. The chain proves that the entry has not changed since it was imported, not that the original clock-in happened as the file says. That is why the original is kept as it is: it is your record for that period.
Frequently asked questions
Can I throw away the Excel or the paper when I start with the new system?
No. Article 34.9 of the Estatuto requires records to be kept for four years, and that period does not move to the new system: the earlier file remains your record for the period it covers. Keep it as it is, untouched, and in a way that can be consulted from the workplace.
Do I have to move the history to the new program?
It is not mandatory. If you want to consult the earlier records from the same place, the application imports a clock-in history from an Excel workbook (.xlsx) or a CSV file, marked as «importado» (imported) and not mixed with live clock-ins. It does not replace the original file, which is kept as well.
Does the CSV template work for importing the history?
Not directly. The template has one row per person and day with the start and end time; the history import asks for one row per punch with the NIF/NIE, the date, the time and the type. The application comes with its own sample file for importing.
Does it work with the export from my clock or my current program?
There are two generic formats: spreadsheet and time clock. There are no formats for specific programs and we do not promise compatibility with any without having checked it against a real file. Before importing you see how the file is read and each row with a problem, with its reason.
What do I do with the data from a fingerprint clock?
The punch history is kept like any other record. Fingerprint or special-category columns that the file may contain are neither read nor stored when importing, and you should delete the clock’s templates once they are no longer used.
Sources
- BOEEstatuto de los Trabajadores, art. 34.9
- Ministerio de TrabajoGuía sobre el registro de jornada, Dirección General de Trabajo (PDF)
This page explains the rules in force at the review date and is not legal advice. The Ministry’s guide gives criteria «for information only». The quotations from the Ministry’s guide and from the legislation are free translations of the Spanish original.
What if I stay with Excel? (in Spanish)
The honest answer, with the nuance that matters before an inspection.
Does what I have now meet the requirements? (in Spanish)
Eight questions and a report with what you are missing, ordered by seriousness.
What if you do it for me?
An optional, separate service: we leave it configured and running.
Free until 31 May 2027. Just your email.
No card and no billing details: your email is all you need to start. You register your team in five minutes and you clock in today.