I tried the snippet shared by Dan by copying data from Excel and it worked for me. Did you make any changes to the snippet? If yes, please share the snippet here along with an example spreadsheet if possible. Currently, we do not support loading data directly from Excel, but you can do it from a Google Sheets as explained in this post:
If you need further help on this, please let me know.