Importing Text file to Excel then Memrise finally Flashcards

Here is just a quick example of importing a text file to Excel.  In this case, I was importing the vocabulary for “The Giving Tree”.

With Excel, open a text file

1. Select a text file to open from Excel. Import wizard will appear.

Import wizard will ask about how to import text

2. Specify the kind of delimiters (example, commas separate the words)

"text" or "general" format

3. Set the data format to “text” (otherwise Excel tries to convert number to number format)

Word list imported

4. Imported file will look like this. Check carefully, as importing is not perfect.

I will often import data to Excel for manipulating.  This is helpful if the data format I have does not list the Korean word as the first column.  “Bulk Add” under advanced options is much faster than creating the flashcards one at a time.

bulk_add_Memrisebulk_add_Memrise2

Memrise_add_memMemrise_add_mem2flashcard sitMemrise_GivingTree

Now I have a flashcard I can study with and share with my friends on Mindpasta and my blog.Flashcards on Hanguk Babble Homepage fgallery2

Flashcards on Hanguk Babble

flashcard_mindpasta

Advertisements
This entry was posted in Learning, Tech and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s