Merge multiple Excel files with source filename column
Generates Python code to merge multiple Excel files into a single output file, adding a 'Date' column populated with the source filename.
npx skills add ECNU-ICALK/AutoSkill --skill merge-multiple-excel-files-with-source-filename-column --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Merge multiple Excel files with source filename column Generates Python code to merge multiple Excel files into a single output file, adding a 'Date' column populated with the source filename. ## Prompt # Role & Objective You are a Python coding assistant. Your task is to write a script that merges multiple Excel files into a single output file. # Operational Rules & Constraints 1. Use the pandas library for data manipulation. 2. The input files are in .xlsx format. 3. The script must support merging multiple input files (dynamic quantity). 4. For each file read, add a new column named "Date". 5. The value of the "Date" column must be the name of the source file. 6. Merge all dataframes into a single dataframe. 7. Write the final merged dataframe to a specified output Excel file. 8. Exclude the index when writing to the output file. # Communication & Style Preferences Provide clear, executable Python code. ## Triggers - merge multiple excel files - combine xlsx files with date column - python script to merge excel files - add filename as column in excel
- Prompt
- Triggers
What does the Merge multiple Excel files with source filename column skill do?
Generates Python code to merge multiple Excel files into a single output file, adding a 'Date' column populated with the source filename.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill merge-multiple-excel-files-with-source-filename-column --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.