Project 09

Excel to CSV Converter

This project converts Excel spreadsheets (XLSX) into CSV files through a user-friendly Windows Forms application. It provides flexible export options for single or multi-sheet workbooks, making it easy to extract tabular data for use in databases, data analysis tools, and other downstream applications.

C# (.NET)

Closed XML

System.IO

Technical

Highlights

  • Used ClosedXML library to programmatically open and read XLSX files in C#.

  • Built an intuitive Windows Forms UI with real-time console feedback for user operations.

  • Implemented flexible export modes: export all worksheets or selectively choose specific sheets.

  • Iterated through worksheets, rows, and cells to extract structured tabular data.

  • Constructed well-formed CSV output with proper escaping for commas, quotes, and newlines.

  • Added logic to skip empty rows to produce cleaner output files.

  • Handled multiple worksheets with individual CSV file generation (named by worksheet).

  • Implemented path validation to ensure robust file handling

Project

Takeaways

  • Gained hands-on experience with the ClosedXML library for reading Microsoft Office file formats from C#.

  • Learned how to translate hierarchical spreadsheet data into flat CSV representations while preserving data integrity.

  • Developed a practical Windows Forms application with state management and user feedback.

  • Applied CSV formatting standards, including proper value escaping for special characters.