afawzy886619888866-cloud/Sierra-Estates / .agents/skills-archive/excel-archive-processor
excel-archive-processor
VerifiedEmpowers Antigravity and OpenClaw agents to inspect, unpack, read, and extract property listings from Excel spreadsheets (.xlsx, .xls, .csv) and compressed archives (.zip, .rar, .7z, .tar.gz).
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 3.6 KB |
SKILL.md
View on GitHub---
name: excel-archive-processor
description: Empowers Antigravity and OpenClaw agents to inspect, unpack, read, and extract property listings from Excel spreadsheets (.xlsx, .xls, .csv) and compressed archives (.zip, .rar, .7z, .tar.gz).
---
# Excel & Archive Processor Skill · Antigravity & OpenClaw
> **Status: Active & Implemented.** Canonical enterprise consolidation is powered by
> [`scripts/enterprise-inventory-consolidator.py`](file:///h:/last/Main/SE-Vercel-deploy-main/scripts/enterprise-inventory-consolidator.py).
> Supports recursive directory scanning, WhatsApp chat extraction, multi-key deduplication (last 7 digits of phone + price + deal), First_Seen/Latest_Update tracking, status dropdown validations, and styled multi-sheet export.
## Purpose
Enables autonomous handling, extraction, and ingestion of real estate data from compressed archives (`.zip`, `.rar`, `.7z`) and spreadsheets (`.xlsx`, `.xls`, `.csv`, `.tsv`).
---
## 1. Archive Handling (.zip, .rar, .7z)
### Unpacking Commands in Windows PowerShell
- **ZIP Archives**:
```powershell
Expand-Archive -Path "path/to/archive.zip" -DestinationPath "path/to/extracted_dir" -Force
```
- **RAR / 7Z Archives** (using built-in Windows Tar or 7-Zip / Python fallback):
```powershell
# Using tar for .tar / .tar.gz / .zip
tar -xf "path/to/archive.zip" -C "path/to/output_dir"
```
- **Python / Node.js programmatic extractor**:
```typescript
import fs from 'node:fs';
import path from 'node:path';
// Scan directory for unpacked .txt, .xlsx, .csv files
```
---
## 2. Excel & CSV Processing (.xlsx, .xls, .csv)
### CLI & Script Automation
Use `npx tsx` scripts or Node.js packages to parse sheets into JSON:
```bash
# Using openclaw-task-runner for master sheets
npx tsx scripts/openclaw-task-runner.ts ingest:mastersheet
```
### Parsing Logic & Schema Mapping
When parsing an Excel workbook or CSV sheet, map column variations into canonical Sierra Estates properties:
| Common Sheet Header | Canonical Property Field | Types / Examples |
| ------------------- | ------------------------ | ---------------- |
| `Compound`, `Cmp`, `المشروع`, `الكمبوند` | `compound` | `Mivida`, `Hyde Park`, `Madinaty` |
| `Price`, `Total Price`, `السعر`, `المطلوب` | `price` | `18500000` (numeric in EGP) |
| `Type`, `Unit Type`, `نوع الوحدة` | `type` | `Standalone Villa`, `Apartment`, `Penthouse` |
| `Area`, `BUA`, `المساحة` | `area_sqm` | `240` (m²) |
| `Bedrooms`, `Beds`, `غرف` | `bedrooms` | `3`, `4`, `5` |
| `Bathrooms`, `Baths`, `حمامات` | `bathrooms` | `2`, `3`, `4` |
| `Finishing`, `تشطيب`, `حالة التشطيب` | `finishing` | `Ultra Super Lux`, `Core & Shell` |
| `Owner / Broker`, `المالك / وسيط`, `الصفة` | `sourceType` | `'owner'` vs `'broker'` |
| `Mode`, `Sale/Rent`, `العملية` | `operation` | `'Sale'` vs `'Rent'` |
| `Phone`, `Mobile`, `Contact`, `رقم الهاتف` | `contact_info` | `+201012345678` |
---
## 3. Workflow for Ingesting Uploaded Archives & Excel Sheets
1. **Detect File Type**: Check if the uploaded or dropped file is `.zip`, `.rar`, `.xlsx`, `.csv`, or `.txt`.
2. **Unpack & Scan**: Unpack into a workspace directory (e.g. `data/unpacked/`).
3. **Parse Content**:
- For `.txt` WhatsApp logs $\rightarrow$ Run `npx tsx scripts/extract-whatsapp-chat.ts <file-path>`
- For `.json` / `.csv` spreadsheets $\rightarrow$ Ingest using `OpenClawAgent.ingestMasterSheet()`
4. **Merge & Reconcile**: Run `npx tsx scripts/merge-inventory-master.ts` to refresh `consolidated-master-inventory.json`.
5. **Verify**: Ensure all units show in the **Admin Portal Listings Hub** (`/admin?view=listings`).
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |