AUCTORY TOOLS
1 · Deck file
Drop an .apkg deck here
or click to choose — it never leaves your device
.apkg and a bare collection.anki2 are both accepted. The SQLite reader (about 700 KB) is downloaded only after you drop a file, never on page load.
Scope, stated up front: this reads Anki's classic layout — collection.anki2 and uncompressed collection.anki21. Newer exports pack the collection as collection.anki21b with zstd compression and cannot be opened here. Export again with “Support older Anki versions” ticked and it will work.
2 · What to export
Fields are kept exactly as Anki stores them, HTML and all — that is what you want if you plan to import the file back into Anki.
3 · Download
Drop an Anki deck on the left. You will see its note types, its fields and every note on screen before anything is downloaded — this doubles as a plain .apkg viewer.
Working…

APKG to CSV Converter — and CSV Back to a Real Anki Deck (.apkg)

Two directions on one page. Drop an .apkg file and read it: every note type, every field name, every note and tag, exported as CSV or TSV — a proper Anki apkg viewer that also lists the deck's media. Or go the other way and create an Anki deck from a text file: load a CSV, an Excel sheet or paste two columns, pick the front and the back, and download a genuine, openable deck. Free, no sign-up, no watermark, no daily limit — the deck is unzipped, read and rebuilt inside your browser, so it never leaves your device.

How to use

1

Pick a direction: .apkg → CSV to read an existing deck, CSV → .apkg to build one.

2

Reading: choose the note type, the deck and the extra columns, and decide whether to keep the HTML. Building: pick the front and back columns and type a deck name.

3

Check the preview — real field names, real card contents — then download the CSV, the media ZIP or the finished .apkg.

The direction nobody else covers

At least nine sites will turn an .apkg into a CSV for you — converthelper.net, 101convert.com, convert.guru, skoolkool.com and a long tail of clones. Not one of them goes the other way. That is odd, because the reverse is the job people actually have: a teacher with a vocabulary list in Excel, a student with a Quizlet export, a course with a glossary in a Word table. Search for a quizlet to anki converter and the autocomplete finishes your sentence with “not working” and “reddit” — the existing answers are dead links, abandoned scripts and forum threads. This page does the boring, valuable half: it writes the SQLite collection Anki expects, wraps it in the ZIP Anki expects, and hands you a file that opens on a double-click.

What is actually inside an .apkg? A ZIP with two things: collection.anki2, which is a SQLite database, and media, a small JSON map from numbered files in the ZIP to real file names. Inside the database, the single col row carries JSON describing your note types and decks; notes holds the fields, glued together with the 0x1F unit separator; cards holds one row per note per card template. That is why a spreadsheet cannot simply be renamed .apkg — the fields, the sort field, the SHA-1 checksum, the GUIDs, the deck ids and the card rows all have to line up. Building them correctly is the entire job of this tool.

What this tool supports — and what it does not

FAQ

How do I convert an .apkg file to CSV?

Drop the .apkg file on the first tab. The page unzips it, reads the SQLite collection inside, and shows every note with its real field names. Choose whether you want the deck name, the note type and the tags as extra columns, decide whether to keep or strip the HTML, then download CSV or TSV. The CSV is written as UTF-8 with a BOM so Excel opens accented and Turkish characters correctly.

Can I create an Anki deck from a CSV or Excel file?

Yes, and that is the half almost nobody else does. At least nine online converters turn .apkg into CSV; the reverse direction is where teachers actually get stuck. On the second tab you load a CSV or XLSX file — or just paste two columns — pick which column is the front and which is the back, type a deck name, and the page builds a genuine .apkg: a SQLite collection with the col, notes and cards tables, a Basic note type, and one card row per note. Double-click the file and Anki imports it.

Will the .apkg this makes really open in Anki?

That was the whole design goal. The file is built to Anki's classic schema 11 layout: fields separated by the 0x1F unit separator, the sort field and the SHA-1 checksum computed the way Anki computes them, unique GUIDs per note, a card row for every template, and valid models, decks, dconf and conf JSON inside the col row. The ZIP contains collection.anki2 and a media entry, exactly like an Anki export. We deliberately kept the feature list small — a deck that opens beats a deck with extra features that does not.

Why does my deck say it is in a newer format?

Recent Anki versions pack decks as collection.anki21b, compressed with zstd, and this tool reads the classic uncompressed collection.anki2 and collection.anki21 layout only. The fix takes ten seconds: in Anki choose File then Export, pick your deck, tick “Support older Anki versions”, save, and drop that file here instead. We would rather tell you plainly than hand you a broken table.

Can I move a Quizlet set into Anki with this?

Yes. Export your set from Quizlet as text with a delimiter between term and definition, paste it into the Paste box on the second tab or save it as a CSV first, choose the two columns, and download the .apkg. Search for a Quizlet to Anki converter and the top suggestions are “not working” and “reddit” — most of those services are dead links or need an account. This one runs in your browser and never sees your data.

Is my deck uploaded anywhere?

No. The unzipping, the SQLite reading and the deck building all happen inside your browser tab with JavaScript and a WebAssembly build of SQLite. Nothing is sent to a server, there is no account, no watermark and no daily quota.