---
title: How to convert TSV to XLSX
description: "Step‑by‑step guide to using Sheetize for transforming TSV files into XLSX workbooks (macro‑free), ideal for reporting, data analysis, and sharing."
weight: 2
categories: "Developer's Guide"
draft: false
---

**Sheetize TSV‑to‑XLSX Converter for .NET** provides a simple yet powerful API for reading TSV (tab‑delimited) data and writing it to an Excel workbook while preserving column types, header rows, and cell styling. This is useful when you need to distribute data in a familiar spreadsheet format or integrate it into workflows that only accept XLSX files.

## Main Features

### Convert TSV to XLSX  
Read any TSV file (tab‑delimited) and generate a macro‑free XLSX file, with optional data‑type inference and custom column formatting.

### Preserve Formatting & Data Types  
Detect numbers, dates, booleans and apply appropriate Excel styles; you can also supply a style template to keep a consistent look.

### Streaming Support  
Process huge TSV files row‑by‑row to keep memory usage low, perfect for batch conversions or web services.

## Detailed Instructions

### TSV → XLSX Workflow  
To convert a TSV file to XLSX with Sheetize, follow these steps:

1. **Initialise the converter** – create an instance of `TextConverter`.  
2. **Configure options** – set `LoadOptions` (delimiter, encoding, hasHeader) and `TextConverterSaveOptions` (output path, style template).  
3. **Define file paths** – provide the source TSV path and the destination XLSX location.  
4. **Execute conversion** – call `Process` with the prepared options.

**Example – Convert a TSV to XLSX (UK locale)**  

```csharp
using System.Globalization;
using Sheetize;

var readOptions = new LoadOptions
{
    InputFile   = @"C:\Reports\sales_data.tsv",
    // Force the UK culture for date/number parsing
    CultureInfo = new CultureInfo("en-GB")
};

var saveOptions = new TextConverterSaveOptions
{
    OutputFile  = @"C:\Reports\sales_report.xlsx",
    // Optional: supply a style template that follows UK corporate branding
    StyleTemplate = @"C:\Reports\uk_style_template.xlsx"
};

TextConverter.Process(readOptions, saveOptions);

Why the en‑GB culture matters

  • Dates – will be interpreted as dd/MM/yyyy rather than MM/dd/yyyy.
  • Numbers – use a comma as the thousands separator (e.g., 1,234.56).
  • Currency – the default Excel currency symbol will be £ when the workbook is opened on a UK‑configured PC.

Expanded Format Support

  • Sheetize can also convert XLSX back to TSV, optionally selecting specific sheets or ranges.
  • The library supports exporting to JSON, CSV, or HTML directly from the generated workbook, enabling end‑to‑end reporting pipelines (e.g., TSV → XLSX → HTML).

With these capabilities, Sheetize makes TSV‑to‑XLSX conversion effortless, whether you need a quick one‑off script or a production‑grade service built for a UK audience.

 Українська