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.

  • Google would be a good place to *start* ..(for research)..
    – t31os
    Jul 29, 2011 at 13:24

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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