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.

Tested on Windows and Linux.

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.