This is really aggravating. I’d love to divorce myself from all Microsoft products if possible, but Apple is making it really difficult.
As you probably know, you can paste CSV data from the clipboard directly into an Excel doc and it gives you the option to parse it into separate cells based on the delimiter you choose (most often a comma or tab). This is REALLY very handy, as I usually have CSV data on a webpage that I copy and want to paste into a spreadsheet.
Numbers doesn’t support this almost expected type of behavior. I’m not sure what the authors were thinking, missing this core functionality altogether. Terrible decision on the product team’s behalf.