Skip to content

Getting started Updated on November 11, 2026

Import your vehicles, customers and reservations from a file

Bring in an Excel or CSV file (export from your previous software or a spreadsheet kept by hand), check every row before records are created, take over upcoming reservations and ongoing rentals, follow and cancel an import.

Instead of entering your fleet and your customers record by record, you can bring it in from a file: an export from your previous software or a spreadsheet kept by hand. Autoria checks every row with the same rules as manual entry, shows you the result row by row, and only creates the records once you agree. The interface is in French; labels are quoted as they appear on screen.

Import is open to the Owner, Administrator and Manager roles (Propriétaire, Administrateur, Responsable), on every plan. It is offered for vehicles, for customers, blocklist included, and for upcoming reservations and ongoing rentals; the Import de données (data import) tab only appears in Paramètres (settings) for the kinds of records Autoria can import.

Prepare the file

  • Accepted formats: .xlsx workbook or CSV file, 10 MB at most. Only the first sheet of a workbook is read. An old .xls file must first be saved as .xlsx.
  • One row per record, one column per piece of information, one header row above the data. Title rows above the headers are skipped.
  • The Télécharger le modèle (download the template) button gives you an empty CSV file with the headers Autoria recognizes. A file exported from another software works too: you will match its columns at the next step.

Import step by step

  1. Open Paramètres (settings), Import de données (data import) tab, then click Importer des données (import data).
  2. Fichier (file) step: answer Que contient votre fichier ? (what does your file contain?), drop the file in the Déposez votre fichier ici (drop your file here) area (or Parcourir, browse), then click Lire le fichier (read the file). Autoria reads the file in the background: the result shows as soon as reading is over.
  3. Colonnes (columns) step: for each column of your file, choose the Autoria information it holds, or Ignorer cette colonne (ignore this column). Columns whose header is recognized are already filled in. Click Simuler (simulate).
  4. Vérification (check) step: the simulation checks every row without creating anything. You see the number of Lignes prêtes à importer (rows ready to import), the number of Lignes refusées (refused rows), the room left in your plan, and, for each refused row, the column, the value read and the reason for the refusal, marked Refus (refusal). A row marked Avertissement (warning) stays ready: it will be imported, only the flagged information is not taken over (for example a technical inspection without its inspection date: the vehicle is imported without the inspection, to be entered afterwards on its record).
  5. Fix what needs fixing: change the column matching with Précédent (previous), or correct your file and start again from the Fichier step. If you fixed something in Autoria (a duplicate vehicle deleted, a higher plan), click Relancer la simulation (run the simulation again).
  6. Click the import button, which shows the number of ready rows. Only those rows are created; refused rows never are.
  7. Import step: records are created in batches. You can close the window, the import goes on. The result shows the Fiches créées (records created), the rows refused at creation time and why.

If the member who started the import loses access to your company while it is being written, because they are deactivated or removed from the team, the writing stops at the next batch. The result says « L'import s'est arrêté car son auteur n'a plus le droit d'importer : N ligne(s) n'ont pas été traitées. » (the import stopped because its author is no longer allowed to import: N row(s) were not processed). The records already created stay, the Lignes non traitées (rows not processed) are not created, and the import can still be cancelled with Annuler l'import (see below).

What Autoria checks

  • The same rules as creating a vehicle by hand: required information, including a daily rate above 0, allowed values, registration number or chassis number (VIN) already used in your company or higher up in the file. A row without a daily rate, or at 0, is refused.
  • The insurance expiry date, the vignette expiry date and the technical inspection are optional. A vehicle imported without one of them carries the Non renseignée (not provided) tag for that document, on its record and in the vehicle list (hover the tag in the list to see which documents it covers); a document whose expiry date has passed carries the Expirée (expired) tag. A document stays valid until the end of its expiry day. Complete them from the record with Ajouter une assurance (add an insurance), Ajouter une vignette (add a vignette) or Ajouter une visite (add an inspection).
  • The same rules as creating a customer by hand: a row without a name or a phone is refused; so is an identity document already held by a customer record of your company, or repeated higher up in the file. The email, birth date, nationality, identity document and driving licence are optional: a customer imported without them carries the Pièces à compléter (documents to complete) tag, and their documents will be required when the vehicle leaves.
  • Your plan's vehicle or customer limit: rows beyond the remaining room are refused.
  • Dates are read in the order used in your company's country (day, month, year in Tunisia); a two-digit year is refused.
  • No duplicates: a row whose reference from the previous software or registration number already exists is not created a second time. You can therefore import the ready rows right away, correct the others in your file, then drop it again: only new or corrected rows are created.

