I ran into a problem the other day while trying to upload an excel csv file into my MYSQL table.
With the php list function only one delimiter can be specified. If you were to upload an Excel csv file using list and the delimiter specified is the comma, then any field in Excel that contains embedded commas (i.e., 2,500 or oranges, apples, and grapes) would be surrounded by quotation marks.
This presents the problem that the resulting uploaded string containing the quotes will also be inserted into the MYSQL table element with the quotes too.
I've attached a crude tool (C program) that facilitates the upload of an Excel csv file to your MYSQL table. Also, I could have incorporated the C code from the program into the php processing script but that was an after thought.
Anyway...the Parseme.exe replaces all commas with a semicolon with the exception of embedded commas that are surrounded by quotes. It then removes the quotes in each field that are surrounded by quotes. The readme describes how to use the executable.
Last, I've included the code from the exe so that can you play around with it, tear it apart, or modify the script.
Have fun.
