{"id":27686,"date":"2022-09-11T19:52:46","date_gmt":"2022-09-11T19:52:46","guid":{"rendered":"https:\/\/excelevate.co\/wp\/?page_id=27686"},"modified":"2022-09-15T22:49:18","modified_gmt":"2022-09-15T22:49:18","slug":"xlev8-manual-bulk-file-rename","status":"publish","type":"page","link":"https:\/\/excelevate.co\/wp\/home\/support\/xlev8-manual-bulk-file-rename\/","title":{"rendered":"XLEV8 MANUAL: BULK FILE RENAME"},"content":{"rendered":"

<\/p>[et_pb_section fb_built=\u201d1\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d custom_padding=\u201d0px|||||\u201d global_colors_info=\u201d{}\u201d][et_pb_row _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d4.16\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][et_pb_text _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d min_height=\u201d28.8px\u201d global_colors_info=\u201d{}\u201d]\n

XLEV8 EXCEL PRODUCT MANUAL<\/span><\/h1>\n
\u00a0<\/p>\n
BULK FILE RENAME<\/h2>\n
[\/et_pb_text][et_pb_toggle title=\u201dDetails\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
What it does<\/strong><\/span>
Uses a settings sheet (Bulk_File_Rename<\/strong><\/span>) to loop through a defined list of files to rename.\u00a0 Note \u2013 most file types can be renamed, not just Excel files.\u00a0 While you can<\/strong><\/em> use a new file extension as a part of the new file name, use caution when doing this as it may have unintended consequences.\u00a0 If using a new file extension, consider either making a backup of files or using the Bulk Copy Paste<\/strong> macro to make copies of the files you want to rename.<\/p>\n
When to use it<\/strong><\/span>
When you want to rename many different files within one or more folders.<\/p>\n
Why to use it<\/strong><\/span>
It\u2019s an efficient way to rename a lot of different files (Excel and most other file types) within one or many different folders.\u00a0 This also ensures the files are renamed very specifically and consistently, which is required for many applications that work with Excel.<\/p>\n
Default shortcut<\/strong><\/span>
None<\/span><\/strong><\/p>\n
Other Details<\/strong><\/span><\/p>\n
\n
Category: Sheets \/ Files and Folders<\/li>\n
Difficulty: 3\/5<\/li>\n
Usage\/frequency: 3\/5<\/li>\n
Automation factor: 5\/5 (estimated 300 seconds saved each time used)<\/li>\n
Type: Bulk<\/li>\n
Date added: 9\/6\/2018<\/li>\n
Tags: bulk, file, rename<\/li>\n<\/ul>\n
[\/et_pb_toggle][et_pb_toggle title=\u201dRelated Macros and Articles\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
Related Macros<\/strong>
Bulk File Copy
Bulk Copy Paste
Create Subfolders
List Directory Contents<\/p>\n
Other Articles<\/strong>
None<\/p>\n
[\/et_pb_toggle][et_pb_toggle title=\u201dExample Files\u201d _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
Bulk File Rename Example File<\/a><\/p>\n
[\/et_pb_toggle][et_pb_toggle title=\u201dInstructions\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
Prerequisites<\/strong>
Identify the file(s) you want to rename and the new names you want to give them.<\/p>\n
Instructions
<\/strong>After you have identified the files to rename and new names to give them,, run the Bulk File Rename<\/strong>\u00a0macro.\u00a0 The first time you run it, it will create a sheet called Bulk_File_Rename<\/strong><\/span>.\u00a0 These are the columns within the Bulk_File_Rename<\/strong><\/span>\u00a0sheet you\u2019ll want to fill in:<\/p>\n
\n
Column A \u2013 Folder Path<\/strong> (required): for each file to rename, enter the entire folder path that contains the file (excluding the file name).<\/li>\n
Column B \u2013 Old File Name<\/strong> (required) \u2013 enter the existing file name (including the file extension) for each file to rename. To get a list of existing files (including the full file path) within a folder, run the List Directory Contents<\/strong> macro and copy the folder paths and file names you want to rename into this sheet.<\/li>\n
Column C \u2013 New File Name<\/strong> (required) \u2013 enter the new file name (including the file extension) for each file to paste. Be very careful if looking to change file extensions \u2013 making backup copies of files to rename is advised.\u00a0 Also note that the files are processed in the order listed in the Bulk_File_Rename<\/strong><\/span> sheet. If you want to reuse file names within your list (such as to re-order files), you must<\/strong><\/em> list them carefully in order. For example, to rename File1.xlsx to File2.xlsx and File2.xlsx to File3.xlsx, you should list them in reverse order so that File2.xlsx is renamed to File3.xlsx first, so that there is no duplicate file name issue trying to rename File1.xlsx to File2.xlsx.<\/li>\n<\/ul>\n
[\/et_pb_toggle][et_pb_toggle title=\u201dScreenshots\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d]<\/p>\n
\n
\n
$\"\"$
Screenshot of Bulk File Rename macro (populated settings sheet).<\/p><\/div>\n<\/div>\n<\/div>\n
[\/et_pb_toggle][et_pb_toggle title=\u201dVideo\u201d _builder_version=\u201d4.18.0\u2033 _module_preset=\u201ddefault\u201d hover_enabled=\u201d0\u2033 global_colors_info=\u201d{}\u201d sticky_enabled=\u201d0\u2033]<\/iframe>[\/et_pb_toggle][et_pb_comments _builder_version=\u201d4.17.6\u2033 _module_preset=\u201ddefault\u201d global_colors_info=\u201d{}\u201d][\/et_pb_comments][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/body><span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>XLEV8 Add-in how to: Bulk File Rename<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":299,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-27686","page","type-page","status-publish","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/27686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/comments?post=27686"}],"version-history":[{"count":3,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/27686\/revisions"}],"predecessor-version":[{"id":27730,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/27686\/revisions\/27730"}],"up":[{"embeddable":true,"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/pages\/299"}],"wp:attachment":[{"href":"https:\/\/excelevate.co\/wp\/wp-json\/wp\/v2\/media?parent=27686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}