I want to export some specific posts from my database (csv or sql) and then replace content to these and import them back without changing the id number of the posts.I s this possible to do it and if it is, how?

Thank you in advance.

2 Answers 2


You can use wp all export to export posts, change content. Them import them back with wp all import. Use update existing post option and chose to unique ID to be post title and to update only content field.. So it will find post with same title, it won't change it and just update content.

  • I tried to export and import with the above plugins but my problem seems to be more complicated. The posts I want to change is translations from wpml and many posts have the same name (long story). When I tried to import the secondary language posts, the updates of the content applied to the posts of main language. Do you have any suggestions?
    – Aggz
    Dec 24, 2018 at 12:56
  • Contact wpml if they any suggestions. I know I had same problem with polylang and they have some plugin for multilanguage import.
    – dado
    Jan 3, 2019 at 20:54

The easiest way you can export and importing post content is by using these two plugins:

  1. Export WordPress data to XML/CSV
  2. Import any XML or CSV File to WordPress

You can use the first plugin to export your desired posts from the database. Then use the second plugin to import them back.

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.