Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email email@example.com.
Very often import solutions require specific format and it is not always the same as your suppliers provides you.
In case you or any other forum users are interested, there is Store Manager for Magento application with built-in import mapping feature. The details and test version is available in the link in my signature.
I also welcome other forum users to share how to use Column Mapper plugin.