How to add categories using mysql

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

Related Posts:

  1. How to create 450 categories in wp
  2. Custom Query to search through categories
  3. How Do I Merge Categories With phpMyAdmin
  4. Disallow categories from this MySQL query
  5. Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
  6. Change the category of all posts in it
  7. How to run select query of post with category and tags for API?
  8. How to get related tags based on a category?
  9. SQL to migrate post types to taxonomy
  10. Drop posts from categories in MySql
  11. WordPress Post # of # filtered by category slug
  12. Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
  13. How to list all categories and their IDs using SQL query?
  14. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  15. WordPress: Using the category slug get the category ID using mysql query
  16. How do I merge WooCommerce categories with the same name?
  17. Bulk Change WordPress category Slug
  18. how to get postmeta info based on multiple categories?
  19. finding out the top 5 source ( source is a custom taxonomy ), in a given category
  20. How to make that all posts with a category belong also to another
  21. Only one category per post
  22. How to get permalinks with category base working with sub-categories
  23. WP 3.9 TinyMCE no longer loads on category description editor
  24. Exclude categories from search query
  25. Why is per_page not working with categories in WP API?
  26. How to order the get_categories result
  27. List posts by category exclude current post
  28. How can I calculate the total number of categories at different hierarchy levels?
  29. How to add a background image to category and display image on category page
  30. Display only deepest category on a single post?
  31. How we add new categories by wp_insert_post
  32. Listing all posts from current category on page
  33. Hide uncategorized products from the shop page
  34. I want exclude the particular category in sidebar
  35. wp_list_categories() – adding a div to each li?
  36. How Can You Exclude Categories From Your RSS Feeds?
  37. Help with multiple dropdown tags search
  38. How to get category URL with the slug?
  39. weekly archive for custom category
  40. ?cat=-1 Indexed Versions Of Homepage
  41. How get permalink for the current category or tag?
  42. using checked function to verify value against an array
  43. wp_list_categories depth and number
  44. Category index featured image
  45. Order categories by most posts
  46. need to add custom field in more products
  47. Sorting category products not working
  48. Show category from “Next post” and “Previous post” [edited]
  49. Custom archive.php: retrieve right post categories?
  50. Add category only if post has custom taxonomy category
  51. How to customize categories panel?
  52. Get posts from 2 different categories
  53. Random Featured Image Based on Category
  54. Failing in_category or has_category in the_content_feed
  55. Display a list of subcategories a post belongs to
  56. Display unused categories in dropdown
  57. Show Pages in Categories
  58. get_posts ignoring ‘category’ and displaying all posts
  59. How to change the thumbnail size to a specific category?
  60. Get paged category link programmatically
  61. Some of the category description not showing up in category page
  62. Function to automatically rename the base category permalink
  63. Add theme-color meta tag to head?
  64. How to get an array with all categories and corresponding names?
  65. Is it possible to have a template that works on multiple categories where the link address contains the specific category?
  66. WordPress Customizer: Dropdown with Category output
  67. Custom tax_query filter not working for Woocommerce product categories
  68. display a link to all the categories of current post, including parents
  69. How do order product categories – on a parent category page – in Woocommerce?
  70. Display only subcategories of a category and not sub-subcategories
  71. Exclude parent category when getting category posts by slug
  72. category link not working for a specific slug, works for others
  73. Shows only one Category in home page
  74. Exclude the category in WordPress
  75. Global navigation in multisite: problem with categories
  76. Placing category specific banner/html at top of respective category pages
  77. How to remove category name for only one category?
  78. Get parent category field from child category [closed]
  79. Can a Woocommerce product category URL contain “&”?
  80. How can I display all products from all categories on one page with woocommerce?
  81. Unable to create pagination for Category.php
  82. Posts says they are uncategorized but they are not
  83. Meta Box: display single image on an archive-template
  84. I just want to list ONLY the child categories, but not grandchildren
  85. Search Replace Database ONLY for posts of certain category?
  86. Categories Help and video uploads
  87. Display only children of custom hierachial taxonomy
  88. Read More showing only on first post
  89. Filtered post assigned to categories
  90. Paginations in Category Page Leads to Sample Pages
  91. Allow a user to ‘subscribe’ to different post categories?
  92. If on Category Page add “active” class?
  93. Show only one category in main query, issues on tag page
  94. Bringing Ajax Loading Feature on Category Pages
  95. single category widget with conditional terms
  96. Remove the current item from a menu
  97. Show category-ID in custom category-list
  98. Dynamically Adding Category Specific Content To Specific Category & Subcategory Pages
  99. Custom EndPoint not working when strip child category in URL
  100. How to add custom prefix before category base for category page URL?