This page is intended to show how to take a WordPress XML file of posts, edit some sections and then re-save so it can be imported back into WordPress.
XML files can be opened with MS Excel, but can they be saved in the same original format?
I am using the MS Excel Starter that comes with Windows 7, and this will open the file, but has no option to re-save as a: “*.xml” file.
Hmmm…. not getting anywhere yet… I have seen complex ways, but I want an easy one 😉
Sites that I have looked at:
- http://www.jkp-ads.com/articles/xmlandexcel05.asp
- http://office.microsoft.com/en-gb/starter-help/file-formats-that-are-supported-in-excel-starter-HP010387887.aspx
- http://social.technet.microsoft.com/Forums/en-US/excel/thread/6970f2c3-74b0-4a22-ae15-e43935a9e32d
- http://wordpress.org/extend/plugins/xml-editor
- http://forums.phpfreaks.com/topic/268169-php-update-xml-file-re-save-as-xml-file
- http://en.blog.wordpress.com/2006/06/12/xml-import-export/
55.1 - 876,666
↓ Scroll down for Comments ↓