EX2DB: Excel to Database Migrator with Streamlit UI Support 🎈

[Juncel]

I built EX2DB, an open-source Python tool that simplifies the migration of Excel spreadsheets to databases. It supports multiple database engines and includes a Streamlit UI for visual, user-friendly migration.

Thanks to Streamlit, I have been able to easily create an interactive UI so users can upload files, preview cleaned data, validate sheets, and migrate to SQLite, PostgreSQL, MySQL, or Oracle with just a few clicks.

Really, Streamlit made it easy .

You can check the project here:

GitHub - j-ncel/ex2db: Excel to Database Migrator

[Jes1]

Very nice Can it infer data types and display them for inspection?

[Juncel]

Thanks Jes1! Currently, EX2DB infers column types by mapping pandas dtypes to SQLAlchemy types internally. The validation report shows the pandas types, and users can inspect before migrating in the Streamlit UI.

Appreciate the feedback, I’ll be adding the mapped SQLAlchemy types to the UI, so it’s easier to see how each column will be treated in the target database.

[Juncel]

Update: just added the SQLAlchemy type preview to the UI. We can now see easier how each column will be treated in the target database.

[Jes1]

Wonderful addition