WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel sheet with 423 categories consisting of US States > Military Bases. Is there a way I can reformat the excel sheet and import the categories into the wordpress database?

I know how to use PHPMyAdmin but am unsure how to structure the SQL query.

share|improve this question
Google would be a good place to *start* ..(for research).. – t31os Jul 29 '11 at 13:24

You would want to create an array of those values from your spreadsheet and loop through them to call the wp_insert_category function on each one. http://codex.wordpress.org/Function_Reference/wp_insert_category

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.