Skip to main content

Notice

If you are using a Hotmail or Outlook email address, please change it now, as Microsoft is rejecting all email from our service outright.
Topic: Rename wav files based on imported track list from excel / discogs / ... (Read 923 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 / ...

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
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
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
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
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)
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)
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)
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
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

 
SimplePortal 1.0.0 RC1 © 2008-2021