Skip to content

Learn Ejerblik · Lesson 2 of 6

The person keeping the register

Import assets from Excel or CSV

If you already have a list of the company's systems in a spreadsheet, you can import it. Ejerblik matches each row against the library, shows you the result before anything is saved, and tells you afterwards what was imported.

  • About 2 min read
Six places to look
  • Domain checkTraces in your domain: email, hosting and tools
  • Connected appsApps that sign in with Microsoft or Google
  • Account scannerRegular payments on the bank statement
  • Ask your colleaguesThe systems your colleagues use
  • Forward receiptsReceipts and welcome emails
  • Paste a listChart of accounts, authorisations and saved logins

Everything the sources find arrives as a suggestion. Nothing goes into the register until you say yes.

Getting started

Go to Assets and click "Import from Excel". The file can be .xlsx or .csv and up to 10 MB. "Download the Excel template (.xlsx)" gives you a template with the right columns and a sheet of valid categories.

Only the Owner and Editors without a department restriction can import.

The columns

Only the name is required. The rest is optional: Platform, Category ID, Risk (Low, Medium or High), Status, Owner, Responsible, Admin email, 2FA and Login doc. (Ja or Nej, as in the template), Renewal date (YYYY-MM-DD), Notice period, Monthly cost (DKK), Period, Vendor and Notes.

The Owner column becomes the Legal owner on the asset. Price and period from the import are the basis for the contract overview in the report.

Matching against the library

Click "Analyse the file →". Each row gets a label: Recognised (a direct match, category and risk set), Partial match (check the category), AI suggestion, or New (created from scratch).

Names the library does not know are sent to an AI model to find a possible match. If an AI suggestion is wrong, click it to reject it.

The import

Click "Import ... assets →". Afterwards you see how many were imported and skipped, and which rows failed and why.

"See the imported assets →" takes you to the list, where you fill in the rest on each asset.

Limits and duplicates

The import respects your plan's limit on the number of assets. Rows beyond the limit are skipped and appear in the error list.

Ejerblik does not check for duplicates. If you import the same file twice, the assets are created twice, so look through the list afterwards.

Try it yourself

The demo shows a fictional company with assets, employees and deadlines. You can look at everything and break nothing.

The Ejerblik dashboard with the getting-started list, on laptop and phone