Convert Excel to CSV

readme.md

Develop Excel to CSV converter with C# .NET

Our comprehensive guide on converting Excel to CSV using C# .NET. Explore the process of converting Excel files to comma delimited files and unleash the full potential of your data processing workflows with ease using GroupDocs.Conversion Cloud SDK for .NET.

For more details, please visit Effortless Excel (XLS, XLSX) to CSV Conversion in C# .NET.

Important Links

Product Page | Docs | Live Demo | API Reference | Code Samples | Source Code | New Releases | Blog | Free Support | Free Trial

Excel to CSV conversion

Learn how to convert XLSX to CSV with .NET REST API

excel-to-csv.cs

// More examples over  https://github.com/groupdocs-conversion-cloud/groupdocs-conversion-cloud-dotnet
// Obtain your API credentials 
string clientId = "4bdefca3-f08c-4088-9ca0-55c38f4b7f22";
string clientSecret1 = "a43c8b4365246a062688a259abe5b469";

// Create an instance of the Configuration class and initialize it with the Client ID & Client Secret. 
var configurations = new GroupDocs.Conversion.Cloud.Sdk.Client.Configuration(clientId, clientSecret1);
// Define the value of ApiBaseUrl to set the base url of the html to PDF converter API.
configuration.ApiBaseUrl = "https://api.groupdocs.cloud";

// Initialize an instance of the ConvertApi class with the object of the Configuration class.
var apiInstance = new GroupDocs.Conversion.Cloud.Sdk.Api.ConvertApi(configurations);
             
// load the input Excel workbook from local drive             
using (var stream = System.IO.File.OpenRead("input.xlsx"))
{
    // create an instnace of FileApi
    var fileUpload = new FileApi(configurations);
    // upload the input XLSX workbook to cloud storage
    fileUpload.UploadFile(new UploadFileRequest("input.xlsx", stream));

    // create ConvertSettings where we define the input excel workbook and name for resultant CSV file
    var settings = new ConvertSettings
    {
        StorageName = "internal",
        FilePath = "input.xlsx",
        Format = "csv",
        OutputPath = "resultant.csv"
    };
    
    // Invoke the ConvertDocument method to programmaticaly convert Excel to CSV format.
    var response = apiInstance.ConvertDocument(new GroupDocs.Conversion.Cloud.Sdk.Model.Requests.ConvertDocumentRequest(settings));
    if (response != null && response.Equals("OK"))
    {
        // print succeess message
        Console.WriteLine("The Excel to CSV conversion completed successfully !");
    }
}