A collection of Python utility scripts for automating common file and Excel operations.
| Script | Description |
|---|---|
Change_String_Entire_Folder.py |
Bulk-update a specific cell across multiple Excel files listed in a master workbook |
Create_Multiple_Files.py |
Clone a template Excel file multiple times, customizing a cell in each copy |
Clone_And_Update_ExcelFile.py |
Copy a single Excel file and update a cell in the clone |
Filter_And_Update_Column_File.py |
Filter rows in an Excel file by criteria and update a column value |
Filter_And_Update_Column_Folder.py |
Same as above, but processes all Excel files in a folder |
Group_Files_In_Dir.py |
Group files in a directory by a key extracted from their filenames |
Insert_Row_Excel.py |
Insert a default row into Excel files if it doesn't already exist |
List_ALL_Filename_From_Folder.py |
Recursively list all files in a selected directory |
Parse_txt_file_by_Delimiter_advanced.py |
Parse email entries from a text file and export to Excel |
Copy_Files_From_Subfolder.py |
Recursively copy all files from nested subfolders into a flat directory |
pip install -r requirements.txtEach script has a Configuration section at the top where you set file paths and parameters. Update these values before running:
python <script_name>.pySome scripts use a file/folder picker dialog (via tkinter) instead of hardcoded paths.
- openpyxl - Excel file reading/writing
- pandas - Data manipulation and analysis
- tkinter - File/folder dialog prompts (included with Python)