How can I fix wp_insert_comment failure when ‘comment_content” includes slanted apostrophe in Excel csv source data

For the purpose of transferring a very large number of user responses from non-WordPress to WordPress comments, I’ve been given a Google Sheet. Regardless of the method by which I turn the Sheet into a CSV file (direct download as CSV, download as xlsx then save as csv, copy-paste into Excel and save), I get some version of the same problem, though with marginally varying results.