VBA Macros (.xlsm)
Open the file in Excel, click Run. No installation needed. Works directly inside your spreadsheet for tasks like bulk formatting, sheet splitting, and data manipulation.
XLWizard is a library of ready-to-run VBA macros, Python scripts, and Excel add-ins. Each one solves a specific spreadsheet headache. Download, follow the guide, done.
No subscription. No account needed. Download & keep forever.
Sound familiar?
“I spend every Monday morning reformatting the same report. It takes two hours and the result still looks off.”
“We have duplicate entries all over our customer list but fixing them manually takes forever.”
“I need to email a separate sheet to each person on a list but Excel has no built-in way to do it.”
“Our data comes in one messy file every week — wrong formats, extra spaces, inconsistent names.”
“My manager wants a PDF report every Friday. I copy-paste into Word and pray the formatting doesn’t break.”
“I have formula errors everywhere and no idea which cells are the cause. Finding them is a nightmare.”
What’s in the library
Every tool ships with a plain-English guide. No coding experience required.
Open the file in Excel, click Run. No installation needed. Works directly inside your spreadsheet for tasks like bulk formatting, sheet splitting, and data manipulation.
Each script comes with a step-by-step setup guide written for non-developers. Uses openpyxl and pandas to handle heavy data cleaning, merging, and reporting tasks.
Install once and the tool lives inside Excel permanently — available in your ribbon for any workbook, any time. Ideal for recurring tasks like report generation.
Every download includes a PDF walkthrough with screenshots. If you ever get stuck, email support is included with every purchase — we reply within 24 hours.
VBA macros and add-ins work on Excel for Windows and Mac (Microsoft 365). Python scripts are platform-independent. Compatibility is clearly listed on every tool page.
Pay once, download instantly, use forever. No monthly fee, no account required, no expiry. Future updates to tools you’ve bought are always free.
How it works
Browse the library, read the description, and confirm it fits your use case. Each page shows exactly what it does, the file type, and which Excel version is required.
Pay once via Gumroad. You get a .zip file immediately containing the tool and a step-by-step PDF guide. No account creation required.
Open the file or install the add-in following the guide. For Python scripts, the README walks you through the one-time setup. Most people are running within 5 minutes.
Browse tools
Individual tools: $5–15. One-time purchase. Instant download.
Apply fonts, colours, borders, and number formats to thousands of cells at once based on rules you define. Turns a 2-hour job into 30 seconds.
Scans one or multiple sheets for duplicate rows and flags or removes them automatically. Supports fuzzy matching for near-duplicate names and emails.
Convert any sheet or range into a cleanly formatted PDF — with headers, page numbers, and your chosen print area. Runs from your ribbon in one click.
Fix messy data in bulk: trim whitespace, standardise date formats, normalise text casing, and remove unwanted characters across an entire column in seconds.
Split one large worksheet into separate files or tabs based on a column value — e.g. split a master sales file into one file per region or rep, automatically.
Highlights every broken reference, circular dependency, and inconsistent formula in your workbook. Generates a plain-English error report on a separate sheet.
Testimonials
"The Bulk Cell Formatter alone saved me at least 3 hours a week. I manage our monthly sales tracker and the reformatting was killing me. Now it's literally one button."
"I'm an accountant and not a developer at all. The Python Data Cleaner came with the clearest step-by-step guide I've ever seen. Had it running in under 10 minutes. Absolutely worth $8."
"I bought the whole bundle. Honestly the best $49 I've spent on software this year. The Sheet Splitter and PDF Report Builder alone have changed how I work. No subscription, no nonsense."
The tool that fixes your problem is probably already in the library. Browse 40+ ready-to-run Excel tools — each one $5–15, or grab them all for $49.
One-time purchase. Instant download. 30-day money-back guarantee.