Import your customers and your blocklist

  • Nom and Prénom (last and first name): with separate columns, each is taken as is. With a single Nom et prénom (full name) column, the last word becomes the first name and the rest the last name ("Ben Salah Mohamed": last name "Ben Salah", first name "Mohamed"); beyond two words, the row carries an Avertissement (warning) so you check the split on the record.
  • Nationalité (nationality): written in full ("Tunisienne", "Tunisie", "Tunisia"), in Arabic or as its two-letter code ("TN"); an unrecognized nationality refuses the row.
  • Type de pièce (document type): optional column, "CIN" (identity card) or "Passeport" (passport), in French, English or Arabic; an empty cell means identity card, any other value refuses the row. Duplicate detection takes the type into account, as in manual entry: a passport and an identity card with the same number are two different documents.
  • Liste noire (blocklist): "Oui" (yes, or "X", "Bloqué") imports the customer Bloqué (blocked), exactly as if you had blocked them from their record: they can no longer be picked for a rental. "Non" (no), an empty cell or "RAS" leave them unblocked. Any other text in this column (for example "Impayé", unpaid) blocks the customer too and becomes the reason for the block.
  • Motif du blocage (reason for the block): for a blocked customer, the text of this column is taken as the reason for the block, shown on their record (after the text of the Liste noire column if there is one). For a customer who is not blocked, this remark is not taken over (Avertissement).
  • Adresse (address): an address kept in a single column is not taken over (Avertissement); enter it afterwards on the customer record.

Import your reservations and ongoing rentals

Choose Réservations et locations en cours (reservations and ongoing rentals) in Que contient votre fichier ?. Import your vehicles and customers first: each reservation is attached to a vehicle of your agencies (by its registration, or its reference in the previous software) and to a customer of your company (by their identity document, or their reference in the previous software). A vehicle or customer that cannot be found refuses the row: it is never created on the way.

  • Date de bascule (cutover date): at the Colonnes (columns) step, enter the last day recorded in your previous software, today or a past day, before clicking Simuler (simulate). Advances and deposits collected up to that day are taken over; a payment dated after that day refuses its row (record it in Autoria as a normal payment, or move the cutover date back).
  • Upcoming reservation: it is imported confirmed, without a contract. The contract is made at departure, as for a reservation entered in Autoria. Departure and return dates must carry a time (in the same column as the date, or in Heure de départ and Heure de retour columns).
  • Ongoing rental: a vehicle already out is imported as an ongoing rental, with the paper contract of the previous software. The Numéro de contrat (contract number) is required; the contract is shown as signed on paper on the departure date, and Autoria invites you to upload its scan on the reservation. A missing Kilométrage de départ (departure mileage) is replaced by the current mileage of the vehicle, a missing Carburant au départ (fuel at departure) by a full tank, each with an Avertissement (warning).
  • Price: the price is computed with the rate of the vehicle, as in manual entry. If the Montant total (total amount) of the file is different, the row carries an Avertissement with the difference, and the total of the file is copied into a note on the reservation: apply the difference at return.
  • Advance and deposit already collected: they are taken over on the reservation, with the receipt number of the previous software. An advance taken over is deducted from the invoice at return; it gets no new receipt number and does not enter your cash journal, since it was collected in the previous software. A deposit taken over is released or retained at return like any deposit. A deposit is only taken over for an ongoing rental.
  • What is not taken over: a reservation that is closed, cancelled, a quote or an option in the previous software is not imported; it is counted in the Lignes non reprises (rows not taken over). Invoices of the previous software are never imported: the invoice of the rental is made by Autoria at return. A departure or return place that is not a place recorded in Autoria is copied into the note.
  • Refusals: as in manual entry, a row is refused if the customer is blocked, if the vehicle is already taken on those dates (reservation, maintenance, claim), if the vehicle is already out for another rental, or if the contract number is already recorded in the agency. Two rows of the file that book the same vehicle on overlapping dates are refused from the second one.

An imported reservation that has been changed, paid or closed in Autoria prevents the cancellation of its import: the cancellation window gives the reason. Cancel the import of the reservations before the import of their vehicles or customers.

If Autoria says the file's characters are not in UTF-8, choose Arabe (Windows-1256) (Arabic) or Europe de l'Ouest (Windows-1252) (Western European) in Encodage des caractères (CSV) (character encoding), then drop the file again. Leave Automatique (UTF-8) otherwise.

Follow and cancel an import

Your imports, running or finished, are listed in the Import de données tab with their status. Click Ouvrir (open) to pick an import up where it stands. A member attached to some agencies only sees the imports they started themselves.

To undo a finished import, open it and click Annuler l'import (cancel the import), then confirm. Every record it created is deleted for good, with its notes and history. The cancellation is refused as a whole, without deleting anything, if one of those records is already used (rental, claim, maintenance or document) or attached to an agency outside your scope: the window lists the rows concerned. Undo those uses first, or keep the import.

An import can be cancelled as long as its data is kept: 30 days after the end of the import for a company in Tunisia. After that, records are deleted one by one.

An import made for you by the Autoria team

When the Autoria team brings your data in for you (for instance from a copy of the database of your previous software), it uploads the file into your company and runs it through the same checks as your own imports, your plan limit included. The import belongs to you: it appears in the Import de données tab for the members who see every agency, marked Déposé par l'équipe Autoria pour votre société (uploaded by the Autoria team for your company) or Importé par l'équipe Autoria pour votre société (imported by the Autoria team for your company). You can open it, simulate it again, import it or cancel it like an import you started yourself.

Before reaching your data, the Autoria team gives a reason. The Owner finds that reason and every action of the import in Paramètres (settings), entry Accès d'Autoria (Autoria access).

support@autoria.tn