We have a lot of chemistry MCQs in an excel file with lot of chemistry formulas and equations. When we tried to import these MCQs into mySQL based database all subscripts used in formulas lost and taken as normal character e.g, H2SO4, CO2, CH3 etc and makes our formulas and elements name nonsense. We need any solution by which mySQL can import subscript and superscript as it is from excel Or any solution by which we can force excel to consider subscript and superscript as inserted symbols because mySQL can pick symbols as it is.
Our exam application made by PHP and mySQL and we need permanent solution for it e.g, method, utility etc. A sample file with chemistry formula with sub and super script is attached.