---
title: "013_Importing CBT results to  Grade Center in clickUp step sheet"
slug: "013-import-external-marks"
tags: ["excel", "import grades"]
updated: 2024-09-19T05:22:13Z
published: 2024-09-19T05:22:13Z
canonical: "clickup-help.up.ac.za/013-import-external-marks"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://clickup-help.up.ac.za/llms.txt
> Use this file to discover all available pages before exploring further.

# Import external results

## **Background**

Sometimes you might receive marks from other assessment tools, e.g. the mark reader.

The purpose of this page is to explain how you should change the spreadsheet with your results to import them successfully into the clickUP Gradebook.

***Tip:***When working with the Gradebook, always start by downloading the Gradebook to Excel. This will serve as a backup of your Gradebook.

## Steps

**Scenario**: you received grades from the mark readers. Let's refer to this as Document 1.

Follow the steps below to import results from external sources.

### 1. Save Document 1 (the results file) in .csv format

- Upon receiving your results file, click on **File**, **Save As**.
- Type in your file name, e.g **clickUP list**
- Go to the **Save as type**dropdown menu and select the format: **CSV (Comma delimited)(*.csv)**
- Click on **Save**

![import1](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import1.PNG)

### 2. Edit the Document1.csv file

The results could be in the following format:

![import2](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import2.PNG)

Delete all the non-required information:

- header row
- the following columns: **Surname**, **Name**, either **Score**or **Percentage**(this is dependent on the specific column you want upload) and **Maximum Score.**
- any bottom rows, e.g. rows that contain the **Class average**and **Number of students**.

The only columns that should remain are **Username**and **Score/Percentage**(depending on which one you want to upload):

![import3](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import3.PNG)

### 3. [Create a gradable item](/v1/docs/written-assessments)

### 4. [Download the column information](/v1/docs/work-offline-with-grades#download-the-gradebook)

Let's refer to this Excel document as Document 2.

### 5. Edit Document1 in Excel

- Open Document 2 (downloaded in step 4).
- Copy the exact column heading you have just created (e.g. **Test Results [Total Pts: 100] |631672**).

![import4](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import4.PNG)

- In Document 1, paste and replace the column heading **Percentage/Score**with the heading you have just copied from the Gradebook Excel sheet:

![import5](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import5.PNG)

### 6. Save Document 1 in .CSV format

- Ensure the results file is saved in the **CSV (Comma delimited)(*.csv)**format
- Click on **Save**

![import6](https://cdn.document360.io/8ea693b1-555d-4973-acf4-f29e9965c563/Images/Documentation/import6.PNG)

**NB! You are now ready to import your marks into clickUP.**

### 7. [Upload Document1.csv to the Gradebook](/v1/docs/work-offline-with-grades#upload-grades-to-the-gradebook)