- query
- The search, category or listing URL you submitted, repeated on every row that came from it.
- id
- willhaben’s numeric listing id, as a string of digits. It is also the last segment of
listing_url. - author_title
- Not a seller name. On a dealer listing it repeats the company name. On a private listing it carries willhaben’s seller-type and warranty badges instead - values such as
Privat, Privat, Garantie, Gewährleistung and Gewährleistung, Garantie - and it is sometimes empty. - author_member_since
- Never carried a value in any run we made. The column exists in the header row and arrived empty every time.
- author_location
- The place shown against the seller. In our runs it matched
location. - company_name
- The registered dealer’s company name. Present only on dealer listings - an empty cell means the advert was placed privately.
- company_link
- URL of the dealer’s own page on willhaben - a
/iad/haendler/ path. Fills with the rest of the company block. - company_address_country
- The dealer’s country -
Österreich on the Austrian dealers we saw. Fills with the company block. - company_address_postalName
- The postal town of the dealer’s address. Fills with the company block.
- company_address_street
- Street and number of the dealer’s address. Fills with the company block.
- company_address_municipality
- The dealer’s municipality. Fills with the company block.
- company_address_postCode
- The dealer’s post code. Note the capital C - it is
postCode here and postcode for the listing, and they are different columns. - company_address_state
- Never carried a value in any run we made, including on dealer listings that had a full address otherwise. Use
state for the listing’s province. - company_address_region
- The dealer’s region. Fills with the company block.
- company_address_countryId
- willhaben’s internal country identifier. It came back as the string
-141 - negative, and a string, not a number. - listing_url
- Link to the listing’s own page. This column was called
url before 2026-07-02. - price
- The asking price as a bare string of digits - no thousands separator and no currency symbol.
- title
- The listing headline.
- description
- The listing text.
- images
- All of the photo URLs in one string, joined by a semicolon and a space - not a JSON array, so split on
"; " before you use it. How many arrive depends on the listing. This column was called image, and held a single URL, before 2026-07-02. - phone
- The dealer’s phone number. Fills and empties with the company block.
- currency
- The currency of
price - EUR on the Austrian listings we saw. - location
- The place the item is in.
- postcode
- The listing’s post code.
- state
- The Austrian province, in German - Niederösterreich, Steiermark, Wien, Oberösterreich, Salzburg, Kärnten, Tirol, Burgenland or Vorarlberg.
- condition
- The listing’s condition, in German. In the used-car category we ran it came back as
Gebrauchtwagen, Neuwagen or Unfallwagen. Another category will have another vocabulary. - mileage
- Vehicle mileage as a bare string of digits. Present on car listings; not verified for a non-vehicle listing.
- year
- Vehicle year as a string of digits. Present on car listings, though not on every one; not verified for a non-vehicle listing.
- fuel
- Fuel type, in German - values we saw include
Diesel, Benzin, Elektro, Hybrid Elektro/Benzin and Hybrid Elektro/Diesel. - gearbox
- Transmission, in German -
Automatik or Schaltgetriebe. - position
- 1-based rank within the query, in willhaben’s own order. JSON only - the CSV and XLSX exports stop at thirty columns. It is also the one field that is a real JSON number; every other value is a string.