Copy and paste from excel not working

Pretty simple problem that i have never had before. im just attempting to copy from an excel spreadsheet into a dataset but it is not working. Either everything ends up in the same cell or it spreads into 1000’s of others. Thoughts?