AJ Excel Utilities

A Free, lightweight tools that i created over weekends designed to make your Excel/CSV task easier. Runs locally, without sending your data anywhere.

Utilities/Functions you can perform

Easy VLOOKUP : Join two Excel or CSV files instantly — just like Excel’s VLOOKUP() function, but simpler. Select your Destination file (the one you want to enrich) and your Source file (the one providing extra columns). Click and you have your instant VLOOKUP.
Multi-Key VLOOKUP : Performs lookups using two keys. for example, Name + City if name is not unique A live preview lets you confirm before merging.
Cleaning tool : Trim Spaces ( like excel Trim() ), remove duplicates, fix numbers saved as string, remove empty rows and columns.
Cleaning tools in Batch : Select multiple sheets, select multiple cleanings and you can have yoru 20 files all cleaned up at once
Column reorder/delete: easier than copying and inseting in excel. Rearrange columns using arrow buttons or delete unwanted ones with a cross.
Simple Merge : Stacks multiple files vertically into one unified dataset — ideal for merging monthly or departmental reports. All selected files should share the same columns (use Column Reorder first if needed).
Regex Replace : Search and replace text using regular expressions (regex). Use templates for patterns like digits, emails, URLs, or capitalized words. Preview results before applying changes to multiple columns at once.

Built with Opensource tools in Python
I built it in python using the following modules

PySide6 : for Windows GUI
pandas : For all data operations
python-calamine, openpyxl ,XlsxWriter : for file import export
chardet : to detect CSV encoding
re (Regular Expressions) : for advanced find and replace based on Regular expressions