I recently found a fantastic plugin which has really saved my ass.
WP All Import – does exactly what it says: It will import anything from anywhere.
Example: you’re starting a new business and have all your data in a spreadsheet. The columns are all your own design and doesn’t fit an industry standard – you literally add whatever you want when you want it.
WP All Import will import it.
You’ll need to upgrade to the Standard Pro version to import from Google Spreadsheets, which I highly recommend as you’ll be able to have one file online which anyone can update and run again and again via the plugin and keep your detailed content updated. Brilliant and worth every penny.
Note: they aren’t paying me to promote it! It’s just the perfect SYA plugin if you have a lot of data to import.
*SYA = Save Your Ass