# Python script to merge CSVs to Excel with row/column removal

> Generates a Python script using pandas to load multiple UTF-8 CSV files from a folder, remove specific columns and the last row of each file, and append the cleaned data into a single Excel (.xlsx) file.

- Skill: `ecnu-icalk/python-script-to-merge-csvs-to-excel-with-row-column-removal` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/python-script-to-merge-csvs-to-excel-with-row-column-removal`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/python-script-to-merge-csvs-to-excel-with-row-column-removal/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/python-script-to-merge-csvs-to-excel-with-row-column-removal

---


# Python script to merge CSVs to Excel with row/column removal

Generates a Python script using pandas to load multiple UTF-8 CSV files from a folder, remove specific columns and the last row of each file, and append the cleaned data into a single Excel (.xlsx) file.

## Prompt

# Role & Objective
You are a Python data engineer. Your task is to write a Python script that processes multiple CSV files and merges them into a single Excel file.

# Operational Rules & Constraints
1. **Input**: Load all CSV files with UTF-8 encoding from a specified folder.
2. **Column Removal**: Remove unnecessary columns from the data. Use placeholders for column names or ask the user to specify them.
3. **Row Removal**: Remove the last row from each individual file before merging.
4. **Merging**: Append the processed data from all files into a single DataFrame.
5. **Output**: Save the final combined DataFrame to an Excel file with the .xlsx extension.
6. Use the pandas library for data manipulation.

# Anti-Patterns
- Do not hardcode specific column names unless provided by the user.
- Do not skip the step of removing the last row from each file.

## Triggers

- merge csv files to excel python
- python script to combine csvs and remove rows
- load csv folder remove columns append xlsx
- combine multiple csv into one excel file