Convert XLS to CSV

Files with XLS extension represent Excel Binary File Format. Such files can be created by Microsoft Excel as well as other similar spreadsheet programs such as OpenOffice Calc or Apple Numbers. File saved by Excel are known as Workbook where each workbook can have one or more worksheets. Data is stored and displayed to users in table format in worksheet and can span numeric values, text data, formulas, external data connections, images and charts.

Steps to convert XLS to CSV in C#

GroupDocs.Conversion allows developers to convert the XLS file to CSV format in an easy and intuitive way just using a few lines of code as described below:

  • Create an instance of Converter class and pass source XLS file path as a constructor parameter. You may specify absolute or relative file path as per your requirements.
  • Create an instance of SpreadsheetConvertOptions class and set Format property to GroupDocs.Conversion.FileTypes.SpreadsheetFileType.Csv.
  • Call Converter class Convert method and pass the filename for the converted CSV file and the SpreadsheetConvertOptions object from the previous step as parameters.
// Load the source XLS file
using (var converter = new GroupDocs.Conversion.Converter("sample.xls"))
{
    // Set the convert options for CSV format
   var options = new SpreadsheetConvertOptions { Format = GroupDocs.Conversion.FileTypes.SpreadsheetFileType.Csv };
    // Convert to CSV format
    converter.Convert("converted.csv", options);
}

Code Examples

Please find more use-cases and complete C# sources of our backend and frontend examples and try them for free!

XLS to CSV Live Demo

GroupDocs.Conversion for .NET provides an online XLS to CSV converter, which allows you to try it for free and check conversion quality and accuracy.

“Convert XLS to CSV”