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 have 2 questions

Question 1.

Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv (Comman delimited) when I was exporting.

I would have thought it would just be .csv?

Question 2

Does anyone have instructions for how to export to csv from (google spreadsheet, excel (2003,2007,2010) and open office)

It would save me alot of time from having to install all this software and making my own tutorial.

share|improve this question
    
Have you tried looking thru Google Docs Support, Microsoft Office Support, and Open Office Support for export instructions? –  dnbrv Jan 30 '12 at 1:31
    
Ya I have, I am looking for ones that have step by step pictures. –  chobo2 Feb 4 '12 at 19:25
1  
Well-written text manuals (such as those) don't need screenshots. –  dnbrv Feb 5 '12 at 3:59

2 Answers 2

A .csv file is just a regular text file with values delimited by commas (therefore the Comma Separated Values). There is no Microsoft version of it (thank gawd), it's just that Excel and most other software likes to add that Microsoft to whereever it appears.

In short ... csv, a plain text file. Nothing special about it.

share|improve this answer

The file is identified as "Microsoft Office Excel Comma Separated Values File (.csv)" because you have Microsoft Excel installed. There is most likely nothing special inside the file to distinguish it from a "normal" CSV file.

share|improve this answer
    
hmm well when I look at the content type when uploading the file as an (HttpPostedFileBase) it is "application/vnd.ms-excel". Is this something else? –  chobo2 Jan 30 '12 at 0:32
    
Note that there are a few different ways in which strings are escaped in csv files, I'm not sure if all of them are compatible. However, the worst case scenario is that some text looses some unctuationp or a row gets a field too much or to little, in which case you would notice and fix the csv manually. –  Eroen Jan 30 '12 at 1:01

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.