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
How to Execute SQL from a File on SqLite Using Python
How to Select Data from SQLite
How to Output HTML from SQLite
Migrate Data from MS Excel to SQLite and Back Again
You are watching this video now!
How to Use Dates in SQLite
How to Create a Delimited Field in your SQLite Query with Python
How to Make an Interactive Map Using Python and SQLite Data

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

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

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#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.

[PillsLifestyleReviews]

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!

[mkaberli]

Thanks. It worked first time without a hitch.

[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

[massimoriggio]

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

[Neilcourtwalker]

Thanks for the videoa. Does the same code work, if I want to migrate data from an Libre Office Calc sheet to a sqlite database?

[AToZfunVideo]

Can u pls suggest me. I work on the excel and daily it got added some new data and some update on old existing data. How to use sqlite to do this
It's like small crm?

[franklinmoura]

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

[belkmouf]

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