Import Guide
Import Vehicle History Into Wrenzo
Import is designed for records that already live in Excel, Google Sheets, shop exports, notes, or a personal maintenance log. Export your sheet as CSV, map the columns if needed, and Wrenzo previews the match before anything is saved. Start imports from the Garage or directly from this guide. Use the Logbook when you want to export records later.
Bring a CSV
Use the Wrenzo template, or export your existing spreadsheet from Excel or Google Sheets.
Map your columns
If your headers are different, Wrenzo suggests matches and lets you choose what each column means.
Preview before import
Wrenzo shows vehicle matches, duplicate VIN warnings, and rows needing attention before saving.
How Vehicle Matching Works
If a row has a VIN that already exists in your Garage, Wrenzo adds those rows to the existing vehicle instead of creating a duplicate.
If a VIN is new, Wrenzo tries to decode it through NHTSA vPIC during preview. Decoded year, make, model, engine, and powertrain are used only when those fields are blank in your CSV. Trim stays manual so the imported vehicle keeps the cleaner trim name you choose.
If there is no VIN, the first row for that vehicle needs year, make, and model. Nickname, engine, mileage, and specs are optional.
Required Entry Fields
date
The date for the history entry, usually YYYY-MM-DD from a spreadsheet.
title
A short label, such as Oil Change, Front Brakes, or Battery Test.
Vehicle Fields
vin
Optional, but recommended. Wrenzo uses it to match existing vehicles and auto-fill blank vehicle details when possible.
year, make, model
Required only when VIN is blank. These identify the vehicle when there is no VIN.
vehicle_nickname
Optional display name, such as Work Truck or Civic.
trim, engine, vehicle_mileage
Optional details that make the Garage record more useful.
tire_pressure, tire_size, oil_type, oil_capacity
Optional specs saved to the vehicle.
Vehicle History and Reminder Fields
entry_type
Optional. Use diagnosis, maintenance, repair, modification, project, reminder, recall, or note. If blank, Wrenzo estimates the type from the title, notes, and due fields.
status
Optional. Use open, resolved, completed, or planned. If blank, diagnosis and recall default to open, reminders default to planned, and maintenance, repair, modification, project, or note entries default to completed.
entry_mileage
Optional mileage for that specific record.
notes
Optional context from your spreadsheet, shop receipt, or personal notes.
cost, time_spent_hours, parts
Optional values used for history and spending/reporting views. Use decimal hours, such as 0.75 for 45 minutes.
receipt_reference
Optional receipt number, file name, or external note. Attachments are uploaded separately.
due_date, due_mileage, repeat_months, repeat_miles
Optional reminder fields. These are most useful when entry_type is reminder.
A few import notes
- Start an import from this guide or from the Garage actions menu.
- Existing spreadsheets do not have to match the Wrenzo template. If the headers are different, Wrenzo opens a mapping step first.
- CSV import brings in vehicle details, history entries, reminders, costs, mileage, parts, and notes. Receipt images and other files can be added as attachments after the records are imported.
- CSV exports live in the Logbook, where you can export the current tab or the full logbook view.
- Costs and mileage can include common formatting. Wrenzo cleans extra characters during import.
- Older templates with time_spent_minutes still work. Wrenzo converts those values into hours during import.
- Separate multiple parts with semicolons, line breaks, or pipes.
- Preview warnings are there for review and may not block import. Errors must be fixed before importing.
Need help preparing a spreadsheet? Contact Wrenzo support or email contact@wrenzo.autos with a quick note about what you are trying to import.