Skip to content

Blogs
Home

Tag: excel

“Excel does not support datetimes with timezones”: Fixing It in pandas

Learn why pandas refuses to save some dates to Excel and how to fix every date column with a few lines of code.

July 13, 2025
Working with Arabic Text in Python: Normalising, Searching, Exporting

Learn how to clean Arabic text in Python so searching works, and how to export it so Excel shows it correctly.

June 9, 2024
Stop Emailing 50 MB Spreadsheets: SQLite for Analysts

Keep your big data in one small SQLite database file and ask it questions with Python, pandas and simple SQL.

April 21, 2024
pandas for Excel Users: Cleaning Messy System Exports

Clean a messy export file with a few lines of Python and pandas, and run the same cleaning again every week.

November 26, 2023
VBA: Turn Every Excel Row into a PDF and Email It

Use a short VBA macro to create one PDF for each row in your sheet and prepare an Outlook email for each one.

October 8, 2023
Power Query: Combine a Folder of Monthly Excel Files in One Click

Learn how to join many monthly Excel files into one table with Power Query, and update it next month with one click.

August 20, 2023

Fahad AlsaedBlog

Proudly powered by WordPress