Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 '14 at 20:22

Your Answer


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

Browse other questions tagged or ask your own question.