Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial

👉 Explore All My Excel Solutions: https://pythonandvba.com/solutions

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I am going to show you how to convert Excel Files into a Web Application by using the Python Library Streamlit. The beauty of Streamlit is that you can create web applications directly in Python, without needing to know HTML, CSS, or JavaScript. The Web App is fully interactive and will be updated, whenever you make changes in the Excel file.

🌍 𝗟𝗜𝗡𝗞𝗦:
► Live Demo: https://surveyresults.pythonandvba.com
► GitHub: https://github.com/Sven-Bo/excel-webapp-streamlit
► Blog: https://pythonandvba.com/blog/....turn-your-excel-file

Deploy your Streamlit Application to Heroku for free:
👉 https://youtu.be/nJHrSvYxzjE

Streamlit Documentation & App Gallery:
https://docs.streamlit.io/en/stable/
https://streamlit.io/gallery

✅ Chapters:
0:00 Introduction
1:20 [Setup] Python Libraries
2:12 ‘Hello World’ in Streamlit
3:41 Insert Dataframe in Streamlit
5:13 Insert Pie Chart in Streamlit
6:13 Insert Images in Streamlit
7:25 [Excursion] Filter & Group Dataframe in Pandas
11:00 Insert Slider & Multiselect in Streamlit
12:08 Filter Dataframe based on user selection
13:06 Group & Plot Dataframe after user selection
14:01 Use columns in Streamlit
14:49 Final Word
15:44 Outro


𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-templates
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources


𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: https://www.linkedin.com/in/sven-bosau/
📸 Instagram: https://instagram.com/codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 Discord: https://pythonandvba.com/discord
📬 Contact: https://pythonandvba.com/contact


☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ https://pythonandvba.com/coffee-donation