No video
ChatGPT Excel Analysis Tool & Read Any Spreadsheet | Complete Guide
Рет қаралды 45,465
Күн бұрын
@webcafeai 5 ай бұрын
Navigate to key moments👇 made via tubestamp.com 0:00 - Introduction to analyzing data in various file types 1:34 - Analyzing a financial data set with ChatGPT 3:12 - Verifying accuracy by asking specific questions 5:03 - Analyzing number of employees hired in 2021 7:44 - Future potential of user-friendly AI assistants 9:41 - Exploring ChatGPT's new file features 10:59 - Automation possibilities with ChatGPT and Zapier Recap by TubeStamp ✏️
@jje984 6 ай бұрын
I don't think most people know yet just how good an analyst GPT is. By the way it will also do advanced analysis like regressions and decision trees.
@sheet-chat 2 ай бұрын
That's a very advanced feature.
@mr.ssb33 5 ай бұрын
I told chat GPT to analyze my whole life and almost cried after hearing its response 😭😭
@kropekpf84 4 ай бұрын
🤣
@rho_dan_us 9 ай бұрын
Praise the Lord. I've been waiting for this function.
7 күн бұрын
Didn't u make the Oodie onShopify ?
@kropekpf84 4 ай бұрын
Great work Corbin! Thanks for this video.
@webcafeai 4 ай бұрын
🤝
@kashmoney1 6 ай бұрын
Great vid! Can you download the output/results to excel? like charts, analysis, etc.?
@ziadnahdi4343 9 ай бұрын
Thanks man. This is great. We love such videos
@webcafeai 9 ай бұрын
Glad you like them!
@chizzlemo3094 8 ай бұрын
The problem is I have to manually upload the xls, GPT says that for security reasons it cant open the xls and do the tasks... Is there a way I can have it do the whole process itself?
@-paulmp 9 ай бұрын
Hmmm I haven't got the plus button to upload a CSV or excel file, I've just got "attach images". Edit: I had to go into settings to enable the mode that allows CSV files.
@webcafeai 9 ай бұрын
Thanks for sharing! Could help out other viewers here.
@GaniyuTheGreat 3 ай бұрын
Can ChatGPT read & analyze a spreadsheet with only pivot tables?
@Attorney-AssistedDefense-qn7xb 5 ай бұрын
My GPT plus subscription can't seem to read anything in my Excel
@barneywonghao 6 ай бұрын
Hi Corbin, my automation API using GPT 4 turbo assistant analysing attached excel sheet, always outputs a large amount of lines of text of its processes and errors, with only 1 line of the information I want in the end, eating up a bunch of tokens :/. Wondering do you have any thoughts on overcoming this. Perhaps adding extra zap in zapier to output using GPT 3.5?
@user-dx9nz8ue3e 9 ай бұрын
Awesome work Corbin. This is extremely powerful stuff
@webcafeai 9 ай бұрын
Much appreciated!
@roberthudson9342 9 ай бұрын
How do I get that plus? How do I upload my sheets?
@tonysilva2654 9 ай бұрын
You've got to pay $20/mth
@sellingwhips 7 ай бұрын
is there a way to upload a spreadsheet that it can save, and have access to so you can ask it questions about the data on there at anytime?
@webcafeai 7 ай бұрын
Yes, in this context, we would develop a GPT with a knowledge base that includes the spreadsheet.
@sellingwhips 7 ай бұрын
@@webcafeai how? Do you have a video that explains how it could be done?
@webcafeai 7 ай бұрын
@@sellingwhips This video would help most: kzfaq.info/get/bejne/jM-Up5dzls-pnpc.html&ab_channel=Corbinai
@sheet-chat 2 ай бұрын
Perhaps you need a similar office 365 copilot spreadsheet assistant, open Excel can handle your data, I also recently made a spreadsheet assistant, you can try!
@Agent-vl2wh 9 ай бұрын
IT appears some of us do not have this feature. I have plus version and I am not seeing what you are seeing. Why is that?
@webcafeai 9 ай бұрын
This could be due to how OpenAI is rolling out the feature. Alternatively, check your settings to see if you can enable it there!
@PAULMEYERSNorthBay 8 ай бұрын
I don't see in the video how to upload the excel.csv file? I try dragging it in but nothing happens. Do I need a specific plugin?
@webcafeai 8 ай бұрын
There should be an attachment button in the chat input box.
@craig16576 5 ай бұрын
Would you know what the size limit is for an upload? I was thinking of uploading something absurd like 400,000 lines of data from an excel file and see what it can analyse. I won’t buy premium unless it could do this given the data sets I work on are at a minimum this large
@sheet-chat 2 ай бұрын
Maybe not ok, I think you only can write python of vba handle it on local
@avono5330 8 ай бұрын
is there a way to export data calculated back to the excel sheet in a new sheet
@webcafeai 8 ай бұрын
This would be possible in theory using an automation platform like Zapier.
@BrianCoutu 6 ай бұрын
Yes you can do this. Just ask it for a download file. It can even add columns...and manipulate data from multiple sheets. You can import data from one sheet to another using universal identifiers or even attempt to create an identifier based on the data in the sheet.
@Nursultan_karazhigit 9 ай бұрын
Is it possible to use all abilities of chat gpt in own programs? For example trascribation for sellers . ? Or use some plagins ?
@webcafeai 9 ай бұрын
Currently, ChatGPT plugins and features on the frontend can't be used outside the context of API calls.
@Nursultan_karazhigit 9 ай бұрын
thanks@@webcafeai
@sheet-chat 2 ай бұрын
This is a great idea, I had the same idea, so I developed an AI Copilot, embedded in other applications, such as Word, Excel, PPT, or other applications, migration to other applications is also possible!
@user-vn4ou6nw7f 9 ай бұрын
If I want to make system on this plugin for my client in simple upload file and chat like that formant so it's possible using zapier or make chatbot + upload flie on chatbot + auto connect with chatgpt + give answer using this plugin,,,,,,,LIKE THAT so if it's possible so it is help me to white labeling!!! Like more videos
@webcafeai 9 ай бұрын
It is possible, but it would be much more complex. I suggest that you check out the more advanced tutorials on this topic available on this channel, such as this one: kzfaq.info/get/bejne/obJkmtxztdHHpmw.html&ab_channel=Corbinai.
@user-vn4ou6nw7f 9 ай бұрын
Thanks bro I will @@webcafeai
@sheet-chat 2 ай бұрын
I think embedding an ai assistant in your app is a good idea
@webcafeai 9 ай бұрын
Hi all! Exciting news - we've integrated a PDF Reader right into ChatGPT. It's built to handle large PDFs with ease and is completely free for you to use. 👉 GPT [PDF Reader] - chat.openai.com/g/g-QSh6KHL3S-pdf-reader
Clicks Don't Lie - Understand ecommerce data
Рет қаралды 9 М.
Corbin Brown
Рет қаралды 7 М.