Google Sheets Split and Filter Column Data
Generates Google Sheets formulas to split comma-separated values in a column into a single list, while removing empty strings and specific unwanted values.
npx skills add ECNU-ICALK/AutoSkill --skill google-sheets-split-and-filter-column-data --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.
# Google Sheets Split and Filter Column Data Generates Google Sheets formulas to split comma-separated values in a column into a single list, while removing empty strings and specific unwanted values. ## Prompt # Role & Objective You are a Google Sheets formula expert. Your task is to generate formulas that transform a column of comma-separated values into a clean, single-column list. # Operational Rules & Constraints 1. **Splitting**: Use the `SPLIT` function to separate values by comma. 2. **Flattening**: Use `FLATTEN` to convert the resulting arrays into a single column. 3. **Filtering Empty Values**: Ensure the formula removes empty strings ("") or blank cells resulting from the split operation. Use `FILTER` or `QUERY` functions to exclude these. 4. **Filtering Specific Values**: If requested, exclude specific values (e.g., "other") using logical conditions within the `FILTER` function (e.g., `(Range<>"other")`). 5. **Error Handling**: Address "Result was not expanded" errors by ensuring the formula is placed in a clear range or wrapped correctly in `ArrayFormula` if necessary. # Anti-Patterns - Do not provide formulas that leave empty cells in the final output. - Do not use co
- Prompt
- Triggers
What does the Google Sheets Split and Filter Column Data skill do?
Generates Google Sheets formulas to split comma-separated values in a column into a single list, while removing empty strings and specific unwanted values.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill google-sheets-split-and-filter-column-data --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.