Convert the content from multiple TXT or CSV files into Excel using Python (Real-World Example)

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Learn how to save time, get organised and reduce errors by using Python scripts for importing data from TXT or CSV files straight into Excel. This tutorial will show you a real-world example of importing data from a TXT file into Microsoft Excel.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:16 – Problem statement
01:29 – Coding out the solution
05:55 – Outro

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

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

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

I hope you liked this Python automation example.
Here are the links ⤵
*Happy Coding!* 🚀

[brazilleros]

Hi Sven! Thank you once again for guiding us through the python automation ideas and your brilliant solutions! Me and my colleagues are grateful for your help with "merging multiply pdf''s by name" project . Thank you for your time and kindful assistance.😇

[TimePasser]

Another practical cool tutorial from the legend. Thank you 😊

[sujungpark]

It is really helpful ! Thank you so much :)

[MrDanilofontana]

Very nice example! I have a small question, why do you define the current_dir like that? I am always using something like os.getcwd() but now I am not sure if this is more efficient or not. Would you know if there is any difference? Thanks in advance and congratz for your content!

[rdtw]

Hi Sven,
Thanks for the detailed coding explanation. It is very helpful.
I also wnonder, if you change the file name from Student_number_Eng/Math to Student_Eng/Math_number, how would you change your code? Let say, the student number is from 001 to 100. I tried to use for loop, but it seems like python doesn't like it.

[zhecao]

Hi, it is very helpful. I have an issue when I tried to do this. I got with xw.App(visible=False) as app: AttributeError: __enter__ . Do you know why it happens. Thank you.

[ibrahimsaiusman]

Greetings
I have tons of files to process and I need to merge daily data files to monthly. Also, each file contains headings (55 lines) and the main body (343 lines).
please assist. NB: the file extension is .trop

[leonpheonix]

When i'm defining current_dir i'm getting an error "cwd() takes 1 positional arguments bur 2 were given"

[udayrajvadeghar]

f you are unable to do . open the terminal in the directory and run this command .
"Get-ChildItem -Filter *.txt | Rename-Item -NewName { $_.Name -replace '\.txt$', '.csv' }"

here i am converting txt files to csv files, replace on that you want to convert .