Preparing such export is quite easy, so let’s begin with adding new button in products listing:

in app/code/core/Mage/Adminhtml/Block/Catalog/Product.php in _prepareLayout() function add such code:

then in app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php add new function:

and thats all. You will get new button with export ability.