Not sure I really do understand your problem but I've written a macro for importing csv files to excel.
Some warnings i.e. in the code I've hard coded a path to the csv file.
This you have to change to suit your needs. The macro then asks for the file name and you have to add the full file name i.e deviceReport-2017-01-14 16-58-45.csv
The file is then imported to cell A1 and the part "C~" is stripped from the temp column transferring the values to number. As for the pH value I'm not sure you will get these as numbers. My problem is that the Scandinavian delimiter for number is the "," whereas you seems to use "." so when I import the file I get the dots as it is in the csv fil. Normally a multiplication by 1 is sufficient to convert a number text string to value. This can be added to the macro if you don't get the pH value as a number.
There is also a possibility of letting the macro open the file browser where the csv files are stored so you should only have to click on a file to select it instead of writing the file name in the input box.
Alf
Bookmarks