How to Convert XLSX to CSV, JSON, XML and more in C#

IronXL can convert any Excel file into various formats.

These formats include: JSON, CSV, XML and even older the Excel format such as XLS.

This brief article will show you how to use IronXL to convert to XML, convert to CSV, convert to JSON and as a bonus, show you how to output an Excel worksheet as a dataset.

C#:

using IronXL;
private void button7_Click(object sender, EventArgs e)
{
    WorkBook workbook = WorkBook.Load("Normal_Excel_File.xlsx");
    workbook.Metadata.Title = "Normal_Excel_File.xlsx";
    workbook.SaveAs("XLS_Export.xls");
    workbook.SaveAs("XLSX_Export.xlsx");
    workbook.SaveAsCsv("CSV_Export.csv");
    workbook.SaveAsJson("JSON_Export.json");
    workbook.SaveAsXml("XML_Export.xml");
    System.Data.DataSet dataSet = workbook.ToDataSet();
    dataGridView1.DataSource = dataSet;
    dataGridView1.DataMember = "Sheet1";
}

VB:

Imports IronXL
Private Sub button7_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim workbook As WorkBook = WorkBook.Load("Normal_Excel_File.xlsx")
    workbook.Metadata.Title = "Normal_Excel_File.xlsx"
    workbook.SaveAs("XLS_Export.xls")
    workbook.SaveAs("XLSX_Export.xlsx")
    workbook.SaveAsCsv("CSV_Export.csv")
    workbook.SaveAsJson("JSON_Export.json")
    workbook.SaveAsXml("XML_Export.xml")
    Dim dataSet As System.Data.DataSet = workbook.ToDataSet()
    dataGridView1.DataSource = dataSet
    dataGridView1.DataMember = "Sheet1"
End Sub

Step 1

1. Install the IronXL Library Free

First, you must have IronXL installed before you can use it in your applications. The following two methods allow you to install IronXL.

Download: https://ironsoftware.com/csharp/excel/docs/

Or use the NuGet Package Manager

Right-click the Solution name in Solution Explorer
Click Manage NuGet Packages
Browse for IronXL.Excel
Install

PM> Install-Package IronPdf

How to Tutorial

2. Convert to XML, JSON, CSV, XLS

Now you are ready.

Add the following code:

C#:

using IronXL;
private void button7_Click(object sender, EventArgs e)
{
    WorkBook workbook = WorkBook.Load("Normal_Excel_File.xlsx");
    workbook.Metadata.Title = "Normal_Excel_File.xlsx";
    workbook.SaveAs("XLS_Export.xls");
    workbook.SaveAs("XLSX_Export.xlsx");
    workbook.SaveAsCsv("CSV_Export.csv");
    workbook.SaveAsJson("JSON_Export.json");
    workbook.SaveAsXml("XML_Export.xml");
    System.Data.DataSet dataSet = workbook.ToDataSet();
    dataGridView1.DataSource = dataSet;
    dataGridView1.DataMember = "Sheet1";
}

VB:

Imports IronXL
Private Sub button7_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim workbook As WorkBook = WorkBook.Load("Normal_Excel_File.xlsx")
    workbook.Metadata.Title = "Normal_Excel_File.xlsx"
    workbook.SaveAs("XLS_Export.xls")
    workbook.SaveAs("XLSX_Export.xlsx")
    workbook.SaveAsCsv("CSV_Export.csv")
    workbook.SaveAsJson("JSON_Export.json")
    workbook.SaveAsXml("XML_Export.xml")
    Dim dataSet As System.Data.DataSet = workbook.ToDataSet()
    dataGridView1.DataSource = dataSet
    dataGridView1.DataMember = "Sheet1"
End Sub

The code above Loads an ordinary XLSX file, adds a Title, then converts to several formats. Lastly it exports the Worksheet as a DataSet that gets used by a DataGridView object.