I’m trying to manage my cloze cards externally in a spreadsheet, so I can update notes and then re-import them back into Anki. With standard front-back type cards, I used the front field as a unique ID, and on import I could match existing notes using that UID to update them cleanly - no duplicates, just updates.
But with cloze cards, there’s no “Front” field because everything goes into the single cloze field. That means I don’t have a simple way to define a unique ID per card for update purposes.
Is there a way to import without creating duplicates, and without manually setting the GUID for each card in the spreadsheet?
Edit:
When I update my cloze cards using a spreadsheet, Anki ends up creating duplicates.
As a possible solution, I was wondering: could I use a separate “Front” field as a UID, while keeping the cloze text itself in the “Text” field? Would this prevent duplicates and allow for clean updates?
Edit 2:
After further testing, I created a separate field to hold a unique question ID, distinct from the cloze text itself, and used that field as the UID during import.
This approach worked perfectly. Anki updated the existing cards without creating duplicates, just like with regular front-back cards.
I feel a bit foolish for overcomplicating it and apologize for any confusion.
Thanks for bearing with me.