Excel
Loading Multiple Excel Sheets Into Separate Tables
Read every sheet of an Excel workbook with pandas, map each to its own staging table with safe names, skip hidden or unexpected sheets and verify the counts.
7 min read
Library
Everything you need to level up your coding skills.
Excel
Importing Excel Data Into SQL Server With OPENROWSET
Query an Excel file straight from T-SQL with OPENROWSET and the ACE provider, enable ad hoc distributed queries safely, and load into a staging table.
8 min read
Excel
Importing Excel Into SQL Server With the Import Wizard
Use the SQL Server Import and Export Wizard to load an Excel sheet, fix the ACE provider and 64-bit errors, and stop it from guessing column types wrongly.
8 min read
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
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.