Text2Excel

Text2Excel is a desktop GUI application that extracts data from text files and saves them into Excel or CSV files using regular expression (regex) patterns. It is built with Python’s re module.

Features

• Add regex patterns via the patterns widget (right-click → context menu).
• Choose whether data goes into columns or rows, and select the target sheet.
• Exact Order option:
  • Disabled → places data starting from the last filled row in the file.
  • Enabled → aligns data strictly with existing entries (only in “put in columns” mode).
• Support for regex groups:
  • Example:

    \w{5}(\d)

    This matches 5 word characters followed by a digit, but only the digit will be saved if wrapped in a group.
• Export to Excel (.xlsx) or CSV (.csv) (CSV available via the output file context menu).

note: You cannot place multiple groups in one pattern

Installation

This project requires openpyxl. Install it with:

python -m pip install openpyxl

Version used during development:

python -m pip install openpyxl==3.1.5

Run the app with:

python src/text2excel.py

Build

To build an executable with pyinstaller:

cd build
pyinstaller text2excel.spec

Install pyinstaller if needed:

pip install pyinstaller

License

This project is licensed under the MIT License.