When you open the CSV data in Monarch as a database, you should have the option to indicate that the data is in quote marks and Monarch should remove these for you.
If you open the file as a report, then Monarch will just show you everything that's there.
But you can get rid of them in two ways using a calculated field:
Hope this helps,
Aha - that dialog might be a little ambiguous. Monarch is asking you what qualifiers are used in the CSV file, not what qualifiers you want to see in your table. So if you select , you're telling Monarch to show you everything between the field separators. If you select " as the qualifier, then the data should show up in your table as:
and not as
All the best,