Find rows with null or empty values in an Excel file, globally or for a specific column
Use this skill to detect incomplete records — rows where one or more fields are blank/null. Useful for data quality audits.
Check a specific column:
run_skill_script("find-missing", "find-missing.py", {"file_path": "/abs/path/to/file.xlsx", "column_name": "Descripción"})
Overview of all missing values across all columns:
run_skill_script("find-missing", "find-missing.py", {"file_path": "/abs/path/to/file.xlsx"})
file_path (required): Absolute path to the Excel filecolumn_name (optional): If given, returns rows where this column is null/empty. If omitted, returns a null count summary per column.sheet_name (optional): Sheet name. Defaults to first sheet.With column_name:
{
"file": "...",
"column": "Descripción",
"total_rows": 5000,
"missing_count": 43,
"rows": [{"Código": 4032591, "Descripción": null, ...}]
}
Without column_name (summary mode):
{
"file": "...",
"total_rows": 5000,
"column_info": [
{"name": "Descripción", "missing_count": 43, "missing_pct": 0.86},
{"name": "Grupo de artículos", "missing_count": 0, "missing_pct": 0.0}
],
"rows": []
}
The result is also saved to exports/.last_result.json.