For a while now I’ve tried to find a tool that would allow me to export a SharePoint 2007 list to Excel, modify the data and then import it to another system. In my case I wanted to move data between our many testing environments and modify it easily and in bulk.
Having failed to find a good solution for this I’ve created a tool. It’s published on GitHub and named SharePoint listitem manager. The current version is v0.11 which does the basics (export and import), but I hope to expand and improve the tool as time goes.
At the moment I don’t provide any binaries to download. Feel free to clone the repo and build the solution yourself. The tool is totally untested so I don’t want to release it as a binary quite yet.