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?.

my excel file

1 Answer 1


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.

  • i tried to import csv file in weka but i got an error . Sep 2, 2019 at 10:39
  • CSV can have different layouts. For example: "a","b", "a";"b",a,b and even a {tab} b. see if weka has support for different layouts and if not, export as a different kind of CSV from excel.
    – LPChip
    Sep 2, 2019 at 10:44
  • When i tried to save this file with (csv) format to (arff) format using weka i got an error loading file message ( java.io.IOException:6 problem encountered on line :2) Sep 2, 2019 at 11:06
  • Here are some official articles for your reference:mport or export text (.txt or .csv) files; Save a workbook to text format (.txt or .csv) . Sep 3, 2019 at 9:53

You must log in to answer this question.

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