Template repeater dataset editor clipboard error

I am trying to copy an excel column (500 rows) into the DataSet Editor for the template repeater and I am getting “Error Pasting DataSet from Clipboard”. IllegalArgumentException: CSV invalid format: expected #NAMES on line 1

It only lets me copy each row one by one. Is there a way to copy all the rows onto the Dataset Editor Table at once?

Yes,but it needs to be in exactly the same format as when you copy the dataset from the dataset editor. And if you didn’t know already, there’re copy and paste dataset buttons

thank you, I was not copying the entire thing from excel and was just using the rows i needed. When I copied it all it worked!