Making flashcards with 3 column spreadsheet?

[hsiazaam]

Hey all! 

Alrighty, so I have a spreadsheet full of all the characters and words that I have learned so far from all my classes, and I'd really like to turn them into flashcards to study from. There are a lot of sites and such out there about making flashcards from a spreadsheet, but they use only two columns. I've got three. One with characters, pinyin, and english definition. I'd like to have the characters on one side, with the pinyin on the back and the English below that. I originally thought I'd be able to find a quick solution to this, but I've been unable. I don't know if it's just because I haven't searched for the right stuff?

 

I've already got a lot of words in the list, so I'd really NOT like to have to edit that, or to make them from scratch. If any of you know something that could help me, I'd REALLY appreciate it!

 

Thanks~! 

 

Also, if it's relevant, I've only got access to Open Office and iCloud Numbers Beta because cheap.

[Johnny20270]

have you tried ANKI? You can use as many columns as you want on that. I use about 8 columns. Its a good piece of software
 
I use a spreadsheet as the origin of all my data, just update it and import it into ANKI. Open Office is easier than excel as you must import in CSV (UTF-8 encoding) which open office does perfectly. Excel can do it but just a extra step or two
 
So my C->E flash cards looks like this in (HSK.jpg) and my E->C looks like this (Words.jpg)
 
you can see the fields used in the ANKI template and they correspond to what I wrote in this link ....
 
http://www.chinese-forums.com/index.php?/topic/45571-30-a-day-retaining-vocabulary/?p=343429