Spreadsheet Import Plus

AnkiWeb addon 716643677

Imports XLSX spreadsheets directly into Anki, auto-matching field names and letting each field be processed as text, HTML, or Markdown.
AI-generated summary; may contain mistakes.

card-creation import

Open on AnkiWeb GitHub Find alternatives

AnkiWeb

Votes: 10 (👍 9 · 👎 1)
Updated: 2022-01-19
Anki versions: 2.1.49~
License: AGPL-3.0 (from the headers of the Python files)
Virus scan: No ClamAV match A match does not prove malware. No match does not prove that the code is safe.
Languages: Python, Julia, JSON
Description language: en

Maintenance

abandoned

Last update or commit: 2022-01-19 (1747 days before the snapshot).
Commits in the last year: 0.
Issues: 3 open, 6 closed.
Pull requests: 0 open, 1 merged.
Median first response: 170 hours (8 answered issues and pull requests).
Outside pull requests: 100% of 1 merged.

GitHub

Repository: helenfoster/ankispreadsheetimportplus · more by helenfoster
Stars: ⭐ 10 · forks 4 · open issues 3
Last commit: 2022-01-19
Languages: Python, Shell
Tests: 0

Will it work on my Anki?

Version branches

Min Anki	Max Anki	Updated
2.1.20	2.1.44	2020-05-11
2.1.45	2.1.49+	2022-01-19

History across monthly snapshots

Loading…

Similar addons

Improved import from spreadsheet via clipboard

Adds cards in bulk by copying a specially formatted spreadsheet to the clipboard, then importing it with specified notetype, deck, fields, and per-card or global tags.

card-creation import

Anki Batch Importer - Excel, CSV, TSV v1.2.0

Batch imports multiple Excel, CSV, TSV and TXT files into Anki, auto-creating filename-based decks and subdecks, with field mapping, configurable duplicate handling, and Excel text color support.

import duplicates deck-management formatting

Anki Excel Sync

Batch exports Anki notes to .xlsx files organized by tag hierarchy and re-imports edits, preserving scheduling while allowing creation, modification, and deletion of cards.

import export note-management tagging

csv to subdeck [depricated use csv import +] archived

Turns pasted CSV into notes by auto-detecting delimiters, suggesting note types, creating subdecks, and importing through quick import or Anki’s standard dialog.

card-creation import deck-management obsolete

CSV Import Plus

Imports CSV or pasted text into Anki with auto-detected delimiters and note types, searchable deck selection, quick imports, subdeck creation, tag handling, and session history browsing or deletion.

card-creation import tagging deck-management

export cards/notes from browser with metadata to csv or xlsx

Exports selected browser cards or notes, including visible columns, field HTML, and metadata such as interval and due dates, to CSV or XLSX, optionally using configurable field sets.

export

Description

Use case * You want to maintain the data for a deck in a spreadsheet (so the canonical version is in the spreadsheet, and the data within Anki is a copy). This could include collaborating on a deck in Google Sheets. * The nature of your data means that Anki's built-in CSV import requires too many steps or is too error-prone. Features * Imports XLSX files directly. * Auto-matches field names. * Allows each field to be configured within the spreadsheet as text, HTML or markdown. Required layout * The target sheet in the workbook must have "SpreadsheetImportPlus v1" in cell A1. * The rest of row 1 must be empty. * Row 2 contains the field names. Name these the same as the field names within Anki to allow auto-matching. The name "_tags" maps to the tags. Anything after the first empty cell will be ignored. * Row 3 contains the field types: "text" means that HTML characters will be escaped (like when using the built-in CSV import without allowing HTML). "html" means the input will be used as-is. "markdown" means the input will be interpreted as Python-flavored Markdown. HTML tags will be preserved. * Row 4 must be empty. * The remaining rows contain the data to import. Any data to the right of the header rows will be ignored. Empty rows will be ignored by Anki's "empty first field" rule. Examples can be found in https://github.com/HelenFoster/AnkiSpreadsheetImportPlus/tree/v0.1.0/test Importing Always backup your collection before installing an addon that modifies it! XLSX files can be imported using Anki's usual import menus. In the import dialog, "Allow HTML in fields" must be checked. The fields can be remapped here, but it would normally make more sense to name them correctly in the spreadsheet. Please post any questions or feedback to: https://github.com/HelenFoster/AnkiSpreadsheetImportPlus/issues Version info Version: 0.2.0 Development repo: https://github.com/HelenFoster/AnkiSpreadsheetImportPlus License: AGPLv3+ ( https://www.gnu.org/licenses/agpl.html ) Includes libraries openpyxl, et_xmlfile, and jdcal.

README

Spreadsheet Import Plus for Anki

Use case

You want to maintain the data for a deck in a spreadsheet (so the canonical version is in the spreadsheet, and the data within Anki is a copy).
The nature of your data means that Anki's built-in CSV import requires too many steps or is too error-prone.

Features

Imports XLSX files directly.
Auto-matches field names.
Allows each field to be configured within the spreadsheet as text, HTML or markdown.

Required layout

The target sheet in the workbook must have "SpreadsheetImportPlus v1" in cell A1.
The rest of row 1 must be empty.
Row 2 contains the field names. Name these the same as the field names within Anki to allow auto-matching. The name "_tags" maps to the tags. Anything after the first empty cell will be ignored.
Row 3 contains the field types:
- "text" means that HTML characters will be escaped (like when using the built-in CSV import without allowing HTML).
- "html" means the input will be used as-is.
- "markdown" means the input will be interpreted as Python-flavored Markdown. HTML tags will be preserved.
Row 4 must be empty.
The remaining rows contain the data to import. Any data to the right of the header rows will be ignored. Empty rows will be ignored by Anki's "empty first field" rule.

Importing

XLSX files can be imported using Anki's usual import menus. In the import dialog, "Allow HTML in fields" must be checked. The fields can be remapped here, but it would normally make more sense to name them correctly in the spreadsheet.

Development

Requires openpyxl, et_xmlfile and jdcal.py in the spreadsheet_import_plus/lib folder. These names are symlinked to a venv which can be set up as follows (on systems where this works and assuming Python 3.7). From the root directory of this repo:

python3 -m venv libs_venv
source libs_venv/bin/activate
pip install "openpyxl==3.0.3"