Skip to content
VirklyVirkly
Google Sheets

CVR data right
in your spreadsheet

Type =VIRKLY(A2, "name") next to a CVR number and get the company's name, status, address and industry from the Danish business register. You paste a short script into your sheet. There is nothing to install.

Get a free API key

Set up in three minutes

  1. Get a free API key from Virkly. It starts with vkly_live_.

  2. Open your sheet, choose Extensions → Apps Script, and replace the code with the script below. Save, then reload the sheet.

  3. Choose Virkly → Indsæt API-nøgle (paste API key) in the menu and paste your key. Google asks you to authorise the script the first time.

The script

Copy all of it and paste it into Apps Script. It only calls virkly.io. Its messages are in Danish.

Fields

Write the field in Danish or English. Company facts only, never people.

FieldYou get
navnnameThe company's name
statusstatusIn Danish: Aktiv (active), Ophørt (ceased), Konkurs (bankrupt), Opløst (dissolved) or Andet (other)
adresseaddressThe full address on one line
postnrpostcodePostcode
bycityCity
brancheindustryIndustry, as registered in CVR
selskabsformlegal_formLegal form, e.g. Aktieselskab
stiftetfoundedFounding date (YYYY-MM-DD)

Example: =VIRKLY(24256790, "city") gives Bagsværd. If something is wrong, the cell shows a short explanation.

What it costs

A company normally costs one call, however many columns you fill, because the answer is kept for 6 hours. If you fill many cells at once, the first ones may cost a call each. Free gives you 1,000 calls a month and 10 a minute, so take big lists a bit at a time. The API plan gives you 100,000 calls a month for 199 kr. excl. VAT.

Your key

The key is stored in the sheet owner's Google user settings, not in a cell and not in the script's shared properties. Formulas always use the owner's key, so the owner is the one who pastes it in. Anyone with edit access can change the script, and so read the key and use your calls. Only give edit access to people you trust, and create a new key if in doubt.

Ready for your first lookup?

You'll have a free key in under a minute, and the first 1,000 calls every month are free.

Get a free API key

    We value your privacy

    We use essential cookies for authentication (required). We also use Plausible Analytics, which uses no cookies and needs no consent. Only Sentry Session Replay needs your consent. Read more