This video is a great intro to importing data from excel or copy/paste data from excel into QuickBooks. This works in QuickBooks 2011, 2013, 2014, and 2015.
A full, step-by-step guide of how to do this, can be found on this article
Also, you can checkout other articles about importing data into QuickBooks from Excel or spreadsheets