Rename wav files based on imported track list from excel / discogs / ...

Topic: Rename wav files based on imported track list from excel / discogs / ... (Read 1963 times) previous topic - next topic

0 Members and 1 Guest are viewing this topic.

Rename wav files based on imported track list from excel / discogs / ...

2021-01-08 18:24:06

Hi,
I'm wondering if foobar can be used to rename wav files based on an imported track list from excel / discogs / ...

Let's take an example
I ripped a cd naming the tracks : track 01, track 02, ..., track 17.
As I ripped it in wav (using Nero) the files don't have tags.

I prepared a tracklist in excel (see screenshot below)
https://i.imgur.com/YPIf2Ar.jpg
Is there a way to import the track list into foobar and change the names of the files according to the track list in one operation?

To be clear :
I want to keep the original wav-format (no conversion in flac or any other format) and my question is not related to tagging. I simply want to replace the silly file name "track 01" by the correct file name (in my example 01. Queen - Thank God It's Christmas)

Is this possible in foobar ? If not, do you know any program that can do the job ?

Kind regards,
funkyman

Re: Rename wav files based on imported track list from excel / discogs / ...

Reply #1 – 2021-01-09 00:43:51

Don't know about foobar, I use "Bulk Rename Utility" for things like this. It can rename from a text file.

From the help file:
Spoiler (click to show/hide)

Re: Rename wav files based on imported track list from excel / discogs / ...

Reply #2 – 2021-01-09 05:59:07

You could add tags in Foobar, which can write them to wav format and presents a tabular interface not unlike Excel. Then rename according to the metadata using the File Operations component, and remove the tags in the end if you wish.

Re: Rename wav files based on imported track list from excel / discogs / ...

Reply #3 – 2021-01-09 09:08:32

Is the scheme below a valid scheme to put into a csv.file ?
Track No01.wav|01. Queen - Thank God It's Christmas.wav
Track No02.wav|02. John Lennon & Yoko Ono with The Plastic Ono Band - Happy Xmas (War Is Over).wav
Track No03.wav|03. Paul McCartney - Once Upon A Long Ago.wav
Track No04.wav|04. Ann & Nancy Wilson - Here Is Christmas.wav
Track No05.wav|05. Kate Bush - December Will Be Magic Again.wav
Track No06.wav|06. Roxette - It Must Have Been Love (Christmas For The Broken Hearted).wav
Track No07.wav|07. Paul McCartney - Wonderful Christmas Time.wav
Track No08.wav|08. Band Aid - Do They Now It's Christmas?.wav
Track No09.wav|09. Pat Benatar - Please Come Home For Christmas.wav
Track No10.wav|10. Mud - Lonely This Christmas.wav
Track No11.wav|11. Elvis Presley - Merry Christmas Baby (Extended Version).wav
Track No12.wav|12. Love Unlimited - It May Be Winter Outside.wav
Track No13.wav|13. Sinéad O'Connor - Silent Night.wav
Track No14.wav|14. Beach Boys - Little Saint Nick.wav
Track No15.wav|15. José Feliciano - Feliz Navidad.wav
Track No16.wav|16. Alvin Stardust - So Near To Christmas.wav

It's not recognised by "Bulk Rename Utility". The problem could be that there are spaces between the words.
Or maybe I use the wrong csv format (there are like 6 different csv formats I can choose in Excel)

Re: Rename wav files based on imported track list from excel / discogs / ...

Reply #4 – 2021-01-14 17:07:10

Quote from: Dracaena on 2021-01-09 00:43:51

Don't know about foobar, I use "Bulk Rename Utility" for things like this. It can rename from a text file.

From the help file:
Spoiler (click to show/hide)
With Bulk Rename Utility it is possible to rename files according to a text file. The text file should contain a list of "old name" and "new name" pairs, separated by a pipe symbol ( | ) or a comma ( , )
To use this facility, create a text file in for the correct format, for example:

Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3

or use comma separated (CSV)

Track001.mp3,Headlong.mp3
Track002.mp3,Rushes.mp3
TRACK003.mp3,AnywhereIs.mp3

One entry per line.

Next, click the Import Rename-Pairs on the Actions menu and select your file. If the file is valid, then select files to rename and you will see the "new name" column reflecting the contents of the text file.

When comparing the current filename with the text file, the application ignores the case of the filename, e.g. it will match Track001.mp3 and TRACK001.mp3. This makes it easy to rename the files.

Quote from: Dracaena on 2021-01-09 00:43:51

Don't know about foobar, I use "Bulk Rename Utility" for things like this. It can rename from a text file.

From the help file:
Spoiler (click to show/hide)
With Bulk Rename Utility it is possible to rename files according to a text file. The text file should contain a list of "old name" and "new name" pairs, separated by a pipe symbol ( | ) or a comma ( , )
To use this facility, create a text file in for the correct format, for example:

Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3

or use comma separated (CSV)

Track001.mp3,Headlong.mp3
Track002.mp3,Rushes.mp3
TRACK003.mp3,AnywhereIs.mp3

One entry per line.

Next, click the Import Rename-Pairs on the Actions menu and select your file. If the file is valid, then select files to rename and you will see the "new name" column reflecting the contents of the text file.

When comparing the current filename with the text file, the application ignores the case of the filename, e.g. it will match Track001.mp3 and TRACK001.mp3. This makes it easy to rename the files.

Quote from: Dracaena on 2021-01-09 00:43:51

Don't know about foobar, I use "Bulk Rename Utility" for things like this. It can rename from a text file.

From the help file:
Spoiler (click to show/hide)
With Bulk Rename Utility it is possible to rename files according to a text file. The text file should contain a list of "old name" and "new name" pairs, separated by a pipe symbol ( | ) or a comma ( , )
To use this facility, create a text file in for the correct format, for example:

Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3

or use comma separated (CSV)

Track001.mp3,Headlong.mp3
Track002.mp3,Rushes.mp3
TRACK003.mp3,AnywhereIs.mp3

One entry per line.

Next, click the Import Rename-Pairs on the Actions menu and select your file. If the file is valid, then select files to rename and you will see the "new name" column reflecting the contents of the text file.

When comparing the current filename with the text file, the application ignores the case of the filename, e.g. it will match Track001.mp3 and TRACK001.mp3. This makes it easy to rename the files.

Is there a way to use the "rename pairs" function when there are spaces between the words : for example Track 001.wav|Queen - Headlong.wav ?

Re: Rename wav files based on imported track list from excel / discogs / ...

Reply #5 – 2021-01-17 14:25:09

Hi @funkyman !

Here's what I use for renaming files, depending on my needs:

1) rename multiple files (not just audio) by replacing the old filenames:
- using simple patterns
- using regular expressions
- using a counter for each file
- using a file list
- a.m.m.
-------> Total Commander: just ask me if you want to know how to use it

2) rename audio files based on their audio tags:
-------> Mp3tag: just ask me if you want to know how to use it

3) rename audio files in two steps (1. write tags, 2. rename files)
- using the clipboard contents
-------> foobar2000: just ask me if you want to know how to use it

4) rename audio files, move folder contents (including subfolders) to new location and delete old folder (including subfolders)
-------> foobar2000: just ask me if you want to know how to use it

5) rename files using a little Excel VBA Program I wrote:
-------> ExcelVBA_renamer_with_sample_files.zip: just ask me if you want to know how to use it or see screen capture here: Excel_VBA_rename_files.gif

Notice