Library

Everything you need to level up your coding skills.

Excel

Loading an Excel File Into SQLite With Python and the CLI

SQLite cannot read XLSX itself. Load a sheet through pandas to_sql or a CSV import, avoid type affinity traps and convert Excel serial dates.

7 min read

Excel

Importing Excel Into MySQL With Workbench and Scripts

MySQL Workbench cannot import XLSX directly. Convert to CSV for the wizard or LOAD DATA, or use a Python script, and avoid the strict mode and date traps.

7 min read

Excel

Importing an Excel Sheet Into PostgreSQL With Python

Load an Excel sheet into PostgreSQL with pandas and psycopg: read as text, copy into a staging table, then convert types in SQL and keep a batch record.

7 min read

Flat illustration of a database beside the table it holds, with the PostgreSQL and MySQL logos.

ExcelGuide

Getting Excel Data Into a Database Without Heartbreak

A complete method for loading Excel into PostgreSQL, MySQL, SQLite or SQL Server: read as text, stage, check counts, convert types and reload safely.

18 min read

Get new articles by email

We send one email when a new article is published. No spam.