Bulk upload – how it works

With bulk upload you list many items at once from an Excel sheet instead of one at a time. You fill in one row per item, upload the file under My Items › Bulk upload, and GiBud creates the items for you.

Start from the example file: replace its rows with your own items and leave the headings as they are.

Before you start

  • Bulk upload is for Pro members (Pro and Pro Free), and the account must be approved for selling.
  • Pictures must be online at an address starting with https:// (your own website, a picture service or similar). You cannot point at files on your own computer.
  • The sheet must be named Annonser, the headings must be in row 1 and written exactly as in the example file. The order of the columns does not matter.

How to upload

  1. Fill in one row per item in the example file and save it as .xlsx.
  2. Go to My Items › Bulk upload, press Upload and choose the file.
  3. Press Preview (no changes made). You get a list of the rows that pass and what stops the others. Correct the sheet, save and choose the file again.
  4. Press Import items to add the items unpublished to My Items, or Import & publish to list them right away.

One upload takes at most 100 rows and 300 pictures, and the file must be under 4 MB. If you have more items, split them into several files.

The columns

All 18 columns must be in the sheet, also the ones you leave empty. Write numbers as numbers, not as text.

ColumnWhat you writeRequired
Referanse

Your own name for the row. Shown in the report after the upload.

No
InternReferanse

Your item number. Shown on the invoice, and used to skip rows you have uploaded before.

Recommended
Kategori

The category number from the table at the bottom of this page.

Yes
Auksjonstype

S = auction, X = fixed price/stock, W = spot price for gold and silver.

Yes
SluttTidspunkt

When the auction ends, as a date and time in Excel (for example 22.11.2026 19:00). Must be in the future and at most 21 days ahead.

S only
Utropspris

Starting price for an auction, or the price for fixed price, in NOK.

S and X
KjøpNåPris

Buy now price on an auction. Must be higher than the starting price.

No
Budøkning

Your own bid step in NOK, a whole number. Empty gives GiBud's usual step.

No
Antall

1 for an auction. Quantity in stock for X and W.

Yes
Tittel

The listing's title.

Yes
Beskrivelse

The description, at least 5 characters.

Yes
Bilder

How many pictures the item has, 1 to 26.

Yes
BildeURL

The https address of the picture. With several pictures, write the address without a letter, and the pictures must be named …a.jpg, …b.jpg, …c.jpg (see below).

Yes
Profilert

1 for a highlighted listing (NOK 15 per item). Otherwise empty.

No
Metall

G = gold, S = silver.

W only
Gram

Weight in grams.

W only
Renhet

As a decimal: 0.585 for 585, 0.750 for 750, 0.925 for 925.

W only
ProsentSpot

Share of the spot price: 1 = 100 %, 0.95 = 95 %, 1.1 = 110 %. Empty is 100 %, at most 2.

No

Several pictures per item

With 1 in Bilder, exactly the address in BildeURL is fetched. With 2 or more, that address itself is not fetched, but the same address with a, b, c … before the file ending: BildeURL https://yoursite.com/pictures/1234.jpg and Bilder 3 gives 1234a.jpg, 1234b.jpg and 1234c.jpg.

Three listing types

S – auction

Antall must be 1, and SluttTidspunkt must be filled in. Utropspris is the starting price. KjøpNåPris and Budøkning are optional.

X – fixed price and stock

Utropspris is the price per piece, and Antall is how many you have. The listing stays up until everything is sold. Leave SluttTidspunkt empty.

W – spot price for gold and silver

The price follows the day's gold or silver price, so you do not need Utropspris. Fill in Metall, Gram, Renhet, ProsentSpot and Antall. Renhet must be one of these: gold 375, 500, 585, 667, 750, 833, 875, 917, 958 or 999, silver 400, 500, 600, 625, 640, 720, 800, 830, 875, 900, 925 or 999, written as 0.585 and so on.

When a row is stopped

The preview shows one line per row that does not pass, with the reason. The most common:

Category not found

Use a number from the table at the bottom. Main categories and numbers that do not exist are refused.

Description is too short

Beskrivelse needs at least 5 characters.

Invalid picture count, or the picture link must be a valid https:// address

Bilder must be a number from 1 to 26, and BildeURL must start with https://.

The main picture could not be downloaded from the link

Open the address in your browser. If the picture does not show there, GiBud cannot get it either. With several pictures: check that the address with a before the file ending exists.

Auction quantity must be 1, missing end date or invalid end date

An S row needs Antall 1 and a SluttTidspunkt that is a real date in Excel, in the future and at most 21 days ahead. Do not write the date as text.

Already imported (duplicate)

An item with the same InternReferanse already exists on your account. That is what lets you safely upload the same file twice. If it is a new item, give it a new number.

The spreadsheet could not be read

The sheet must be named Annonser, the headings must be in row 1 and written exactly as in the example file.

Good to know

  • You can upload the same file again without getting duplicates: rows with an InternReferanse that already exists are skipped.
  • Items you import without publishing are in My Items. There you can select several and publish them together.
  • A highlighted listing (Profilert = 1) costs NOK 15 per item and is charged when the item is created.
  • Questions? Write to kundeservice@gibud.no.

All category numbers

Every item needs the number of a subcategory. The main categories (such as Stamps or Coins & Banknotes) cannot be used, just as when you add one item at a time. Press a main category to see the numbers under it, or search. In the example file the column Kategorinavn shows the name of the category whose number you typed.

3423 of 3423 category numbers Press a main category to see the numbers under it.

Collectibles & Antiques210
Stamps1181
Coins & Banknotes910
Books & Music164
Postcards228
Comics & Magazines181
Jewelry, Watches & Optics32
Clothing, Toys & Leisure118
Other Categories399