Excel – How to save excel file in csv format

microsoft excel

I am using excel 2013, and I want to save an excel file with(.xlsx) format to (csv) format without any problem, because i want to use this file in weka program, but when I tried to save it in this format I got a problem (some features in your workbook might be lost if you save it as comma separated values (.csv)) .

The file image is attached below, but how i can attach the file in my question?.

Best Answer

CSV files is a text format. CSV stands for Comma Separated Values.

An Excel file (XLSX) is far more than just a string of texts, separated by commas. It has information about fonts, colors, and other things like borders and how big a cell is.

It is logical that when you save a file as CSV, you will lose everything the CSV does not support. There is no other way around it, but is almost always good enough.

See if the created CSV file can be imported in your Weka program, I bet it can.

Related Solutions

Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format

This is a common problem all Excel users suffer. I think, the only way to do that is to use a macro. For example:

Application.DisplayAlerts = False
With ThisWorkbook
    .SaveAs Left(.FullName, Len(.FullName) - 3) & "csv", xlCSV
End With
Application.DisplayAlerts = True

Windows – What’s the difference between – CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)

The difference between [them] is if you have certain special characters in text fields; for example, an accented (foreign language) character. If you export as Windows CSV, those fields are encoded using the Windows-1252 code page. DOS encoding usually uses code page 437, which maps characters used in old pre-Windows PCs. If you export as one and then import with a tool that expects the other, most things will look fine but you'll get unexpected results if, for example, you know someone with an umlaut (or other foreign character) in their name.

source

Best Answer

Related Solutions

Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format

Windows – What’s the difference between – CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)

Related Question