excel2moodle 0.6.0

A package for converting questions from a spreadsheet, to valid moodle-xml

excel 2 Moodle

{width=35%}

This Python program helps to create Moodle questions in less time. The idea is to write the questions data into a spreadsheet file, from which the program generates the moodle compliant xml Files. All questions or a selection of questions can be exported into one xml file to be imported into moodle.

Concept

The concept is, to store the different questions into categories of similar types and difficulties of questions, for each of which, a separated sheet in the Spreadsheet document should be created.

A settings sheet contains global settings to be used for all questions and categories. Another sheet stores metadata for the different categories of questions. And each category lives inside a separate sheet inside the spreadsheet document.

Getting Started

Installation

To get started with excel2moodle first have a look at the installation If you already have python and uv installed, it is as easy as running uv tool install excel2moodle.

Documentation

Once excel2moodle is installed you can checkout the example question sheet in the repository.

Some steps are already documented as tutorials you can follow along.

And please have a look into the user Reference of the documentation. That part explains each part of defining a question.

Functionality

• Equation Verification:
  • this tool helps you to validate the correct equation for the parametrized Questions.
• Question Preview:
  • This helps you when selecting the correct questions for the export.
• Export Options:
  • you can export the questions preserving the categories in moodle

Question Types

• Generate multiple Choice Questions:
  • The answers can be pictures or normal text
• Generate Numeric Questions
• Generate parametrized numeric Questions
• Generate parametrized cloze Questions

{width=80%}

Licensing and authorship

excel2moodle is lincensed under the latest GNU GPL license Initial development was made by Richard Lorenz, and later taken over by Jakob Bosse

Supporting

A special thanks goes to the Civil Engineering Departement of the Fachhochschule Potsdam where i was employed as a student associate to work on this project.

If You want to support my work as well, you can by me a coffee

Changelogs

0.6.0 (2025-07-12)

Added variable generator and other architechtural improvements

documentation (1 change)

• Documenting variable generator usage

feature (5 changes)

• Opening spreadsheet file works from within excel2moodle
• Variables are copied to clipboard
• Removed dependence on pyside6-addons
• Var Generator ready
• Merge development of BulletsObj, Parametrization and VarGenerator

improvement (7 changes)

• Adapted Param. Parser to use bullet Obj
• Added bulleList Object
• Parametrics in beta stage
• Refactor parse() method, to construct complete xml-Tree
• Refactored question assembly to only update fields.
• Adapted NFM Question to parametricResult (merge request)
• Implemented ParametricResult Object (merge request)

0.5.2 (2025-06-30)

Extended Documentation and bugfix for import Module

bugfix (2 changes)

• Default question variant saved and reused.
• bugfix: Import module working again

documentation (1 change)

• documentation: Added how to build question database

feature (1 change)

• Implemented MC question string method

improvement (1 change)

• Implemented ClozePart object

0.5.2 (2025-06-30)

Extended Documentation and bugfix for import Module

bugfix (2 changes)

• Default question variant saved and reused.
• bugfix: Import module working again

documentation (1 change)

• documentation: Added how to build question database

feature (1 change)

• Implemented MC question string method

improvement (1 change)

• Implemented ClozePart object

0.5.1 (2025-06-24)

Minor docs improvement and question variant bugfix

bugfix (1 change)

• Bullet points variant didn't get updated

0.5.0 (2025-06-20)

settings handling improved

feature (2 changes)

• Pixmaps and vector graphics scaled to fit in preview
• feature: category Settings implemented

improvement (1 change)

• Tolerance is harmonized by questionData.get()

Settings Errors are logged (1 change)

• Log Errors in settings Sheet