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.

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-top-talent

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-top-talent

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

https://www.patreon.com/mackenziedataengineering

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
https://www.facebook.com/mackenziedataanalytics
https://twitter.com/seamacke
https://www.instagram.com/seamacke/
https://www.reddit.com/user/seamacke
https://www.linkedin.com/in/psmackenzie/

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenziedataengineering

#dataengineering #datascience #sqlite #python