It’s frustrating—there’s a bug that prevents content from copying and creating options when pasting data into the single select.
Hey @jpca999, What is the field type of the 2nd column in your table?
2nd columns is of single select type.
This explains why you cannot copy and paste this data. You can only paste text into a single-select field if it matches options that are already added. I’ll check with the team to see if we can improve this. 
I works flawlessly on Airtable.
Noted! I’ll discuss it with the team as a new feature request.