Norwegian version of this page

Link data across multiple de-identified or anonymous Nettskjema forms in Excel

If you have forms that do not store personally identifiable data, that forward to each other, and that have Reference ID in the forms, you can easily link these data together in Excel

Table of contents

Important: This guide assumes that your forms are already configured with forwarding and reference ID so that you can link data across the forms.

Here you can read all about forwarding in Nettskjema. 

Linking responses across forms

To link responses across forms, you must find which response ID (submission ID) from the first form (A) corresponds to the Reference ID in the form to which responses are forwarded (B). One Excel file is generated per form, and these must then be linked together manually.

Screenshot showing Form A at the top and Form B at the bottom. In Form A, response ID 46415323 is marked with a red circle. A red arrow points down to Form B, where the same number 12345678 is marked as Reference ID. The illustration shows that the response ID in Form A should be used as the Reference ID in Form B.

How to find the Excel file for the relevant form

  1. Click My forms
  2. Click Mine
  3. Select the form for which you want to download the Excel file.

  4. Click See results

    Nettskjema interface with a red circle around "View results"

  5. Select Download Excel file (.xlsx)

    Nettskjema interface with a red circle around "Download Excel file"

How to link data across multiple de-identified or anonymous Nettskjema forms in Excel

The data can be linked together in Excel using the columns submission_id and Reference ID. 

Here is an example of what the data may look like in different forms and how the responses from one user are connected.

The image shows the relationship between the columns in different forms

It may be a good idea to rename the columns submission_id and Reference ID to something you recognise for each form, so that it is easier to keep track of the data.

A general description of how you can link data in Excel from multiple files is shown in this video:

 

Søk i veiledningene
 
Kontakt brukerstøtte:

Ring oss

Vi har åpent mellom 08:30 og 17:00 på hverdager,
og mellom 10:00 og 15:00 på lørdager.

Telefonnummer: 22 84 00 04

Send inn sak til oss

Du kan sende inn din forespørsel via e-post til: it-hjelp@uio.no.

Gå til e-post

Book et videomøte over Zoom

Er du student eller ansatt kan du avtale veiledningstime hos UiO Helpdesk over Zoom. Tilgjengelige tider er tirsdag til torsdag mellom 11:00 og 13:00.

Book et videomøte

Chat med oss

Vår chat er bemannet mellom 09:00 og 16:00 på hverdager.

Åpne chat
Did you find what you were looking for?
Published July 23, 2026 1:39 PM - Last modified July 23, 2026 1:40 PM
E-mail this page