skills.rest
wearemssatoshi
wearemssatoshiCOMMUNITY
Explore all skills by this author →
𝕏@wearems_satoshiGitHub

sales-data-parser

Parse SVD restaurant daily sales Excel files into unified JSON with monthly summaries.

Updated Aug 27, 2026
Search Tags:#reporting#data aggregation#sales data#json conversion#excel parser#restaurant analytics
One-click install
npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill sales-data-parser
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sales-data-parser
Source: https://github.com/wearemssatoshi/talent-intelligence-calculator2/tree/main/.agent/skills/sales-data-parser
Command: npx skills add https://github.com/wearemssatoshi/talent-intelligence-calculator2 --skill sales-data-parser

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the process of reading and converting complex restaurant sales reports from Excel (.xlsx) files into a standardized JSON format, eliminating manual data entry and analysis.

Core Features & Use Cases

  • Excel to JSON Conversion: Reads SVD restaurant daily sales reports (.xlsx).
  • Data Parsing & Aggregation: Extracts daily sales figures, aggregates them by channel (Lunch, Dinner, Takeout, Banquet, Beer Garden), and generates monthly summaries.
  • Use Case: When you receive the monthly sales report in Excel, use this Skill to instantly convert it into a structured JSON file ready for further analysis or integration with other systems.

Quick Start

Use the sales-data-parser skill to parse the file 'TV2023_3Q.xlsx' and output the results to 'output.json'.

Frequently Asked Questions about sales-data-parser

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I parse restaurant sales data from Excel into JSON?▼

It converts restaurant sales data from Excel into JSON by reading .xlsx daily sales reports, performing dynamic column detection, and aggregating figures by channel. This automates data extraction by handling complex Excel structures and outputting a standardized JSON format.

Can I aggregate daily sales figures by channel like Lunch and Dinner from an Excel report?▼

Yes, you can aggregate daily sales figures by channel from an Excel report. This Skill automatically groups sales data by specific channels like Lunch, Dinner, Takeout, Banquet, and Beer Garden, and generates monthly summaries for consolidated reporting.

How does Excel data parsing handle dynamic columns and validate data integrity?▼

Excel data parsing handles dynamic columns through automatic detection, adapting to varying spreadsheet layouts. It validates data integrity by cross-referencing the parsed daily totals against the original summary rows found within the Excel file.

What is the best way to automate converting monthly sales reports in Excel to a structured format?▼

The best way to automate converting monthly sales reports in Excel to a structured format is using a dedicated parser. This Skill instantly reads .xlsx files and outputs structured JSON, eliminating manual data entry and preparing data for analysis.

Related Skills

Explore More Data & Analytics Skills→
BEIRUXBEIRUX

xlsx

Convert and validate spreadsheet files into dynamic .xlsx workbooks.

Official
Advanced
guihousunguihousun

building-streamlit-dashboards

Create Streamlit dashboards with bordered KPI cards, sparklines, and sidebar filters.

Community
Intermediate
alongor666alongor666
1

vue-component-dev

Develop Vue 3 components with Pinia stores and ECharts charts.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

pie-chart-data-analysis

Analyze multi-sheet Excel and CSV data and generate a downloadable pie-chart report.

Community
Intermediate