Export Posts in excel [closed]

If you have direct access to your WordPress database, you could use a tool like PHPMyAdmin or HeidiSQL to query the post and user tables and extract the information you need from the appropriate tables.

I discuss how an SQL query is constructed to get specific categories in Does WordPress Offer A Way to Get only Child Categories?. You can probably construct your own query to get the needed information with some time.

Or, you could take the simple option and install something like Export 2 Excel.

Related Posts:

  1. Using wp_trim_excerpt to get the_excerpt() outside the loop
  2. Remove more or […] text from short post
  3. apply_filters() and the_excerpt are giving unexpected results
  4. How can I create a “Read More” link using the_excerpt() on a static front page?
  5. Compare the_excerpt() to the_content()
  6. Display Links in Excerpts?
  7. Remove Ellipses from Excerpt
  8. Read more tag shows up on EVERY post
  9. Issue with enabling formatting in excerpts in WordPress
  10. limit the words in the post content and add read more link
  11. Custom excerpt length on home page
  12. Excerpt Word Count
  13. How to show only manual / custom excerpts?
  14. Modify Twenty Fourteen Home Page Content Limit & Add Read More Link
  15. “Read more” link doesn’t show up when the post length is under the excerpt length
  16. How do I disable excerpts on blogs and website
  17. Custom excerpt showing first paragraph (with HTML formatting)
  18. Regenerate auto excerpts after updating many posts
  19. can hyperlinks be displayed in excerpts?
  20. Making oEmbed work on the excerpt field
  21. Remove whitespace before the_excerpt();
  22. How to get excerpt correctly formatted
  23. How to display only the excerpt in the blog/posts page with Gutenberg?
  24. Read more on the post page itself
  25. Bulk add tag (or any sort of label) to posts who have custom excerpt
  26. How to correctly limit the content and strip HTML?
  27. Writing a custom excerpt function
  28. Getting first 20 words without excerpt
  29. Show read more link next to last word
  30. the_excerpt – want to modify password protected output
  31. Auto Populate Excerpt Field
  32. excerpt – don’t use main content if empty
  33. Any way to get more space for editing post excerpts
  34. Remove box character after excerpts. Special Character Bug
  35. Where is the logic that defines the excerpt?
  36. Show the excerpt in a loop
  37. Custom Excerpts Per Page
  38. Excerpts automatically remove paragraph space
  39. Gutenberg is Adding Additional HTML Tags When Grabbing the Excerpt
  40. Bug in the_excerpt() function
  41. How to remove first three words from content and display the excerpt
  42. Why is my excerpts not showing if not explicitly declared?
  43. How to get the nivo slider to show excerpt [closed]
  44. Add “Excerpt” in “Quick edit”
  45. get_the_excerpt without images
  46. How to get only manual excerpts?
  47. How to get excerpt of the recent posts
  48. excerpt display same text
  49. Problem with viewing single page correctly. (taken half way down the page on click through)
  50. Limit the size of the post excerpt
  51. excerpt box not visible
  52. I can’t modify the ‘Continue reading…’ link of the_excerpt
  53. get video from content
  54. Show image in excerpt post. Image not displaying
  55. the_excerpt() and tag
  56. the_excerpt is not limiting my post page to 55 words?
  57. I want to show post excerpt and cap it at 20 words [duplicate]
  58. Split the_content into two parts
  59. Use get_the_excerpt is returning nothing outside of loop
  60. Limiting the number of characters in the except
  61. Replacing the ellipsis with three dots
  62. Creating excerpt with simple “Read more” link
  63. How to remove excerpt white spaces
  64. The Excerpt gets page excerpt instead of most recent post excerpt
  65. making the […] clickable
  66. Make only the image an anchor link using the advanced excerpt plugin?
  67. Why archive page can’t show full content?
  68. truncate post with gallery tag
  69. What’s the internal concatenation function for creating Excerpts with WordPress?
  70. Append Second Link to Read More
  71. Twenty Eleven: Home Page, View full post of most recent post & Summary of the rest
  72. “Continue reading” not on some posts, full excerpts not shown
  73. Get the automatic excerpt from a page created with gutenberg
  74. Read More excerpt link on a post is not linking to the post itself
  75. Relia Theme Homepage Articles Excerpt displays the current page excerpt not the posts being pulled
  76. the_excerpt() is not trimming at
  77. How to extract an excerpt from a specific page?
  78. Remove Default Read More Link in Manual Excerpt RSS Feed
  79. How to custom excerpt?
  80. “read more” tag for excerpt() won’t show full content
  81. Keep excerpt from stripping URLs and enable autoembed for youtube ONLY?
  82. Unable to show excerpts
  83. modify text at the bottom of excerpt editor
  84. excerpt button not going to custom post page
  85. NextGen Gallery not allowing me to display the_excerpt();?
  86. Excerpt preview
  87. Manual excerpt being ignored on custom post type
  88. Remove “[ ]” from excerpt in highlight search term
  89. Excerpt filter is adding ” in incorrect place
  90. 2 posts same excerpt?
  91. How to display page excerpt with readmore link inside an enhanced widget?
  92. Excerpt is only getting shown for first post
  93. Implementing a blog excerpt in custom theme
  94. Get the excerpt of post_content
  95. Post content not showing
  96. Excerpt length and alignment [duplicate]
  97. Remove automatic excerpts only for single posts
  98. Setting post excerpt length in php wordpress code, Should will help to save DB size?
  99. Remove the excerpt and “… Read More” from the featured content on the home page with child theme
  100. Is there a way to display the ‘Read more’ link if it’s within a range?
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedusedusedusedueduseduedusedusedu