Update: Moved the code into a gist. (2013-07-05)
I was shocked to realize that Apple’s Numbers app doesn’t properly handle it if you try to paste CSV data in. It seems like such a simple oversight.
Luckily, a little searching online turned up an AppleScript script by Koenig Yvan. I made some tweaks and ended up with this: