Sounds to me like copying data from Excel for Mac is inserting an extra carriage return/form feed character. What happens if you paste into TextEdit first, then copy from there and paste into the transaction?