Migrate Data from MS Excel to SQLite and Back Again

In this episode, we're going to take a round-trip, migrating Excel data to a SQLite database, then back again into Excel as a transformed output. This simple method of moving data can improve your ability to analyze data, especially when they need to be joined in complex ways that are better suited to SQL. Using SQLite, you can not only store data in a better, more rigorous format than Excel or CSV, but you can also leverage powerful SQL capabilities that a relational database management system can provide.. ..all on your desktop! Using local SQLite capabilities means that you can perform all of these operations with no network or internet connections. You can collect data in the field or work on big transformations where networks are spotty or non-existent, and you can leverage the power of your desktop or laptop along with SQL.
Related Videos:
Getting Started with SQLite for Python
• Getting Started with S...
How to Execute SQL from a File on SqLite Using Python
• How to Execute SQL fro...
How to Select Data from SQLite
• How to Select Data fro...
How to Output HTML from SQLite
• How to Output HTML fro...
Migrate Data from MS Excel to SQLite and Back Again
You are watching this video now!
How to Use Dates in SQLite
• How to Use Dates in SQ...
How to Create a Delimited Field in your SQLite Query with Python
• How to Create a Delimi...
How to Make an Interactive Map Using Python and SQLite Data
• How to Make an Interac...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a UA-cam Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#dataengineering #datascience #sqlite #python

[@jaydphenom]

The best type of videos are videos that answers real life questions a random guy from Nigeria who just encountered a need for migrating his data to sqlite might ask.

[@seanmackenziedataengineering]

Nice!

[@mkaberli614]

Thanks. It worked first time without a hitch.

[@seanmackenziedataengineering]

Awesome!

[@pillslifestylereviews6714]

I don't understand a lot of it yet, but this was laterally my first question when I started learning SQL lite. Will definitely be trying this out in a month or two. THANK YOU!

[@seanmackenziedataengineering]

Glad it was helpful!

[@seanmackenziedataengineering]

Welcome! 🛠

[@massimoriggio6297]

Hello Sean, thanks for this wonderful class. Just a question: would this all work while the Excel file is closed?

[@seanmackenziedataengineering]

Yes it will!

[@Chowchow_t]

Hi brother Sean! SQLite and Python is super useful for capturing data - i once used Python for UI (tkinter) for barcode scanners to capture data and connect to db using sqlite3 - one of my first actual project that got me to learn Python

[@seanmackenziedataengineering]

Thanks for sharing! That's pretty cool work for Python 🛠

[@Chowchow_t]

Oh yeah, I forgot to mention it was for daily inventory count - replaced paper and pen and the need to manual data entry. SQLite definitely useful!

[@franklinmoura881]

I loved it. Thanks so much for sharing your knowledge.

[@seanmackenziedataengineering]

You are so welcome!

[@LambertoSalucco]

Thank you, great example.

[@seanmackenziedataengineering]

Glad you enjoyed it!

[@belkmouf]

Nice video Sean . I love it. Will it work for huge excel files of 200k of rows with 150 columns?

[@seanmackenziedataengineering]

Great question.. I think that will work fine - let us know how it goes!