How to Import Excel into Canvas (QTI 1.2)

Updated September 23, 2026 · 5 min read

Spreadsheets are where most question banks actually live. But the moment you try to move an .xlsx into Canvas, you hit a wall: Canvas does not open Excel files. It speaks QTI 1.2, an XML quiz format. The good news is that you do not need a rigid, pixel-perfect template to bridge the two. If your sheet has one complete question per row, that is enough.

The only rule that matters: one row, one question

You can lay out your columns however you like — question text first or last, options in any order, a points column, an answer column, extra notes off to the side. The single constraint is that every row describes exactly one question, start to finish. As long as that holds, the formatting is free.

Why rows matter more than columns: a row is the natural boundary of a question. Columns can shift around, but a row that bundles the stem, its options, the correct answer, and the score is something a parser can normalize reliably — no matter what you named the headers.

From a flexible sheet to a strict standard

The trick is not forcing your Excel into a custom template. It is letting a tool read your loose layout, normalize it into a standard CSV, and only then compile that CSV into QTI. Two conversions happen, and the first one is the safety net:

Read the workbook

Upload the .xlsx. Each row is treated as one question; columns are mapped to their meaning, not their position.

Normalize to a standard CSV

The tool rewrites your rows into a clean, QTI-friendly CSV: consistent column order, a recognized type code, a 1-based answer key, and properly escaped values. This is the step that prevents broken rows later.

Export QTI 1.2

The standardized CSV compiles into a Canvas-importable .zip (QTI 1.2).

Import into Canvas

In a course, open Quizzes → the three-dot "More options" menu → Import, and choose the downloaded package.

What "normalize" actually fixes

A hand-built spreadsheet almost always drifts from what QTI wants. Normalization closes those gaps automatically:

Column order. Your "answer" column might sit before the options; the standard CSV puts type, points, title, and answer key in a fixed, expected order.
Type codes. Free text like "multiple choice" or "select all" becomes the compact MC / MR markers the exporter expects.
Answer key. However you marked the correct option, it is resolved to a 1-based index over the option cells — first option is 1, and multiple correct answers are grouped. This is the most common source of silent import errors, so standardizing it up front matters.
Escaping. Commas or quotes inside a cell are wrapped correctly so a single question never spills across rows.

Using Excel2canvas

For a spreadsheet-first workflow, Excel2canvas is purpose-built for this. You upload the .xlsx in whatever layout you already use, it normalizes the rows into a standard CSV, and it exports the QTI 1.2 package — no template to fill in first.

Open the tool at examparser.com/en/excel2canvas and upload your sheet; the normalized CSV and the QTI file come back together.

Before you upload: a few practical checks

One question per row. If a question spans two rows, merge it into one before uploading.
Avoid merged cells across the option area. They confuse column mapping; keep each option in its own cell.
Watch the answer index. After normalization, confirm the correct option maps to the right 1-based number — especially for multiple-correct questions.
One sheet at a time. If the workbook has several tabs, upload the question sheet by itself.

Frequently asked questions

My Excel columns are in a different order or have different names. Will it still work?

Yes. Excel2canvas does not require a fixed template. As long as each row carries one complete question, the tool maps your columns to the standard structure during normalization, regardless of their order or headings. Extra columns are ignored rather than breaking the import.

What is QTI 1.2 and why does Canvas require it?

QTI (Question and Test Interoperability) 1.2 is the XML standard Canvas uses to import quizzes. It encodes each item's stem, options, answer key, and points in a package Canvas can rebuild into its quiz bank. Canvas cannot read a raw .xlsx, so a QTI export is the bridge.

How are answer keys represented in the spreadsheet?

Each row is one question, and the correct option is recorded as a 1-based index counting the option cells in order (first option is 1, second is 2). Multiple correct answers are grouped together. During normalization this is converted into the standard answer-key format the QTI export expects.

Can one workbook hold several quizzes or sheets?

Excel2canvas processes the sheet you upload as a single question set. If your workbook has multiple sheets, convert them one at a time, or consolidate the questions into one sheet with one row per question before uploading.

Does the QTI output work with New Quizzes?

The QTI 1.2 export is built for Classic Quizzes. After import, Canvas offers a built-in migration step to move Classic Quizzes into New Quizzes if your institution runs New Quizzes.

Ready to convert your sheet?

Upload the Excel file you already have — no reformatting required — and download a Canvas-ready QTI package.

Try Excel2canvas →