CSV adding double quotes to one column

[Bluetonic]

Dear all,

Apologies if this is the wrong place to post this query, but I am currently at my wits end trying to solve an issue within excel.

I've had to generate 1000 entries with a php script of users with their details and their passwords in the form of a hash (MD5). I need to save the excel document as a CSV file to get the commas between columns. Each field has the single quotes needed for an SQL query. However, the hash column which is the last in the table saves in CSV with double quotations around the single quotes and as you can imagine, this doesn't wash with SQL. I have no idea what is causing it or how to remove them being a novice in excel. I would massively appreciate any help anyone could provide.

(1 'guest' 'Chung Kristina H.' '895547922' '1' '52e411e104fc396f487c1d0688118c55'),

(these are dummy names and passwords by the way, this is a university project). The formatting above is correct other than when saved into the CSV file and opened in a text editor (which I need to do) double quotes appear around the last column. I don't know what to do?

[Keebellah]

Hi, welcome to the forum
How are you inserting the single quotes?

[Bluetonic]

Hi, welcome to the forum
How are you inserting the single quotes?

Hi, thank you

I inserted the single quotes from a PHP script. I had to manually add the single quotes in the script for the 1000 hashes so that SQL would understand the syntax. I then opened the plain text of that script result in excel. It looks right in excel, each column has the single quotes. For whatever reason, when I save as a CSV (Which I need to open in plain text to paste into SQL) it adds double quotes around the single quotes for the hash/password column. I really don't get it lol.

[Keebellah]

That's Excel for you, you do NOT open text files in Excel but use Notepad or similar instead, check it there