Libre Office Importing Error

Anki Help
1

Hey folks, need a hand here! Trying to import a CSV file into Anki via LibreOffice, but I’m running into a bit of a snag.

Here’s the lowdown on what I’ve done so far:

  1. I’ve set up my data in two columns.
  2. Saved it as a text CSV file.
  3. However, when I try to import it, I get this message: “This document may contain formatting or content that cannot be saved in the currently selected file format ‘Text CSV’.” It suggests using the default ODF file format, but when I override and select “use text CSV format,” and check “Quote all text fields,” and choose the double quote " as the string delimiter, I hit a roadblock. The error message that pops up is “Error: 500 Invalid CSV.”

I’ve done some testing, and here’s what I’ve found:

  1. No multi-lines or formatting, it went through. I only tried one question and answer.
  2. Multi-lines, it went through with just one question and answer.
  3. Multi-lines with 5 questions and answers, it went through smoothly.
  4. Now, here’s the kicker: No multi-lines, no formatting, but when I try to import my whole file with about 90 questions, I get hit with an error.

I’m stumped. I’ve tried to narrow down the issue:

  1. It works for a minimal dataset.
  2. It even works for a small multi-line dataset.
  3. But when I try to import my entire file with 90 questions, it throws an error.

Any tips or tricks on fixing this? I’m leaning towards using a spreadsheet because it’s more convenient for me. Could there be a limit causing these errors when attempting to import 90 questions? Appreciate any insights! :thinking:

2

Have you tried without the quote all text fields and using tab as field delimiter? Never had any problems with that setup.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.