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.

The various files exported are shown below.

Figure 1 - CSV File Export

Figure 2 - XML Export

Figure 3 - JSON Export

Figure 4 - XLS Export

Figure 5 - Excel Input for all exports

---