For example, if the phrases are arranged in a column with the translation under each phrase, how do you separate the target language phrases into a separate column? It’s a little trickier than I anticipated, but this can be done with Excel.
I will show you how to select only even rows or select only odd rows in Microsoft Excel, which I will use to take the phrases from the Wikitravel Cantonese phrasebook (I’ve also done this with Korean slang) and separate the translations into a separate column, so you can import the whole thing into Anki as a tab-delimited UTF-8 txt file produced by Excel.
1. Copy and paste the data into Excel
2. Use the “=ISEVEN() or =ISODD() function, combined with a ROW() function that references any cell in that row.” (click here for a tutorial).
3. As per step 2, type =ISEVEN(ROW(A1)) into the cell B1. It will turn to FALSE.
4. Copy the function in cell B1 into all the cells in the column.
5. Turn on the filter by selecting any cell in the column, then clicking the Filter button under Sort & Filter in the Data tab. (Source: techrepublic.com)
6. Next, “Click the new column’s filter dropdown and choose False or True.” (The “dropdown” is the little down-facing arrow in a blue box that should appear in the column.) (Source: techrepublic.com)
10. Open the .txt file in TextEdit, copy it, and save it again as a UTF-8 .txt file (the only kind Anki can read). Ready to import!
What do you think? Please let me know if these directions aren’t clear enough!