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 firstname.lastname@example.org.
How do I get my product file into Magento (tearing hair out)
You need to put a few products in manually (just like 2 or 3) and then do an export so that you can see the correct format—however you should make sure the first collum called store is set to default. Also you will need to put a / infront of all of your image file names.
I am doing this right now and I have gotten everything to import, but I am getting a php error with the images. I am going to try modifying the php code as suggested elsewhere in this forum (http://www.magentocommerce.com/boards/viewthread/5120/) to fix that problem.