Excel Windows CSV Does Not Work - Documented Work Around

This is an extremely useful mod. However the import via Excel Windows option does not work. There is a simple work around.

1. Create your Taxonomy in Excel
2. Save ad a CSV
3. Open in Notepad
4. Save As a new document
5. Import into a vocabulary with the "Igonore" option

Also here are some tips on how best to import Parent and Child terms as well as descriptions and synonyms. This takes 2 csv imports but works really well.

First You need to get your parent and child taxonomy in order for your first import:
It will look something like this:
Parent Term 1, Child Term 1
Parent Term 2, Child Term 2
Parent Term 1, Child Term 3

Import this via the directions above.

Then set up a second Excel sheet for descriptions and synonyms:
Parent Term 1, PT1 description, synonym
Parent Term 2, PT2 description, synonym
Child Term 1, CT1 description, synonym
Child Term 2, CT2 description, synonym, synonym 2
Child Term 3, CT3 description, synonym

Thats it, hope it helps