1

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.

3

2 Answers 2

5

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.

3

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.

2
  • 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, 2012 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, 2012 at 1:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .