CSV Import in Atomic Assessments

Atomic Assessments allows you to upload CSV files containing question data into the Content Manager. This feature enables batch creation of questions for use in assessments.

Atomic Assessments allows you to upload CSV files containing question data into the Content Manager. This feature enables batch creation of questions for use in assessments. More information can be found here.

How to Upload a CSV File

Navigate to Atomic Assessments and go to the Content Manager tab.
Click the three-dot menu and select Add Content.
Click Select File and choose your CSV file.
Click Upload File to start the import process.
Once the import is complete, navigate to the Items tab to find the newly added questions.

Overwriting Existing Questions

If the Question ID column is set in your CSV file, subsequent imports with the same Question ID will overwrite the existing question in that course. This prevents duplication of questions when the same content is imported multiple times.

When you import a CSV, we generate a unique item reference using the Question ID, course context, and other info. If you import the same question into the same course again, it updates the existing item because the reference stays the same.

Item references can't be changed without breaking links to activities and sessions, so we can't retroactively update them to match new imports.

However, we do store the original Question ID in the item's "Source" field. You can view it there—though editing it won’t affect anything.

Handling Missing Data

Columns that are not included in your CSV file will be skipped during import, but will not prevent the file from being uploaded. Any missing data will not be included in the uploaded questions.

CSV Format and Column Definitions

The CSV file must follow a specific format and needs to be encoded for UTF-8. The only required columns are Question Text, Option A, Option B, and Correct Answer.

Example CSV Data

Question ID	Title	Question Text	Question Type	Option A	Option B	Option C	Correct Answer	Points
101	Sample Question 1	What is 2 + 2?	Multiple choice	3	4	5	B	1

Supported CSV Columns

Column Name	Description	Required	Example
Question ID	External question ID. If omitted, a random ID is generated.	No	101
Title	Item title.	No	Question 1
Question Text	Question stem.	Yes	What is 2 + 2?
Question Type	Currently supports "Multiple choice".	No	Multiple choice
Template	Question type template: - Standard - Block layout - Multiple response - Block layout multiple response - Choice matrix - Choice matrix inline - Choice matrix labels Default: "Standard"	No	Standard
Correct Answer	Correct response (e.g., "A"). For multiple response questions, use a semicolon separator (e.g., "A;C;D").	Yes	B
Points	Question points. Default: 1.	No	2
Option A	Text for option A.	Yes	3
Option B	Text for option B.	Yes	4
Option C	Text for option C.	No	5
Option [D-O]	Text for additional options.	No	6
Option A Feedback	Feedback for option A.	No	Incorrect.
Option B Feedback	Feedback for option B.	No	Correct!
Scoring Type	Learnosity scoring type: - Partial Match Per Response- Partial Match- Exact Match Default: "Partial Match Per Response"	No	Exact Match
Shuffle Options	Whether to shuffle answers ("Yes" or "No"). Default: "No".	No	Yes
General Feedback	General feedback.	No	Great job!
Correct Feedback	Feedback for correct responses.	No	You got it!
Incorrect Feedback	Feedback for incorrect responses.	No	Try again.
Distractor Rationale	Explanation for incorrect choices.	No	Option C is a common misconception.
Stimulus Review	Review-only stimulus.	No	Background information
Acknowledgements	Acknowledgements.	No	Source: XYZ
Instructor Stimulus	Instructor-only stimulus.	No	Teaching note
Sample Answer	Example response.	No	4
Description	Item description.	No	Basic math question
Tag: tag_type	Tags for categorization. This column can be repeated with different tag types.	No	Math
Alignment URL	URL for standard alignment tags. Can be repeated. If this is a path it’s converted to a URL internally.	No	"https://example.com/standards/math" OR “/standards/math”