Bulk-rename drill core photo photos using interval data — hole by hole, fast and accurately.
GB•CoreNamer reads an interval spreadsheet (Excel or CSV) and a folder of core photos, then renames every image to a standardised filename that encodes the hole ID, box range, and depth interval — automatically, in bulk, with a live preview before anything is touched.
Output filename format:
{HoleID}_{Bx001-004}_{0000.0m-0016.0m}_{Dry|Wet}.jpg
Example:
DDH001_Bx001-004_0000.0m-0016.0m_Dry.jpg
- Flexible interval file support — loads
.xlsx,.xls, and.csvfiles - Column mapping dialog — map any column name to the required fields at load time; no need to rename your spreadsheet headers
- Live rename preview — see old → new filename pairs in a scrollable table before committing
- Dry / Wet photo type detection — automatically detected from the folder name
- Threaded renaming — progress bar updates in real time; the UI stays responsive during large batches
- One-click undo — reverses the last rename operation completely
- Collision-safe — appends a counter suffix if a target filename already exists
- Partial group support — handles the last group of boxes even when fewer than four rows remain
| Dependency | Version |
|---|---|
| Python | 3.8 or later |
| pandas | any recent |
| Pillow | any recent |
Install dependencies:
pip install pandas pillow openpyxl
openpyxlis required for.xlsxsupport via pandas.
python GB-CoreNamer.pyNo arguments needed — the GUI handles everything.
- Load your interval file — click Browse under Interval File Selection and select your
.xlsxor.csvfile. - Map your columns — a dialog will appear asking you to match your column names to:
Hole ID,Box Number,From (m),To (m). - Select your image folder — click Browse under Image Folder Selection. Name the folder with
dryorwet(case-insensitive) and the photo type will be set automatically. - Preview — the table fills with old → new filename pairs. Check before proceeding.
- Rename — click Rename Files. The progress bar tracks completion.
- Undo if needed — click Undo Rename to restore all original filenames.
Your spreadsheet must contain at minimum these four columns (column names can be anything — you map them in step 2):
| Hole ID | Box Number | From (m) | To (m) |
|---|---|---|---|
| DDH001 | 1 | 0.0 | 4.0 |
| DDH001 | 2 | 4.0 | 8.0 |
| DDH001 | 3 | 8.0 | 12.0 |
| DDH001 | 4 | 12.0 | 16.0 |
Photos are grouped in sets of four rows. Each group of four produces one renamed file. If the total number of rows is not a multiple of four, the final partial group is still processed.
The app detects photo type from the image folder name:
| Folder name contains | Photo type tag |
|---|---|
dry (any case) |
Dry |
wet (any case) |
Wet |
| anything else | (empty) |
Only the JPG format is supported. The app does not convert or modify image data — only the filename is changed.
GB•CoreNamer is licensed under the GNU General Public License. Created and developed by Mehmet Duyan — ©Mehmet Duyan, 2026.