Formatting data based on string or number - google visualization <p>I have database in PHPMyAdmin, Excel and CSV format (all the same just different formats). To put this data in a table in google visualization numbers are written as they are but string values need to have a ' either side of the text. For example:</p> <pre><code>['MESSI','FC BARCELONA','ARGENTINA',169,67,25,'Left foot','SS',98,99,38,74,9855704866], </code></pre> <p>My database has over 2000 rows so manually doing this isn't an option. Is there a way in any of these formats to make all string variables have the ' either side and all numbers to be written by themselves. The CSV format already splits cells using a comma which I need but it would also be useful if each row started with [ and ended with ] . Anyone know how to do this using any of these formats?</p>