CODEWITHSUNDEEP
wordpresselementor
Mitch Greene
Mitch Greene

Reputation: 123

A way to import only certain Blogger posts to Wordpress

I would like to import a client's posts from Blogger to Wordpress

I have searched for blog posts, plugins, and scripts that do what I need, and have not been able to find what I am looking for. A question from 2016 asks the same thing, but the solution offered is to upload all posts and delete the ones you don't want. I would like to try to avoid having to delete 600+ posts manually. Has anyone found a solution for this issue?

Edit:

Requirements from client:

She has compiled a spreadsheet in Google Docs of posts that she would like to keep that has the Original Blogger Title, Original Blogger Post Date, What will be the new category, and what will be the new tags. This is the only way I know which posts she would like to bring over. So far I have been using process of elimination and deleting posts one-by-one.

Things I've tried:

The default Blogger importer froze. So I've tried to use Blogger Importer Extended, but I'm not sure what's extended about it, because it does the same as the default importer, indiscriminately importing everything.

Update:

Reporting back. I cannot get a Blogger XML export to open in Excel to be converted to .csv. I tried then exporting the Wordpress posts as XML to convert to CSV also. However, both times I tried this with different methods, I got the same error from Excel:

Excel Error Message regarding XML formatting

So I now need to know how to convert whichever XML format that Blogger/Wordpress use to .csv so it can be compared/contrasted to the list I have received from the client. Will report back later.

Update2:

Was able to convert to csv using the online service proposed below, however the output is seemingly useless, unless I'm missing something. The output appears as below:

enter image description here

Upvotes: 0

Views: 402

Answers (1)

Rajue S
Rajue S

Reputation: 26

Note the default WP Importer have issues when you import XML filtered to a particular author. For this type of task, CSV Import/Export plugin will be useful. Also, you must install the WP export add-on for export option and use the filter options like "Export data by specific Author" or "Specific Period" checked as in this image https://ps.w.org/wp-ultimate-exporter/trunk/screenshot-2.png?rev=2134132. Now you can export the CSV of blog posts filtered for particular Author or Date range. You can use this CSV now to import again.

Upvotes: 1

Related Questions