Importing Excel Files into Pleco

[mikeylee]

I am trying to add all TOCFL words not in HSK into Anki, by first importing the excel file with them into Pleco, then delete all duplicates (I already have the HSK flashcards), then exporting the Pleco flashcards into Anki (and if possible, have them sorted into the different levels). How would I do this? Thanks.

Here is the link to it: https://docs.google.com/file/d/0B8fwxqt6F-kaVGpXVzk2Z2tubkE/edit

 

[Shun]

Hi Mikey,

you could work with these instructions:

http://spreadsheetpro.net/comparing-two-columns-unique-values/

Before you do that, you could combine the Hanzi and pinyin in a new column for both the HSK and TOCFL and then use the above instructions on those. The TOCFL levels need to be encoded in a column, as well, so they don't get lost.

Hope this helps. If you need more help, perhaps read all the manuals first and then come back with questions? Or I could do it all for you if you pay me a set amount.

Cheers,

Shun

 

[HW60]

@mikeylee: if you google "duplicates siteleco.com/anmanual/" you will find how to skip duplicates when importing flashcards (the red face stands for ":" and "p" - I have no idea why and what the forum software does with these 2 characters)

 

[Shun]

HW60's solution is much easier, of course! No need for Excel.