Excel to SQLite to Excel with Python

Показать описание

Hey guys, a lot of you have asked me, "how can I get Excel data into my own database and get data back out again using Python?" Also, most of you don't want to install some kind of database server to make it happen. The truth is, you don't need any kind of database server (like MySQL, PostgreSQL, SQL Express and others), and you can do this task with an SQLite database, right on your desktop! Massive number of tables? No problem. 2 billion rows? Easy. 6Gb database? Piece of cake. Store data from your Excel project data properly in a desktop RDBMS database and use its powerful indexing and query features then pull results back out into Excel for analysis. It is a killer combo! No server installation. Nothing to purchase. No cloud stuff to manage. Just pure, powerful desktop data.

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media: