Excel2bSDD Converter

A desktop Python application that converts structured Excel files into valid bSDD-compliant JSON documents. Built with Tkinter for GUI and supports packaging into a standalone .exe.

Features

• 🖼️ GUI-based interface using Tkinter
• ⚙️ Converts Excel (based on bSDD template) to JSON
• 🧹 Option to remove null fields
• 🧪 Unit tests comparing GUI and CLI outputs
• 📦 Easy packaging with PyInstaller into a .exe

📁 Recommended Project Structure:
.
├── src/
│   └── bsddconverter/
│       ├── gui.py
│       ├── mapper.py
│       ├── __init__.py
├── templates/
├── data/
├── tests/
│   ├── test_converter_output.py
│   ├── data/
│   │   ├── test_excel_dd.xlsx
│   │   └── bsdd-import-model.json
│   └── expected_result.json
├── README.md
├── requirements.txt
├── pyproject.toml

Pyinstaller Packaging

Run Command Prompt:

pyinstaller --onefile --name bsddconverter --windowed --paths src --collect-submodules openpyxl src/bsddconverter/gui.py --distpath build_output/dist --workpath build_output/build --exclude-module tests --exclude-module pytest --specpath build_output/spec

Option 2 with all submodules and hidden import:

pyinstaller --onefile --name bsddconverter --windowed --paths src --collect-submodules openpyxl --collect-submodules tqdm --collect-submodules pandas --collect-submodules numpy  --hidden-import=tkinter --distpath build_output/dist --workpath build_output/build --specpath build_output/spec --exclude-module tests --exclude-module pytest src/bsddconverter/gui.py

append with "--console" if you would like the .exe file to open with the terminal

Run the GUI

Navigate to the root folder then use:

cd src
python -m bsddconverter.gui

Run pytest

pytest tests/

or a specific file

pytest tests/test_converter_output.py

🧪 Test Flow Tests validate your GUI converter by comparing its JSON output to the known-good result from the original Excel2bSDD_converter.py CLI tool.

Requirements (for development)

• Python 3.8+
• pandas
• openpyxl
• tqdm
• numpy
• pytest

Install all dependencies:

pip install -r requirements.txt

📬 Contact Maintained by @keiffer213. For bSDD spec questions, visit buildingsmart.org.