Export-import file format

[greyboxgt]

Currently CSV files are used for export-import. But CSV does not work very well with Unicode/UTF-8. And commas are often used in the sentences as a comma, not as a delimiter. Is it possible to use a simple text format with a tab delimiter to do the job?

[azizkayumov]

You can open CSV files in PC using Excel(Windows) or Numbers (MacOS), that's why I chose the format. Can I ask to have a look at this guide if you're having format problems with Unicode:
https://www.nextofwindows.com/how-to-display-csv-files-with-unicode-utf-8-encoding-in-excel

[greyboxgt]

Unfortunately, Unicode/UTF-8 import is a bit complicated and the tool does not come automatically with all versions of Microsoft Excel. It seems to be missing in Excel 2003. That is why I had to use native .xls files with Notepad++ text editor to process your .CSV files in a few steps. Is it possible for Flashcard-Maker to understand .xls files directly?

[azizkayumov]

It seems there are some libraries that I can use for this:
https://github.com/andruhon/AndroidReadXLSX
https://github.com/mitchtabian/ImportFromExcel/tree/master/ImportExcelData
They were not updated in last 3-4 years. I think I need to invest some time on this, so I can't fix the issue in coming 3-4 weeks.

[greyboxgt]

Currently, with .csv file format we are very limited with text only, and even Unicode text is not that simple. If you could use a Microsoft Excel spreadsheet or maybe even better Microsoft Word, would it also be possible to draft, import, export and backup the cards with images? And also editing on a desktop computer is much easier. That would be a huge improvement!