mobileLogo

Upload-Interface CSV

Also see the general (non-data-format-specific) description of the Upload-Interface.

Vehicle-file naming

The file name extension of the vehicle-file must be .csv. Example: fooBar.csv

Note: This refers to the vehicle-file, not the surrounding ZIP file. The ZIP file (if there is any) always ends with .zip.

Data format

For the CSV ("colon separated values") format of mobile.de the data fields (within the data records) are separated from each other by semicolon (;).

The content of text fields must be written in inverted commas ("..."). If there are inverted commas within some data fields (e.g. 17" rims oder radio "Gamma"), these must be marked with additional inverted commas: 17"" Felgen and Radio ""Gamma"". See also the remarks field in the example data record further below. If any fields in the CSV format are sent empty, this means the same as "no input". An empty CSV file can be uploaded to delete the entire inventory.

The following data fields must be transferred in the order listed below, each one in a single line in the file. Line breaks within data fields are therefore not allowed; empty fields are not to be taken out. An incomplete csv-file in which not all fields have been transmitted can occasionally lead to incomplete specifications.

mobile.de can change the order and contents of these fields at any time.

The character set is ISO-8859-15.

No. Co. Field name Mandatory Description
0 A customer-number For transfer service providers with API-Account, this must be the customer-number of the vehicle dealer (see Referencing customers (for TSPs)).
1 B internal number yes text (field size max. 40 characters identifying the vehicle). You may only use the characters a-z, A-Z, the digits 0-9 and the special characters - and _. All other characters, primarily all other special characters, umlauts and all non-ASCII characters are forbidden (see Referencing vehicle ads (inventory-key)).
2 C category yes text (see Categories, makes, models)
3 D make yes text (see Categories, makes, models)
4 E model yes text (see Categories, makes, models)
5 F performance integer, shows kW-performance of the vehicle
6 G mot date (format='mm.yyyy'), technical inspection (MOT)
7 H reserved, must be empty
8 I Reg-date date (format='mm.yyyy'), first time registration date
9 J kilometre yes integer without separators, mileage on the clock. Mandatory field for used cars, motorcycles, trucks up to 7.5t, trucks over 7.5t, semi-trailer trucks, and buses.
10 K price figure, gross or net price 1 4
11 L VAT yes '0', '1' (0=VAT reclaimable, 1=VAT not reclaimable) 1
12 M reserved, must be empty
13 N classic vehicle '0', '1' (0=no, 1=yes) 2
14 O vin text, Vehicle Identification Number (optional, only for your information, will not be analysed)
15 P damaged_vehicle yes '0', '1' (0=no, 1=yes). Also see damage table.
16 Q colour text (field size max. 32 characters), may not consist of numbers only
17 R a/c '0-2' (0=no a/c or automatic a/c, 1=a/c, 2=automatic a/c)
18 S taxi '0', '1' (0=no, 1=yes)
19 T adapted for disabled '0', '1' (0=no, 1=yes)
20 U one-year-old car yes '0', '1' (0=no, 1=yes) 2
21 V new car yes '0', '1' (0=no, 1=yes)
22 W our recommendation yes '0', '1' (0=no, 1=yes)
23 X dealer price figure, gross or net price for dealer 1 4
24 Y reserved, must be empty
25 Z remarks text (field size max. 3000 characters). Also see Formatting Syntax.
26 AA image_id text. Permissible characters are numbers, the characters A to Z, respectively a to z, as well as blanks and hyphens. Underscores are possible but not recommended. All other characters, primarily all other special characters, umlauts and all non-ASCII characters are forbidden. The picture ID conveys the information which picture is belonging to which vehicle. If field image_id (26/AA) contains a picture ID, this information is prioritized over the field internal number (1/B). The naming logic of the picture files is [image_id]_1.jpg (or [image_id]_01.jpg), ..., [image_id]_15.jpg. If field image_id (26/AA) is empty, the allocation of the image is still managed by the field internal number (1/B) (see Referencing images).
27 AB metallic yes '0', '1' (0=no, 1=yes)
28 AC currency please only use "EUR"
29 AD VAT rate VAT rate. Integer or floating-point number. See reference data for possible values. 1 4
30 AE warranty yes '0', '1' (0=no warranty, 1=warranty incl.)
31 AF light-alloy wheels '0', '1' (0=no, 1=yes)
32 AG esp '0', '1' (0=no, 1=yes)
33 AH abs '0', '1' (0=no, 1=yes)
34 AI trailer coupling '0', '1' (0=no, 1=yes)
35 AJ reserved, must be empty
36 AK immobiliser '0', '1' (0=no, 1=yes)
37 AL navigation system '0', '1' (0=no, 1=yes)
38 AM sunroof '0', '1' (0=no, 1=yes)
39 AN central locking system '0', '1' (0=no, 1=yes)
40 AO electric windows '0', '1' (0=no, 1=yes)
41 AP all wheel drive '0', '1' (0=no, 1=yes)
42 AQ doors integer, number of doors
43 AR emissions sticker 1=no sticker, 2=red, 3=yellow, 4=green
44 AS power steering '0', '1' (0=no, 1=yes)
45 AT bio diesel '0', '1' (0=no, 1=yes), Biodiesel suitable, only for diesel fuel
46 AU servicebook '0', '1' (0=no, 1=yes)
47 AV catalytic converter '0', '1' (0=no, 1=yes), motorcycles only
48 AW kickstarter '0', '1' (0=no, 1=yes), motorcycles only
49 AX estarter '0', '1' (0=no, 1=yes), motorcycles only
50 AY demonstration model yes '0', '1' (0=no, 1=yes) 2
51 AZ drive '1-3' (1=Chain, 2=Kardan, 3=Belt), motorcycles only
52 BA cubic capacity integer, Cubic Capacity of the engine
53 BB lifting capacity integer in kg, commercial vehicles only
54 BC load capacity integer in kg, commercial vehicles only
55 BD licensed weight integer in kg, commercial vehicles only
56 BE lifting height integer in mm, forklift trucks only
57 BF installation height integer in mm, forklift trucks only
58 BG year of construction integer 4 digits
59 BH operating hours integer, commercial vehicles only
60 BI number of seats number of passenger seats - coach, car and truck up to 7.5 t only
61 BJ emission class '1-6' (1=euro1, 2=euro2, ...), emission class
62 BK cab '1-4' (1=twin berth, 2=berth, 3=local distance, 4=long distance), commercial vehicles only
63 BL axles integer, number of axles, commercial vehicles only
64 BM cruise control '0', '1' (0=no, 1=yes)
65 BN auxiliary heating '0', '1' (0=no, 1=yes)
66 BO cabin '0', '1' (0=no, 1=yes), commercial vehicles only
67 BP protective roof '0', '1' (0=no, 1=yes), commercial vehicles only
68 BQ full fairing '0', '1' (0=no, 1=yes), commercial vehicles only
69 BR municipal '0', '1' (0=no, 1=yes), commercial vehicles only
70 BS crane '0', '1' (0=no, 1=yes), commercial vehicles only
71 BT retarder_intarder '0', '1' (0=no, 1=yes), commercial vehicles only, retarder or intarder
72 BU drivers sleeping compartment '0', '1' (0=no, 1=yes), commercial vehicles only
73 BV tv '0', '1' (0=no, 1=yes)
74 BW wc '0', '1' (0=no, 1=yes), coaches and motorhomes only
75 BX tail lift '0', '1' (0=no, 1=yes), commercial vehicles only
76 BY hydraulic system 1=other, 2=dumper, 3=shifting bottom, 4=tank, commercial vehicles only
77 BZ sliding door '0', '1' (0=no, 1=yes), commercial vehicles only
78 CA wheel formula 0=whatever, 1=4x2, 2=4x4, 3=6x2, 4=6x4, 5=6x6, 6=8x4, 7= 8x6, 9=8x8, commercial vehicles only
79 CB divider '0', '1' (0=no, 1=yes), commercial vehicles only
80 CC ebs '0', '1' (0=no, 1=yes), commercial vehicles only
81 CD available for rental '0', '1' (0=no, 1=yes), available for rental, commercial vehicles only
82 CE compressor '0', '1' (0=no, 1=yes), commercial vehicles only
83 CF air suspension '0', '1' (0=no, 1=yes), commercial vehicles only
84 CG disc brake '0', '1' (0=no, 1=yes), commercial vehicles only
85 CH front hydraulics '0', '1' (0=no, 1=yes), commercial vehicles only
86 CI bss '0', '1' (0=no, 1=yes), commercial vehicles only
87 CJ quick change attachment '0', '1' (0=no, 1=yes), commercial vehicles only
88 CK central lubricant application '0', '1' (0=no, 1=yes), commercial vehicles only
89 CL kitchen '0', '1' (0=no, 1=yes), commercial vehicles only
90 CM cold store '0', '1' (0=no, 1=yes), commercial vehicles only
91 CN sleep seats '0', '1' (0=no, 1=yes), commercial vehicles only
92 CO front jack '0', '1' (0=no, 1=yes), commercial vehicles only
93 CP visible for dealers only '0', '1' (0=no, 1=yes), commercial vehicles only
94 CQ reserved '0', '1' (0=no, 1=yes), commercial vehicles only 2
95 CR envkv '0', '1' (0=no, 1=yes) 5
96 CS consumption inner number in l/100km (natural gas (CNG) in kg/100km, is ignored for electric vehicles) 4
97 CT consumption outer number in l/100km (natural gas (CNG) in kg/100km, is ignored for electric vehicles) 4
98 CU consumption combined number in l/100km (natural gas (CNG) in kg/100km, electric vehicles in kWh/100km) 4
99 CV emission integer in g/km (is set to 0 for electric vehicles)
100 CW xenon headlights '0', '1' (0=no, 1=yes)
101 CX seat heating '0', '1' (0=no, 1=yes)
102 CY diesel particulate filter '0', '1' (0=no, 1=yes)
103 CZ parking distance control system '0', '1' (0=no, 1=yes) This field will be replaced by fields 199-202.
104 DA schwackecode number
105 DB delivery date date (format='dd.mm.yyyy'). No delivery date (105/DB) and delivery period (106/DC) at the same time.
106 DC delivery period only cars, allowed Values: 1, 2, 3, 4, 5, 6, 7, 14, 42, 60, 90, 120, 150, 180, 270 und 360. No delivery date (105/DB) and delivery period (106/DC) at the same time.
107 DD delivery charge number (in Euro), delivery charge in final price included
108 DE mot new '0', '1' (0=no, 1=yes), MOT and emission test will be renewed after sale
109 DF fuel type 1=petrol, 2=diesel, 3=LPG, 4=natural gas, 6=electric, 7=hybrid-petrol, 8=hydrogen, 9=ethanol, 10=hybrid-diesel, 0=other
110 DG gearbox '0-3' (0=no details, 1=manual gearbox, 2=semi automatic, 3=automatic)
111 DH export only vehicle '0', '1' (0=no, 1=yes), only second hand cars
112 DI single_day_registration '0', '1' (0=no, 1=yes), only second hand cars
113 DJ eyecatcher '0', '1' (0=no, 1=yes)
114 DK hsn number
115 DL tsn digits and letters
116 DM page_1_ad '0', '1' (0=no, 1=yes)
117 DN reserved, must be empty
118 DO reserved, must be empty
119 DP e10 '0', '1' (0=no, 1=yes), E10 suitable - only car, motorhome and truck up to 7.5t, only petrol fuel
120 DQ reserved, must be empty
121 DR vegetable oil '0', '1' (0=no, 1=yes), vegetable fuel suitable - only cars and semi trailer trucks, only diesel fuel
122 DS scr '0', '1' (0=no, 1=yes), urea tank - semi trailer trucks and diesel only
123 DT case '0', '1' (0=no, 1=yes), only motorbikes
124 DU roll bar '0', '1' (0=no, 1=yes), only motorbikes
125 DV front shield '0', '1' (0=no, 1=yes), only motorbikes
126 DW independent climate control unit '0', '1' (0=no, 1=yes), only motorhome, lorries over 7.5t, semi trailer trucks and Coaches
127 DX s-s-tyres '0', '1' (0=no, 1=yes), only semi trailer trucks
128 DY approval for road service '0', '1' (0=no, 1=yes), only construction machines
129 DZ bunk bed '0', '1' (0=no, 1=yes), only motorhome
130 EA packed bed '0', '1' (0=no, 1=yes), only motorhome
131 EB rear garage '0', '1' (0=no, 1=yes), only motorhome
132 EC marquee '0', '1' (0=no, 1=yes), only motorhome
133 ED sep-shower '0', '1' (0=no, 1=yes), only motorhome
134 EE solar power system '0', '1' (0=no, 1=yes), only motorhome
135 EF middle couch '0', '1' (0=no, 1=yes), only motorhome
136 EG round couch '0', '1' (0=no, 1=yes), only motorhome
137 EH side couch '0', '1' (0=no, 1=yes), only motorhome
138 EI damage by hail '0', '1' (0=no, 1=yes), only motorhome
139 EJ sleeping berth integer, number of beds, only motorhome
140 EK vehicle-length integer, milimeters, only motorhome
141 EL vehicle-width integer, milimeters, only motorhome
142 EM vehicle-height integer, milimeters, only motorhome
143 EN loading space-europallet integer, number of pallets, only vans/lorries up to 7.5t, lorries over 7.5t, trailers and semi-trailers
144 EO loading space integer, space in m3, only vans/lorries up to 7.5t, lorries over 7.5t, trailers and semi-trailers
145 EP loading space length integer, milimeters, only vans/lorries up to 7.5t, lorries over 7.5t, trailers and semi-trailers
146 EQ loading space width integer, milimeters, only vans/lorries up to 7.5t, lorries over 7.5t, trailers and semi-trailers
147 ER loading space height integer, milimeters, only vans/lorries up to 7.5t, lorries over 7.5t, trailers and semi-trailers
148 ES renew ad '0', '1' (0=no, 1=yes)
149 ET financing rate per cent financing example, rate per cent 4
150 EU financing monthly rate financing example, monthly rate (integer)
151 EV financing period financing example, period in months (12, 24, 36, 48, 60, 72, 84 or 96)
152 EW financing first installment financing example, first installment (integer)
153 EX financing ending rate financing example, ending rate (integer)
154 EY financing feature '0', '1' (0=no, 1=yes)
155 EZ interior color 1=black, 2=grey, 3=beige, 4=brown, 5=other
156 FA interior type 1=leather, 2=partial leather, 3=fabric, 4=velour, 5=alcantara, 6=other
157 FB airbag 2=driver airbags, 3=front airbags, 4=front and side airbags, 5=front and side and more airbags
158 FC previous owners Number of previous owners (unsigned integer)
159 FD top of page '0', '1' (0=no, 1=yes)
160 FE financing gross credit amount financing example, financing gross credit amount 4
161 FF financing closing costs financing example, financing closing costs 4
162 FG financing rate insurance 0=The payment protection insurance is not included in the offer and is displayed as "not received" on the details page, 0=The payment protection insurance is with costs of that value included 4
163 FH financing net credit amount financing example, financing net credit amount 4
164 FI financing bank financing example, financing bank, text (field size max. 150 characters)
165 FJ financing nominal interest rate financing example, financing nominal interest rate 4
166 FK financing type of nominal interest rate financing example, financing type of nominal interest rate: 1=bound, 2=variable, 3=combined
167 FL country-version country-version(e.g. DE,IT,ES,PL)
168 FM video-url Youtube Url 3
169 FN energy_efficiency_class energy efficiency class (A+, A, B, C, D, E, F or G)
170 FO envkv_petrol_type for fuel type petrol: the petrol type, the consumption values are based on (NORMAL, SUPER or SUPER_PLUS)
171 FP electric exterior mirrors '0', '1' (0=no, 1=yes)
172 FQ performance handling system '0', '1' (0=no, 1=yes)
173 FR sport package '0', '1' (0=no, 1=yes)
174 FS bluetooth '0', '1' (0=no, 1=yes)
175 FT bordcomputer '0', '1' (0=no, 1=yes)
176 FU cd player '0', '1' (0=no, 1=yes)
177 FV electric adjustable seats '0', '1' (0=no, 1=yes)
178 FW head-up display '0', '1' (0=no, 1=yes)
179 FX speakerphone '0', '1' (0=no, 1=yes)
180 FY mp3 interface '0', '1' (0=no, 1=yes)
181 FZ multi-function steering wheel '0', '1' (0=no, 1=yes)
182 GA ski bag '0', '1' (0=no, 1=yes)
183 GB tuner '0', '1' (0=no, 1=yes)
184 GC sport seats '0', '1' (0=no, 1=yes)
185 GD panorama roof '0', '1' (0=no, 1=yes)
186 GE child seat attachment '0', '1' (0=no, 1=yes)
187 GF curve lights '0', '1' (0=no, 1=yes)
188 GG light sensor '0', '1' (0=no, 1=yes)
189 GH front fog lights '0', '1' (0=no, 1=yes)
190 GI daytime running lights '0', '1' (0=no, 1=yes)
191 GJ traction control system '0', '1' (0=no, 1=yes)
192 GK start stop system '0', '1' (0=no, 1=yes)
193 GL rain sensor '0', '1' (0=no, 1=yes)
194 GM non smoker vehicle '0', '1' (0=no, 1=yes)
195 GN roof rack '0', '1' (0=no, 1=yes)
196 GO accident damaged '0', '1' (0=no, 1=yes). Also see damage table.
197 GP roadworthy '0', '1' (0=no, 1=yes). Also see damage table.
198 GQ construction date date (format='dd.mm.yyyy')
199 GR parking assistant front sensors '0', '1' (0=no, 1=yes)
200 GS parking assistant rear sensors '0', '1' (0=no, 1=yes)
201 GT parking assistant camera '0', '1' (0=no, 1=yes)
202 GU parking assistant self steering system '0', '1' (0=no, 1=yes)
203 GV reserved, must be empty
204 GW red pencil '0'=not booked; '1'=booked; NULL=do not change current value
205 GX Kleinanzeigen export '0'=not booked; '1'=booked; NULL=do not change current value
206 GY plugin hybrid '0', '1' (0=no, 1=yes)
207 GZ combined power consumption Combined power consumption for Plugin-Hybrid cars in kWh/100km. Mandatory, if 95 = yes and 206 = yes
208 HA highlight 1 plain text (field size max. 22 characters), get possible number of highlights
209 HB highlight 2 plain text (field size max. 22 characters), get possible number of highlights
210 HC highlight 3 plain text (field size max. 22 characters), get possible number of highlights
211 HD conditions financing example Conditions financing example, further conditions, text (field size max. 60 characters)
1 If a VAT rate (29/AD) is shown and VAT (11/L) is set as VAT reclaimable, the VAT is shown and price (10/K) and dealer price (23/X) will be interpreted as net prices, if not, then as gross prices. VAT rate (29/AD) will be read in, if VAT (11/L) is set as VAT reclaimable.
2 only one of the fields classic vehicle (13/N), one-year-old car (20/U), demonstration model (50/AY) und single day registration (112/DI) may be selected at the same time.
3 We accept only URLs in the youtube.com/xxx format.
4 You may only use one decimal separator. Permitted separators are . or , (full stop or comma). Other inputs are not allowed (e.g. containing multiple full stops as thousands separator).
5 The data given are approximate figures and provided by the ad creator. The figures can represent people's experience with this model or come from other sources.

Example data record

The example data record has to be one line only. Line-breaks here are due to lay-out:

        
            "2";"Beispiel";"Cabrio/Roadster";"ASTON MARTIN";"DB9 Volante";"283";"";"";"";"";
            "17226";"0";"";"0";"WXYZ23X42X23X42X23X42YYY";"0";"schwarz";"2";"0";"0";"0";"1";
            "1";"";"";"Getriebe Automatik-6-Gang, ASR Antriebsschlupfregelung, CD-Wechsler,
            Radio/CD, Aussentemperaturanzeige, Diebstahlwarnanlage, Scheinwerferreinigung,
            Bordcomputer/Reiserechner, Heckantrieb, Lenksaeule mech/elektrisch einstellbar,
            elektrisch einklappbare Aussenspiegel, 19-"" Felgen, Designpaket Royal,
            Windschott, Raucherpaket";"2";"1";"EUR";"19.00";"1";"0";"1";"1";"0";"";"0";"1";
            "0";"1";"1";"0";"";"2";"1";"0";"0";"0";"0";"0";"0";"";"";"";"";"";"1945";"2578";
            "";"";"";"";"";"";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"3";"0";"4x4";
            "0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"1";"19.5";
            "14.9";"17.5";"155";"1";"1";"0";"1";"";"";"14";"";"0";"1";"3";"0";"0";"1";"";"";
            "";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";
            "";"";"";"";"";"";"0";"3.50";"150";"24";"10000";"0";"1";"1";"1";"1";"0";"1";
            "25887.23";"355.20";"300";"22987.34";"CreditPlus Bank AG";"2.87";"1";"DE";
            "http://www.youtube.com/watch?v=a6-HSQG4Sfo";"A+";"SUPER";"0";"0";"0";"0";"0";
            "0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";"0";
            "0";"0";"";"0";"0";"0";"0";"";"1";"1";"0";"10.9";"Garagenwagen";"Garantie";
            "Vertragshändler";"Weitere Bedingungen"

        
    

Referencing customers (for TSPs)

When you are acting as a transfer service provider (TSP) with an API-Account and upload ads on behalf of various vehicle sellers, then you have to state the mobile.de customer number for every record.

Put it into the customer-number (0/A) field.

Referencing vehicle ads (inventory-key)

For identifying the vehicle ads, put the inventory-key (a.k.a. internal number a.k.a. internal ID) to the internal number (1/B) field.

Referencing images

The naming and the allocation of pictures to listings are organized through the field image id (26/AA) according to the following logic: [imageID]_01.jpg or [imageID]_1.jpg up to [imageID]_15.jpg.

Permissible characters for the field image id (26/AA) are numbers, the characters A to Z, respectively a to z, as well as blanks and hyphens. Underscores are possible but not recommended.

If you want to add new pictures to an ad or change existing pictures, you have to repeatedly transfer the entire data set for this vehicle. Otherwise, already existing pictures that are not resend will be deleted.

Thus, it is possible to delete certain vehicle pictures via an interface transfer. If you want to delete all pictures of an ad, please enter "delete-images" in the field image id (26/AA).

Categories, makes, models

For the fields category (2/C) and make (3/D) there are only certain valid combinations.

First you have to decide for a vehicle class. The list of all possible vehicle classes can be found here:

https://services.mobile.de/refdata/sites/GERMANY/classes

The XML attribute key contains the key of the vehicle class.

Categories

The list of all categories linked to a vehicle class can be found here:

https://services.mobile.de/refdata/sites/GERMANY/classes/__vehicleclass__/categories

__vehicleclass__ is to be replaced by the key of the vehicle class.

Example: https://services.mobile.de/refdata/sites/GERMANY/classes/Car/categories

The XML attribute key now contains the key of vehicle category.

The value to set in category (2/C) is a combination of vehicle class, a period (.) and the vehicle category: __vehicleclass__.__vehiclecategory__

Example: Car.Cabrio

Makes

The list of all makes that are possible with a vehicle class can be found here:

https://services.mobile.de/refdata/sites/GERMANY/classes/__vehicleclass__/makes

__vehicleclass__ is to be replaced by the key of the vehicle class.

Example: https://services.mobile.de/refdata/sites/GERMANY/classes/Car/makes

The XML attribute key now contains the values that can be inserted in the field make (3/D).

Models

For the model detection of cars to work well, it is a good idea to have the text in the field model (4/E) to be started with a valid model key.

Example: A2 1.4 is correctly recognized as model A2 when the Audi brand is specified. The entry Well-maintained A2 1.4 results in the model not being correctly recognized, so that other would be set for the model.

You can find the valid model keys here:

https://services.mobile.de/refdata/sites/GERMANY/classes/Car/makes/__makekey__/models

Replace __makekey__ with the key of the make.

Example: https://services.mobile.de/refdata/sites/GERMANY/classes/Car/makes/AUDI/models

The XML attribute key now contains the values that can be inserted in the field model (4/E)


Impressum / Imprint