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”.
1. Select a text file to open from Excel. Import wizard will appear.
2. Specify the kind of delimiters (example, commas separate the words)
3. Set the data format to “text” (otherwise Excel tries to convert number to number format)
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.
Now I have a flashcard I can study with and share with my friends on Mindpasta and my blog.
This entry was posted in Learning
and tagged Excel
. Bookmark the permalink