Automate your excel work and formating with python scripts with combining, splitting, converting whole excel-sheets. Or calculate, aggregate, filter, group change, visualize and clean the data as you need it.
Automate Excel tasks and improve productivity with professional Excel automation services.
Excel Automation & Macros | Save Time by Automating Excel
Automated Sales & Commission Reporting Solution
What:
This tool automates sales summaries and commission calculations using quarterly performance thresholds, saving time and ensuring accuracy.
Used Modules:
xlwings
Overview
This Excel automation solution reads sales data for each employee, summarizes total revenue, and automatically generates a quarterly commission table based on multiple performance thresholds.
What It Does
- Processes employee sales data from Excel
- Aggregates revenue per employee and per quarter
- Calculates commissions automatically using defined thresholds
- Produces clear, structured commission reports
Why It Matters
- Eliminates manual sales and commission calculations
- Ensures accurate and consistent reporting
- Saves time for finance and management teams
Portfolio Highlight
This project demonstrates how Excel automation and business rules can turn raw sales data into transparent, reliable commission reports that support better financial decisions.
Automated Excel Data Updater
What:
Updates Excel files with various information, including ZIP code–specific details, allowing for automated data management and accurate record keeping using Python.
Used Modules:
xlwings
Overview:
This tool updates Excel files automatically with a range of information, including ZIP code–specific details, enabling accurate record keeping and efficient data management.
Why It Matters:
- Automates repetitive Excel updates
- Ensures accurate and consistent data
- Saves time and reduces manual errors
Technologies Used:
Python, Xlwings, Pandas
Portfolio Highlight:
This project demonstrates how automation and intelligent data handling can simplify Excel-based workflows, making record keeping faster, more accurate, and fully scalable.
TV Spot Scheduling Tool
What:
Arrange tv-spots in an output-excel-sheet so its a best fit and the budget is not exceeded for the products
Used Modules:
xlwings
Overview:
This tool arranges TV spots in an Excel sheet to ensure the best fit for each product while keeping the budget under control. It automates planning for advertising campaigns, making scheduling efficient and accurate.
Why It Matters:
- Optimizes TV ad placement for maximum impact
- Keeps campaigns within budget
- Saves time compared to manual scheduling
Technologies Used:
Python, Xlwings, Excel Automation
Portfolio Highlight:
This project demonstrates how automation and intelligent scheduling can simplify media planning, helping businesses maximize ad effectiveness while controlling costs.
Handle Transactions Data
What:
Read transactions-data from csvs and build report with categorization, summarization, etc.
Used Modules:
xlwings, csv
Transactions Data Reporting Tool
Overview
This tool reads transaction data from CSV files and generates comprehensive reports with categorization, summarization, and key insights for better financial tracking and analysis.
Why It Matters
- Automates transaction data processing
- Provides structured, easy-to-read reports
- Saves time and improves accuracy for finance and accounting teams
Technologies Used
Python, Pandas, CSV Handling, Excel/Xlwings
Portfolio Highlight
This project demonstrates how automated data processing and reporting can transform raw transaction records into actionable business insights, supporting informed decision-making and financial oversight.
Bank Transaction Analysis & Reporting Solution
What:
Read transactions from different bank-statements, categorize them and build some reports and dashboards out of it
Used Modules:
xlwings, csv
Overview
This solution reads transactions from multiple bank statements, automatically categorizes them, and generates structured reports and interactive dashboards. It transforms raw financial data into clear insights for better tracking and decision-making.
Why It Matters
- Automates transaction categorization across different bank formats
- Provides clear financial reports and visual dashboards
- Improves transparency and reduces manual accounting effort
Technologies Used
Python, Data Processing (Pandas), Excel Automation / Dashboard Integration
Portfolio Highlight
This project demonstrates how financial data automation can convert complex bank statements into organized reports and visual dashboards, enabling smarter budgeting, monitoring, and financial analysis.
CRM Leads Consolidation Tool
What:
Merge 3 different leads csv-files out of a CRM-system, with informations for boxes, contacts and organizations
Used Modules:
xlwings
Overview
This solution merges three separate CSV files from a CRM system containing information about contacts, organizations, and related boxes, creating a single, structured dataset for analysis and reporting.
Why It Matters
- Consolidates scattered CRM data into a unified format
- Reduces manual work and errors during data merging
- Provides a clean dataset for reporting, insights, and business decisions
Technologies Used
Python, Pandas, CSV Handling, Data Processing
Portfolio Highlight
This project demonstrates how data automation and consolidation can transform fragmented CRM exports into a comprehensive, actionable dataset, enabling better tracking, analysis, and decision-making.
Agricultural Data Summary & Reporting Tool
What:
Create a summary excel-sheet out of 2 other sheets with informations about different farms and different plots
Used Modules:
xlwings
Agricultural Data Summary & Reporting Tool
Overview
This solution combines data from two Excel sheets containing information about farms and individual plots to automatically generate a structured summary sheet. The result provides a clear overview of farm operations and land usage.
Why It Matters
- Consolidates fragmented agricultural data
- Provides a clear overview of farms and plots
- Reduces manual reporting effort and errors
Technologies Used
Python, Excel Automation, Data Processing
Portfolio Highlight
This project demonstrates how Excel automation and data consolidation can transform multiple datasets into clear, actionable summaries, supporting better agricultural planning and reporting.
Therapy Questionnaire Google Sheets Template
What:
Create a google sheet template for a therapy questionnaire for several clients a time protocol, detailed explanations and diagrams for visualization
Used Modules:
google sheet
Overview
This solution creates a Google Sheets template for therapy questionnaires, designed to manage responses for multiple clients while including time-based protocols, detailed explanations, and visual diagrams for better understanding and tracking.
Why It Matters
- Simplifies therapy documentation and session tracking
- Allows structured questionnaires for multiple clients
- Uses visual elements and explanations to improve clarity
Technologies Used
Google Sheets, Spreadsheet Automation, Data Structuring, Visualization
Portfolio Highlight
This project demonstrates how structured spreadsheet design and visualization can support therapists in organizing client information, tracking progress, and documenting sessions efficiently.
Operations Report Summarization Tool
What:
Summarize different reports for shop, waterjet and machineshop with different employees and responsibilities
Used Modules:
xlwings
Overview
This solution collects and summarizes multiple operational reports for different departments—Shop, Waterjet, and Machine Shop—including details about employees and their responsibilities. The summarized data is organized into clear, actionable reports for management and oversight.
Why It Matters
- Consolidates departmental reports into a single overview
- Provides clarity on employee responsibilities and workflow
- Saves time compared to manual summarization and reporting
Technologies Used
Python, Data Processing, Excel/Xlwings, Text Summarization (Optional: OpenAI / NLP)
Portfolio Highlight
This project demonstrates how automated report summarization can transform scattered operational data into structured, actionable insights, helping management track performance, responsibilities, and productivity across multiple departments.
Unit Cost List for Materials and Components
What:
Create a unit cost list for different materials and components with different price units and pieces
Used Modules:
xlwings
Overview
This solution creates a structured unit cost list for various materials and components, including different price units, quantities, and cost calculations. The system organizes all items into a clear format for easy pricing, estimation, and cost management.
Why It Matters
- Standardizes pricing across materials and components
- Supports accurate cost estimation and budgeting
- Reduces manual calculation errors
Technologies Used
Excel Automation, Data Structuring, Cost Calculation Logic
Portfolio Highlight
This project demonstrates how structured cost modeling and spreadsheet automation can transform raw pricing data into a clear, scalable unit cost system, supporting procurement, budgeting, and financial planning.
Schedule Slot Optimization Tool
What:
Check times ranges in which slots they are fitting for every scheduled work plan
Used Modules:
xlwings
Overview
This solution analyzes defined time ranges and matches them to available slots within scheduled work plans. It ensures that tasks, shifts, or resources are assigned to the most suitable time windows based on predefined rules.
Why It Matters
- Optimizes scheduling and resource allocation
- Prevents overlaps and inefficient time usage
- Improves planning accuracy and operational efficiency
Technologies Used
Python, Scheduling Logic, Data Processing, Excel Automation
Portfolio Highlight
This project demonstrates how automated schedule analysis can transform complex work plans into efficient, well-structured time allocations, supporting better workforce management and planning.
Football Statistics Data Extraction & Reporting
What:
Read football-statistics from a ms-access-db and provide the data in an excel-sheet. Select several parameters before the program run like leagaue coffeeAndBeer date-range
Used Modules:
pyodbc, xlwings
Overview
This solution reads football statistics from a Microsoft Access database and exports the data into a structured Excel sheet. Before execution, users can define parameters such as league, custom filters (e.g. categories), and date range to tailor the output.
Why It Matters
- Automates extraction from legacy database systems
- Allows flexible filtering for targeted analysis
- Provides clean, structured datasets for reporting
Technologies Used
Python, MS Access (pyodbc), Data Processing, Excel/Xlwings
Portfolio Highlight
This project demonstrates how database integration and automation can transform raw sports data into customized, analysis-ready reports, enabling efficient performance tracking and data-driven insights.
Aircraft Inspection & Maintenance Tracking System
What:
Read inspections-list for aircraft vehicles, check the next service date regarding flight hours, cycles and days
Used Modules:
xlwings
Overview
This solution tracks aircraft inspection records and evaluates upcoming maintenance needs based on flight hours, flight cycles, and calendar days. It automatically identifies when the next service is due to ensure compliance and operational safety.
Why It Matters
- Prevents missed maintenance deadlines
- Improves aircraft safety and regulatory compliance
- Provides clear visibility of upcoming inspections
Technologies Used
Python, Data Processing, Excel Automation, Scheduling Logic
Portfolio Highlight
This project demonstrates how automated maintenance tracking systems can transform inspection data into actionable service schedules, helping aviation teams ensure safety, compliance, and operational efficiency.
Driver Statistics (s)
What:
Read source data for drivers with their stopps, duty hours, etc. and build summary-data and overview for every driver
Used Modules:
xlwings
Parse Contracts
What:
Parse contract-informations, and build a summary overview, input percentages for every employee and detailed contract informations
Used Modules:
xlwings
Create Provisions
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings, docx
Financial Overview
What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
Syndicate Summary
What:
Read persons and provisions and build the output according to the titles, create a summary docx for every person
Used Modules:
xlwings
Check Machine Downtimes
What:
Run the program every few minute and check machine downtimes, register special downtimes and get an hourly statistics output
Used Modules:
xlwings
Create Working Plan
What:
Create a working plan for creating beds and other furniture – select article, parameterize the step and create a working plan including pictures for the individual steps
Used Modules:
xlwings
Student Overview
What:
Create report for different students and show their strenghts, experience, rating, educaton, etc.
Used Modules:
xlwings
Merchants and Syndicates
What:
Create a summary information for merchants and sydicates for a specific time and date
Used Modules:
xlwings
Forecast With Binding
What:
Create forecast for different products, filter according to new products and end of life ignore lists and prepare binding window
Used Modules:
xlwings
Presence Overview
What:
Create presence sheet for differet employees – getting all the start and end times and provide a report-overview with different measures
Used Modules:
xlwings
Machine Operating
What:
Create and update a machine plan for different articles, products on different types of production machines
Used Modules:
xlwings
Sorting Worksheets
What:
Sort data in an excel-sheet – reading a master-list and splitting this to different worksheets, with changed columns
Used Modules:
xlwings
Create Trade Statistics
What:
Create a customized excel-sheet for trade statistics with Trades, Easiness of Getting Along, Rediential vs. Commercial, Contact Person, EMail, Website, etc.
Used Modules:
xlwings
Create List Template
What:
Read some input-information and create a list-template for further use
Used Modules:
xlwings
Process ERP Data (s)
What:
Process some ERP-data and match some additonal information from 2 other system in a final list
Used Modules:
xlwings
Add Summarization With OpenAI / ChatGPT
What:
Add summarization for longer text and update the files
Used Modules:
openai, dotenv, xlwings
Excel automation expert, Excel macros freelancer, automate Excel tasks
Excel Automatisierung Freelancer, Excel Makros erstellen lassen, Excel Aufgaben automatisieren