Adding data from csv file to file names
Hello everyone,
I am seeking some help regarding file names from an csv file in excel.
for example I have a few files like below which needs to be renamed from the excel file.
001 - 01 January 2025
002 - 02 January 2025
003 - 03 January 2025
The data I have in excel is :
Column A Column B
001 Monday
002 Tuesday
003 Wednesday
What I need is the new file name should be as :
001 - 01 January 2025 - Monday
002 - 02 January 2025 - Tuesday
003 - 03 January 2025 - Wednesday
Is this possible please and if you know how to do it I would appreciate it heaps.
Many thanks for reading my post and looking for some assistance.
I am seeking some help regarding file names from an csv file in excel.
for example I have a few files like below which needs to be renamed from the excel file.
001 - 01 January 2025
002 - 02 January 2025
003 - 03 January 2025
The data I have in excel is :
Column A Column B
001 Monday
002 Tuesday
003 Wednesday
What I need is the new file name should be as :
001 - 01 January 2025 - Monday
002 - 02 January 2025 - Tuesday
003 - 03 January 2025 - Wednesday
Is this possible please and if you know how to do it I would appreciate it heaps.
Many thanks for reading my post and looking for some assistance.
Reply to #1:
Hi, it's possible.
Once you have added your files, import data from CSV via the Import menu, you will see the column number 1 and number 2, press the Import button. At this point you need the column number 2.
Open the Add method and set it like this:
Add: - <Csv:2>
At index: 0
Backwards checked
Apply to: Name
See the image: https://postimg.cc/LY6Q6F3b
Run the batch to get your new file names.
Good luck!
Hi, it's possible.
Once you have added your files, import data from CSV via the Import menu, you will see the column number 1 and number 2, press the Import button. At this point you need the column number 2.
Open the Add method and set it like this:
Add: - <Csv:2>
At index: 0
Backwards checked
Apply to: Name
See the image: https://postimg.cc/LY6Q6F3b
Run the batch to get your new file names.
Good luck!
Reply to #2:
Thank you so much.
i will try this and let you know if I succeed.
Thank you so much.
i will try this and let you know if I succeed.