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
1  
can't you just use optionally enclosed by '"' in the command you use to load the csv? –  m4573r Oct 1 '13 at 11:08
add comment

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.