Abdulrhman bin Shuhaywin

Excel automation projects · Built with Python and n8n

I build practical tools that turn messy Excel files into clean, usable data and clear reports. Both projects below can be tried online: upload a file, and the result arrives in your email.

Project 1: Excel Data Cleaner

Live

Upload an unsorted Excel file and a reference template. You receive a clean file that matches the template's columns and order.

What it does

Matches columns by name, in Arabic or English.
Splits names and phone numbers that sit in one merged column.
Standardizes Saudi phone numbers to +966 format.
Standardizes dates to YYYY-MM-DD, including dates written as text in Arabic or English.
Standardizes city names to English and fixes common abbreviations.
Removes empty and duplicate rows, and clears placeholder values such as N/A.

Excel sheet before cleaning, with merged name and phone columns, next to the same data after cleaning, with separate columns and a consistent format. — Before and after: merged columns are split, and dates and phone numbers are standardized.

Data Cleaner upload screen with fields for raw data and the clean reference file. — Upload the raw file and the reference template.

Processing dashboard showing the number of rows processed, the changes made, and a cleaned data preview. — Processing dashboard with a summary of every change.

Try the tool Order

Sample files for the trial

Unsorted dataMessy source file with merged name and phone columns.
Sample file available on request.

Reference templateThe target layout the output should follow.
Sample file available on request.

Upload both files in the trial form. Sample data is fictional.

Project 2: Sales Analytics Report

Live · Demo

Upload a sales Excel file and receive an analytics report by email in seconds. The tool detects the relevant columns automatically, so no setup is needed.

What it reports

Total sales, record count, average per record, and commission total.
Latest month, month-over-month change, and daily run rate.
Monthly trend for the last 12 months.
Top categories, cities, sales channels, and payment methods, with each share of total.
Data quality notes: rows with missing values or invalid dates.

The workflow can be extended to process multiple files at once.

Sales Analytics upload screen where a sales Excel file is uploaded. — Step 1: upload a sales file.

Sales analytics dashboard with total revenue, records, average value, daily run rate, growth, and product performance. — Step 2: the dashboard summarizes revenue, growth, and performance.

Try the tool

Sample file for the trial

Sales data 2025-2026500 fictional car insurance sales records with dates, regions, channels, and premiums.
Sample file available on request.

How to try either tool

Use a sample file, or your own Excel file (.xlsx).
Open the trial form, upload the file, and enter your email address.
Check your inbox for the result: the cleaned file for the Data Cleaner, or the analytics report for the Sales tool.

Contact

For orders or questions, use the order form linked in the Excel Data Cleaner section.