Just use the same formula as for Excel: = B1 & " - " & C1 & " - " & D1 & " - " & E1 Generating of Audio File Names from ID3 Metadata with Tag Editor & Apple Numbers In a similar way, along with Microsoft Excel, Google Sheets or Apple Numbers also can be used for composition.
Select the new filenames in Excel and Copy-Paste them to the Tag Editor. In Excel, to automatically populate the filenames in the column, copy the cell with the formula, extend the selection and paste the formula into the selection, as was shown in the video below. The formula joins cells B1, C1, D1 and E1 by using " - " separators. In Excel, in the empty column, type the formula for composing a new file name. Select a range of cells in the Tag Editor and Copy-Paste them to Excel. To rename with Excel, follow the steps below: When the standard order of filename components is not sufficient, or there is a need to use some other tags as filename components, the renaming with Excel becomes handy. Read More: Tagging with Find and Replace >īatch Audio Renaming with Tag Editor & Excel Typing in a filename with Tag Editor for Mac We recommend using Copy-Paste and Find-Replace functions for speeding up the manual renaming. To change filenames in manual mode, just select cells in the File Name column and modify them as any other audio metadata cells. Read More: Selection of cells with keyboard shortcuts > 
Read More: Loading tags from Path Components > If you are not, you can undo changes using ⌘+Z keys. Suppose you are happy with renaming, press ⌘+S to save it.
Choose the components of the new filename and characters that should separate them. Click on the button with three dots to open the Filename Renaming window. Select a single cell, few cells, or entire File Name column. 
To rename in Automatic Mode, follow the steps below: We recommend batch automatic renaming after verifying corresponding audio metadata, such as Track #, Artist, Title, Album Artist, Album, Year.
Batch Renaming with Apple Numbers or ExcelĪutomatic Mode allows creating filenames using the pattern of tags' values, such as Track# - Artist - Title. You can also create new filenames out of any ID3 tags in ANY order with Apple Numbers, Microsoft Excel or Google Sheets. Tag Editor allows renaming of MP3 and other audio files in the manual and automatic mode. Spreadsheet format allows you to check, edit, and automatically standardize multiple filenames in a single table. Tag Editor is ideal for editing and unification of music filenames. Correct and structured audio filenames greatly facilitate music search and removal of duplicated songs, while proper numbering in names ensures the right order of files during playback.
0 kommentar(er)
