Find & Replace Values in Multiple Excel Files using Python (fast & easy)

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I will show you how you can use Python to find and replace multiple values in Excel. You'll see that it's straightforward, and the whole process only takes a few seconds! In particular, we'll be using the openpyxl library.

🌍 𝗟𝗜𝗡𝗞𝗦:

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

*I will be here in the comments section. Please provide your exact error message for any issues, and I will try to help.*

[goldenight]

Excellent explanation and thanks for the tips.
I haven't write scripts for 7 years, but as I'm going to have a job that needs some automations I had to install python again...
Continue with these simple and very straightforward explanations ;)

[jorgesantanderm]

This is the Next Step; truly thank you. I will learn more of the for loop and the paths but clearly this would make much easier some tasks.

[kshitijmohan]

Just wanted to let you know that i eagerly wait for your videos, keep up the good work, youre amazing, youre making a difference

[viswanathan]

Had developed an inclination to learn Python programming, wonderful explanation

[ammadkhan]

I like you style.. it's really easy to follow and learn actively. Thanks for your work.

[GenNextAnalyst]

Hi Sven, thanks for another informative tutorial. Your presentation skill is getting better and superb. Another idea for python excel tutorial "How to Merge Excel Files with Different Headers using Python". It's quite a common scenario in business.

[sachindubey]

Always have great content i love this chennel ❤

[firatealt]

Thanks a lot, this will save me a great deal of time as try to simplify large dataset files by replacing strings with numerical codes. But to do exactly that I need to make replacements in specific columns. Meaning I need to create multiple dictionaries for say column a=provinces column b=cities. Now each column has matching strings that have their respective different numerical codes. e.g. cordoba in province column needs to be replaced with 1 while cordoba in cities with 2. How can I use different dictionaries for different colums? I don't want to make you prepare a new tutorial video, but I'd appreciate it if you name the functions that I need to use. Thanks a million in advance.

[patrickcoppinger]

Terrific explanation. Had this working 10 minutes after watching the video. One question: Is there a way to perform the replacement on partial cell contents rather then complete cell?

[hemqnlp]

Very helpful and transparent, Sven, thanks a lot!

[raymundofelipeolvera]

Excelent video, there is some examples of find and delete any given string instead of replace?

[priyankamastakar]

Quite useful. What i understood is this particular query is to replace the cell contents. Is there an option like if col A in your example has Government change col B to USA from Canada?

[ahmedsalah]

Your video is really helpful, please keep up the good work 👍👍👍

[Anarky]

Great!! Really well detailed and explained

[ifkozyw]

Thanks a lot, Sven! But I would like to ask how to solve the problem of Upper Case or Lower Case for the text in the Excel. For example, we find "Apple" but the code can not find the "APPLE" or "apple" right? So, how to replace them like we replace "Apple" fastly and easily.

[ifoiwnvoinvoienrv]

i want to ask if you can make a video of you using python to find and replace words in multiple files

[rahulrampally]

In one of folder 📁 there .sql files

I would like to change the database name based on input environment details

For example :
Input is ST
But code currently in Dev environment need to changed to ST
DEV -> ST

What are we doing here : I am doing the environmental Db changes into the SQLs



Which are functions we need to use ?

[tpalexander]

Hai Can you help to find the difference of two excel sheet that have difference in rows and columns in multiple tabs ?

[pankajjaswani]

Which software you have used for highlighting the fields and arrows?