C# Export to Excel: Step by Step Tutorial
Published: 2022-02-01 07:32:13

---
canonical_url: https://ironsoftware.com/csharp/excel/docs/questions/c-sharp-export-to-excel/
---

It is necessary to work with different formats of Excel spreadsheets and use C Sharp Export to Excel functionalities. Projects may need to use spreadsheet data in specific formats, including `.xml`, `.csv`, `.xls`, `.xlsx` , and `.json`. In this tutorial, we will learn how to export Excel spreadsheet data into different formats using #.

## How to Export Specific Excel File Formats in C#

1. Download the C# Library to Export Excel files
2. Write extension name while importing or exporting files
3. Export an Excel file using the .xls extension
4. Export .xlsx or .xls file to a .csv
5. Export .xslx file data into .XML
6. Export .xlsx file data into .JSON

---

**Step 1**

## 1. Get the IronXL Library

For an easy way to work with Excel files in .NET Core, try IronXL. [Download IronXL DLL](https://ironsoftware.com/csharp/excel/packages/IronXL.Package.For.export.excel.zip) or [install with NuGet](https://www.nuget.org/packages/IronXL.Excel) for free use in development projects.

`PM > Install-Package IronXL.Excel`

Download and add its reference in your project. `IronXL` classes can be accessed using `IronXL` namespace.

---

**How to Tutorial**

## 1. Export to Excel in C#

IronXL provides the most accessible way to export the data to Excel with ( `.xls`, `.xlsx` and `.csv`) files in .NET applications. It is also possible to export the data to `.json` and `.xml` files. Let's see one by one how easy it can be to export Excel file data into these formats.

---

## 2. C# Export to .XLSX File

It is very easy to export an Excel file with an `.xlsx` extension. Let's see the example. In the code below, our `XlsFile.xls` file exists in `bin>Debug` folder of the project.

Remember: Don't forget to write extension with file name while importing or exporting.

By default, new Excel files will be created in the `bin>Debug` folder of the project. If we want to create a new file in a custom path then we can use `wb.SaveAs(@"E:\IronXL\NewXlsxFile.xlsx");`. Read the tutorial here to learn more about how to export Excel files in .NET.

**C#:**
```
using IronXL;
static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("XlsFile.xls");//Import .xls, .csv, or .tsv file
    wb.SaveAs("NewXlsxFile.xlsx");//Export as .xlsx file
}
```

**VB:**
```
Imports IronXL
Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("XlsFile.xls") 'Import .xls, .csv, or .tsv file
	wb.SaveAs("NewXlsxFile.xlsx") 'Export as .xlsx file
End Sub
```

---

## 3. C# Export to .XLS File

It is also possible to export a file with the .xls extension using IronXL. For this purpose, let's see the example below.

**C#:**
```
using IronXL;
static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("XlsxFile.xlsx");//Import .xlsx, .csv or .tsv file
    wb.SaveAs("NewXlsFile.xls");//Export as .xls file
}
```

**VB:**
```
Imports IronXL
Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("XlsxFile.xlsx") 'Import .xlsx, .csv or .tsv file
	wb.SaveAs("NewXlsFile.xls") 'Export as .xls file
End Sub
```

---

## 4. C# Export to .CSV File

We can easily export our `.xlsx` or `.xls` file into `.csv` using IronXL. Let's see one case that shows how to export Excel file to CSV (`.csv`) file.

**C#:**
```
using IronXL;
static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");  //Import .xlsx or xls file          
    wb.SaveAsCsv("NewCsvFile.csv"); //Export as .xls file
}
```

**VB:**
```
Imports IronXL
Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx") 'Import .xlsx or xls file
	wb.SaveAsCsv("NewCsvFile.csv") 'Export as .xls file
End Sub
```

The above code will create the following three CSV files:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/63klg3zv40dl4ncg11jy.png)

It is very simple to understand why it created three `.csv` files. It is because `sample.xlsx` contains three Worksheets. Therefore, it will create three `.csv` files, and each Worksheet's Excel file data would export to the corresponding `.csv` file.

We can see the number of sheets in `sample.xlsx` here:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9629gf4s6t880uflq6y2.png)

However, if there is one worksheet in the Excel file, then just one .csv file would be created.

---

## 5. C# Export to .XML File

We can export our Excel file data into .XML file format. The below code will export `sample.xlsx` file data into a `.xml` file. It will create three XML files because `sample.xlsx` has three worksheets, same as in the earlier example.

**C#:**
```
using IronXL;
static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx");  //Import .xlsx, .xls or .csv file          
    wb.SaveAsCsv("NewXmlFile.xml"); //Export as .xml file
}
```

**VB:**
```
Imports IronXL
Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx") 'Import .xlsx, .xls or .csv file
	wb.SaveAsCsv("NewXmlFile.xml") 'Export as .xml file
End Sub
```

---

6. C# Export to .JSON File

Using IronXL makes it very easy to export Excel file data into JSON file format, as in the below code example. The code will export `sample.xlsx` file data into a `.json` file. It will again create three `.json` files due to the three Worksheets of `sample.xlsx`.

**C#:**
```
using IronXL;
static void Main(string[] args)
{
    WorkBook wb = WorkBook.Load("sample.xlsx"); //import Excel file
    wb.SaveAsJson("NewjsonFile.json"); //Export as JSON file
}
```

**VB:**
```
Imports IronXL
Shared Sub Main(ByVal args() As String)
	Dim wb As WorkBook = WorkBook.Load("sample.xlsx") 'import Excel file
	wb.SaveAsJson("NewjsonFile.json") 'Export as JSON file
End Sub
```

---