I was able to ingest your data successfully using the Add Data Wizard, using the following changes...
In the "Set source type" stage, you should choose CSV from the "Source type" dropdown
Under "Delimited settings", which appears after you choose CSV, you should choose single quote as your quote character.
At the end of the process, you should pick a different source type name, so you don't confuse future, more general CSV users.
Accepting all the other defaults worked for me!
... View more