Asked By
iansilva
0 points
N/A
Posted on - 12/12/2011
Can you please help me regarding .cvs files? If you scroll through it, the error will just pop up that says, "Microsoft Office Excel has encountered a problem and needs to close” and out of the application. My computer system has 2GB RAM with Office 2007 installed on it and some add-ons like Excel Visual Studio Design, Time Adaptor, Access Data Transfer, and TFC Office Shim. This only happens with .cvs files. I don’t want to convert the .cvs files to .xls, Can you please help me on this?
Error running .cvs files in Excel
It seems that the excel program is having a problem reading the .csv files, you will make sure that you are saving the files in the compatibility format. If you need the .csv files converted to the .xls format the follow the procedure below:
First you will need to open the .csv files, but in case they cannot be opened you will need to look for the workbook that has the excel files.
-
Once you have opened the file, click file on the excel menu and then choose save as.
-
Choose other formats from the options.
-
-
In the save as window, give the document a file name to save it with and then choose the .xls format from the list of formats.
-
Choose the location for saving the file and then save it.
You will have converted to the .xls format.
Regards
Thompson Locker
Error running .cvs files in Excel
I think you are referring to CSV and not CVS. “CSV” is the short term for “Comma-Separated Values”. It is a file that contains values in a table that appears as a series of ASCII text lines organized so that every column value is separated by a comma from the next column’s value and every row begins a new line.
A CSV file (.csv) is a method to collect data from any table so that it can be conveyed or transferred as input to another table-oriented application. The Microsoft Office Excel is a leading spreadsheet or relational database application and it can read or open CSV files. If your Microsoft Office Excel cannot open your CSV file, check the contents of the CSV file.
The file is a plain text file and should not contain any special code or binary symbol. Open the file with Microsoft Notepad and check its contents. If you see binary codes in the file or Microsoft Notepad also cannot open the file, your CSV file is probably damaged. If the file is a download, try downloading it again.