Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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

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

share|improve this answer

Your Answer

 
discard

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.