Importing Vehicles

Our smart Vehicle import wizard enables you to bring your vehicles list from another system or spreadsheet in just a few short minutes.

You can add your vehicles from any source as long as the data is in .CSV file format and has a heading for each column (a header row). 

CarVue is able to map your data to any of the fields below. If you use the same field names in your header row, we'll be able to pick up the column and map it automatically to CarVue fields.

Registration
Make
Model
Derivative
VIN
Reg Date
Date of Manufacture
Mileage
Colour
Paint Code
Trim
Fuel
Door Plan
Gear Box
Gear Box No
Co2 Emission
Engine No
Engine Code
Engine Size
Power
Key No
Radio No
Service Due Date
MOT Due Date
Warranty Ends

To quickly add your vehicles into CarVue go to the Settings page and select Import Vehicles.

Then simply follow our 4 step guide below.



1. Choose your file

Click Choose File and locate your CSV file. Make sure your data has a header row (row 1). This is really important as if you don't have a header row, we'll take the first row of your data and assume it's a heading! 
Select Start Import to move onto step 2. 




2. Map the data columns for CarVue


CarVue uses smart matching to help match up the fields, so any we pick up automatically will be indicated with ticks. Use the drop down boxes to map the rest of your fields against CarVue fields and select which columns to import. Any fields you don't want to import simply select on the drop down 'Don't Import'. Ensure you have mapped a field against Registration and VIN (this is a must for the import) before you Save and Continue.

Date Format must be in your local format (e.g. DD/MM/YYYY), for when you fill in a date for Reg Date, Annual Check Due Date, Service Due Date and Warranty Ends (please note dates are optional imports).



3. Pick default Speedometer Reading


Select your default Speedometer Reading, Miles or Kilometers This will be used across CarVue and can be edited on an individual basis for each contact if you want to change it at a later date. You can also review the field mappings you chose in the stage before at this time. Once you have made your selection move onto the final stage by clicking Save and Continue


4. Review and Complete Import

Our Import process will now take a quick look at your data and let you know if there are any issues. If there are, we'll show them to you at this point. Review any rows that are not going to be imported due to invalid data, e.g. Reg Date, Annual Check Due Date, Service Due Date and Warranty Ends
Click Complete Import to finish the process. 


Can I import more than one file?


Yep. You can import as many files as you like and we will add them in to your vehicles. But be careful: if you import the same sheet more than once or another data source with some of the same vehicle data, you will end up with duplicate records.

Feedback and Knowledge Base