XlsToJsonTool

A simple and efficient Windows desktop utility to convert Excel (.xlsx) files into JSON format. Built with C# and Windows Forms, it provides a user-friendly interface for quick data conversion.

Features

• Easy Conversion: Select any .xlsx file and convert it to a structured JSON file with one click.
• Custom Column Range: Choose a specific range of columns to convert (supports both letter formats like A, B, AA and numeric formats like 1, 2, 27).
• Header Support: Uses the first row of the selected range as field names (JSON keys).
• Smart Extraction: Automatically reads data until the first completely empty row is encountered.
• UTF-8 Encoding: Generates clean, UTF-8 encoded JSON files.
• Auto-Naming: The output JSON file is automatically named after the input file (e.g., data.xlsx -> data.json).
• User Feedback: Real-time status updates and a notification message box upon completion.

How to Use

1. Run the application.
2. Select File: Click the "Browse" button to choose your .xlsx file.
3. Set Range: Enter the start and end columns (e.g., Start: A, End: D).
4. Convert: Click the "Convert" button.
5. Done: A .json file will be created in the same directory as your source file.

Technical Stack

• Framework: .NET 8.0
• Language: C# (Windows Forms)
• Library: ClosedXML for high-performance Excel file handling.

JSON Format Example

The tool generates an array of objects, where each object represents a row:

[
    {
        "word": "example",
        "meaning": "example meaning"
    },
    {
        "word": "example2",
        "meaning": "example2 meaning"
    }
]

Requirements

• Windows 10/11
• .NET 8.0 Runtime