Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and paste to convert numerical data to text in a column?

Or, am I going about this all wrong because there's a better way to get all cell data enclosed in quote marks for export to CSV?

share|improve this question
2  
can't you just use optionally enclosed by '"' in the command you use to load the csv? –  m4573r Oct 1 '13 at 11:08
    
Could you select the column, copy it, and then paste it as plaintext to the new column? Then you can select the new column and use that when you export the table. –  Leo King Jul 24 at 20:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.