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


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 . – Ahmad Sarairah Sep 2 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 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) – Ahmad Sarairah Sep 2 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) . – Herb Gu Sep 3 at 9:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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