Bring your fleet across from a spreadsheet

CeeRent reads CSV files — the plain “comma-separated” format Excel and Google Sheets can both save or download. Make one file for each kind: vehicles, customers, bookings.

The first row must be the column names, spelled exactly as in CeeRent’s template. You can import up to 500 rows at a time; split a bigger sheet into parts.

Open Workspace → Import. The three imports are numbered: Vehicles, then Customers, then Future bookings. Each gets a check mark once something is imported.

Do them in that order. A booking finds its vehicle by plate number and its renter by email, so both must be in CeeRent first. Owners and managers can import.

On the Vehicles tab tap Download template and copy your fleet into it:

Imported vehicles go live at your first branch, with stand-in pictures and the next oil change set 5,000 km ahead. Add real photos, registration and insurance dates afterwards in Fleet → Vehicles.

On Customers, download that template. Columns:

• name — full name. email — required; it’s how CeeRent recognises the renter. phone — a mobile number with at least 10 digits.
• licenceCodes — the codes on their licence, separated by a space: A motorcycles, B cars, B1, B2. Example: A B.
• tier — standard, trusted or vip (empty means standard). Trusted and VIP renters may pay part now and the rest at pickup.

If an email is already one of your customers, CeeRent updates that customer instead of adding a second one. Every imported renter still uploads their licence and a selfie before their first pickup — the codes you import are a note, not a check.

On Future bookings, list the rentals already promised to people:

• plate — must match a vehicle in CeeRent. customerEmail — must match a customer.
• start and end — date and time like 2026-10-10T09:00. The start can’t be in the past and the end must be after it.
• paidBy — cash, gcash, maya, card, qrph, bank or otc (empty means cash).

CeeRent prices each booking from the vehicle’s rates in CeeRent, records it as paid in full by that method, and sends the renter the usual “booking confirmed” message. If someone hasn’t paid yet, add their booking by hand instead (see Get paid, step 5).

Tap Upload CSV and pick your file, or paste the rows into the box. Paste example fills in the template’s sample rows so you can see how it should look.

CeeRent shows how many rows it found and a preview of the first five. If the columns look right, tap Import (it says how many rows, e.g. Import 24 rows).

Each row goes in on its own — one bad row doesn’t stop the others. The result says “Imported 22 of 24” and lists each problem by row. Row 1 is your header, so your first vehicle is row 2. Common ones:

• A vehicle with this plate already exists. — it’s in already; delete the row.
• You’ve used all your vehicle slots. — add a pack of 5 slots for ₱299/month in Subscription, or set some vehicles inactive.
• Daily rate must be more than zero. / Enter the plate number. — fill in the cell.
• No vehicle with plate … / No customer … Import customers first. — check the spelling, or import that vehicle or customer first.
• Those dates are no longer available for this vehicle. — two bookings overlap on one vehicle.
• Pickup time is in the past. — past rentals can’t be imported.

Fix those rows and import just them again. Every run is listed under Import history.