Excel
Exporting MySQL Data to Excel With a Python Script
Export a MySQL query to a clean XLSX with PyMySQL and pandas, handling DECIMAL, zero dates, tinyint flags and utf8mb4, and compare it with Workbench.
7 min read
Topic
MySQL
The workhorse behind half the web. Queries, quirks and storage-engine lore for keeping it quick, correct and out of the pager.
CSV
Handling Emoji in CSV Imports Without Losing Characters
MySQL utf8 columns hold three bytes per character, so an emoji becomes a question mark during a CSV load with only a warning. See the fix and the checks.
7 min read
Excel
Exporting SQL Server Query Output to an Excel File
Export SQL Server query results to XLSX with pyodbc and pandas, and see what SSMS, bcp and the Import and Export Wizard give you instead.
7 min read
Excel
Writing a DataFrame to Excel With Formatting in pandas
Format a pandas DataFrame in Excel with XlsxWriter: header style, number and date formats, auto-fit widths, a table with banding and conditional formatting.
7 min read
Excel
Exporting a Query to Excel From PostgreSQL With Python
Run a PostgreSQL query from Python and write an Excel file with correct types, converting timestamptz, numeric and ids so the workbook opens cleanly.
7 min read
ExcelGuide
Sending Database Results to Excel Properly Every Time
Export SQL results to Excel that open cleanly: keep types and dates, carry formatting, use several sheets, resist formula injection and run on a schedule.
18 min read
Excel
Validating Row Counts After an Excel Import Step by Step
Prove an Excel import lost nothing by counting rows at the source, the stage and the target, adding control totals, and reconciling rejects in one query.
8 min read
Excel
Staging Excel Data in a Table Before Cleaning It Up
Design a staging table for Excel loads with text columns and provenance, load it fast, profile it with SQL and keep or drop it on a retention rule.
8 min read
Excel
Loading Excel Files With DuckDB and the Excel Extension
Query an XLSX sheet with SQL in DuckDB through its excel extension, read every column as text, create a table and copy it to PostgreSQL or Parquet.
8 min read
Excel
Importing Excel Dates Correctly Into a Date Column
An Excel date column holds serial numbers, real dates or text. Classify each value in the stage, convert each kind by an explicit rule and reject the rest.
7 min read
Excel
Handling Excel Files With Title Rows Above the Header
Find the real header row in an Excel sheet with a title, a date line or a logo above it, read from there with pandas, and cut notes and totals off the bottom.
7 min read
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
Get new articles by email
We send one email when a new article is published. No spam.