Automate Excel with ChatGPT (and Python)

In this video, we're going to make ChatGPT generate Python code in order to automate Excel.
Before running the scripts generated by chatGPT, make sure you have the libraries installed. If not, install them with pip.

Social Media
===========

My Courses
==========

Support My Work
==============

--------------------
Content:
0:00 Intro
0:15 Joining Excel files with ChatGPT
4:21 Applying formulas to multiple Excel files
7:57 Renaming files with ChatGPT
9:48 Editing the content in Excel using ChatGPT

[ThePyCoach]

What should my next ChatGPT video be about? Share your ideas below (but please don't ask ChatGPT this question😅)

[prefercihan]

Oh my God! Wonderful work...
Credit goes to you (and chatgpt, looks like it is doing the work :) ).

[medasbabu]

I'm a VBA coder, post ChatGPT, I'm easily able to code in python, in just one month, I'm able to write lenthy code to speed up my tasks, amazing AI tech, loving it.

[vincerob]

Thank you for you valuable video - this is what many of us need with real example of coding - great tutorials! I am learning how to become a data analyst and found that many companies still using spreadsheets - so I am learning python panda library to automate many processes that are slow in excel. more example like this video are very welcome

[rogermarquez]

This is awesome! As someone learning python at the moment for data analysis, this is great stuff! As a side note, you can merge the data of multiple files directly from excel without the need of python..just FYI

[aymx]

Thank you very much. That was really helpful.

[resresres]

Just a side note. ChatGPT can basically only handle really simple excel tasks, but it can give you a start if you are new. Also, these tasks for excel only work if your excel data is VERY clean... from my experience, data in excel files is never so clean. At my job, i always have to run multiple sets of blocks of logic code to determine how the value within a cell is setup in order to figure out what to do with that value in my program and to also detect errors.

For example, I created a program that reads the requirements column within inspection reports. The cells in this requirement column contains both a nominal value and a tolerance. i have to run logic to figure out how to separate between the 2 in the cell if there is even both a nominal and a tolerance because sometimes the nominal is a range with no tolerance, then run logic to determine what type of tolerance it is if there is one, as a tolerance can take multiple forms, then I use some logic to determine what needs to be removed as extra stuff can appear within that cell as well that I don't want. Then I read the results column and run logic on it as the results can also take multiple forms. Lastly, based on the logic from the previous steps, it runs the correct calculation to determine the percentage (or highest percentage if ranged result) of the tolerance used up based on the result.

Yeah, if our inspection reports were setup so that each item, nominal, low end of tolerance, upper end of tolerance, low of end of result, high end of result were each in inputted into their own column in the excel, then our excel inspection reports could all be evaluated incredibly simply and ChatGPT could do but alas, they are not.

I suspect many people run into this problem where data is not so clean.... yet every example on youtube shows perfectly clean examples of data input into an excel.

[arunm]

Hi i have a task of copying data from source excel which is xlsx to multiple xlsm file only selected sheets but im not able to do it is there any thing you can help on with

[FunDumb]

Can it add to include this into a fully responsive html and css page.

[zachbarber_]

What are you using to write the code for testing

[Chitus]

I would like to thank you for showing how ChatGPT can help with Excel queries. It is awesome. I am learning pandas library to move away from the slowness and crashing of excel, especially when files are linked to multiple files in other folders. I am good with formulas, but I don't want to learn VBA or power query, so I went straight to Python. However, is ChatGPT going to stunt my learning of the pandas library since it provides the code, or is it better to gain a working knowledge of pandas before using ChatGPT?

[bhavithshetty]

Hey there, i hope you are doing fine !!!
i have problem where is mycodde is unable to support relative referencing, absolute referencing and mixed formula, whenever i am am trying to insert the rows and copy values and formula, it is able to copy and values and formula but is not true for inserted cell, it is true for row above ....
please help with the suggestion,
Thanks !!!!

[sirrr.]

I have been working on an excel project in which I had to concatenate the data from multiple files. But in my case the number of rows exceeded excel's limit of 100, 000 in one worksheet. So I was wondering, is there any other way through which I can perform excel actions using python without even concatenating the files, and bring the summary results in one seperate worksheet?

Anyone please help as I don't really know what to ask from chatgpt in this regard. Thanks in advance

[charu]

Hi, is there any video of Twitter streaming or storming?

[nocomment]

Can we use chatgpt for modelling and simulation like Monte Carlo simulation model

[Seawolf]

Really cool! Though in all of these examples I think I'd figure the python side out myself, faster than it would take me to learn how to use chatgpt effectively. But with more advanced examples I could see a major speed boost by using chatgpt.

[a.visser]

whtat is the application you use to run the Python scripts? I'd like how you order the files and run the scripts

[thomasmercer]

Can you make a video, showing chatgpt automating accounting?

[kamrulislamsujan]

How to make android apps using chatgpt

[peabody]

so convenient that you always have exactly 1000 sales per month!