Hello all,

I have an Excel document with a taxonomy that I am trying to import into Excel. The worksheet is nicely formated so that each row is a term and each column corresponds to the terms level in the hierarchy (ie, A=level 0, B=level 1, etc). I am looking for an easy way to import this taxonomy into Drupal - it has over 1000 terms, so I don't want to do it by hand if at all possible. I'm sure this is a common issue that people who are converting from other sites (read: non-Drupal sites) to Drupal, so hopefully some of you have some great insights for me.

I really appreciate the help.

Thanks,
DSC

Comments

amariotti’s picture

I'm no professional when it comes to databases, but my first thought would be to go directly to the MySQL database and try to import them directly into your taxonomy term table. That would probably be the best thing to do, and probably pretty straight forward.... just back-up your database first to make sure that nothing bad happens. :)

Stomper’s picture

So Taxonomy CSV import does not support importing via Excel spreadsheet?