Minimax Xlsx

What Is This?

Overview

Minimax Xlsx is a skill designed to handle the full lifecycle of spreadsheet files, including Excel workbooks (.xlsx, .xlsm), comma-separated values (.csv), and tab-separated values (.tsv). It enables users to open existing files, create new ones from scratch, read and extract data, apply formulas, and validate content without losing original formatting. The skill bridges the gap between raw tabular data and structured, professional spreadsheet outputs.

The skill supports formula recalculation, cell formatting, pivot table construction, and financial model assembly. Whether a file needs a single cell updated or an entire workbook rebuilt, Minimax Xlsx handles the operation while preserving styles, merged cells, conditional formatting, and named ranges. This makes it suitable for both lightweight data tasks and complex financial reporting workflows.

Who Should Use This

• Financial analysts who build and maintain Excel-based models, budgets, and forecasts
• Data engineers who process CSV or TSV exports from databases and need structured validation
• Business operations teams that generate recurring reports from tabular data sources
• Developers who automate spreadsheet generation as part of backend pipelines or client deliverables
• Accountants and auditors who need to verify formula integrity and cell references across large workbooks
• Project managers who track milestones, budgets, and resource allocation in spreadsheet format

Why Use It?

Problems It Solves

• Manual spreadsheet editing is error-prone and time-consuming, especially across files with hundreds of rows and complex formula chains
• Converting between file formats such as CSV to XLSX often strips formatting, headers, or data types
• Validating formula accuracy across large workbooks requires systematic checking that is difficult to do by hand
• Creating professional financial models from scratch demands consistent formatting, which is hard to enforce manually
• Reading and extracting specific data from existing Excel files without altering the source structure is a common but fragile task

Core Highlights

• Creates new .xlsx files from scratch with custom headers, data rows, and formula logic
• Reads and parses existing .xlsx, .xlsm, .csv, and .tsv files without corrupting source content
• Edits workbooks with zero format loss, preserving styles, borders, fonts, and merged cells
• Recalculates and validates formulas including SUM, VLOOKUP, IF, INDEX/MATCH, and nested expressions
• Applies professional financial formatting such as currency symbols, percentage notation, and date formats
• Supports pivot table creation and structured table ranges
• Handles multi-sheet workbooks with cross-sheet references
• Converts between supported file formats while maintaining data integrity

How to Use It?

Basic Usage

To create a new spreadsheet with headers and data, provide a clear instruction describing the columns, data types, and any formulas required.

Create an xlsx file with columns: Date, Revenue, Expenses, Net Profit.
Add 6 rows of sample data and include a SUM formula in the totals row.
Format the Revenue and Expenses columns as USD currency.

To read an existing file, upload the file and specify what information to extract.

Read the uploaded sales_data.xlsx and return the total revenue
grouped by region from the "Q3 Sales" sheet.

Specific Scenarios

Scenario 1: Validating a Financial Model Upload a workbook and request a formula audit. The skill checks each formula cell, confirms references are not broken, and flags any circular dependencies or mismatched ranges.

Scenario 2: Converting CSV to Formatted XLSX Provide a raw .csv export from a database. The skill converts it to .xlsx, applies column headers, sets appropriate data types, and adds table formatting for readability.

Real-World Examples

• A finance team uploads a quarterly budget template and requests that actuals be filled in from a separate CSV export, with variance formulas added automatically.
• A developer needs a client-ready report generated from JSON data, output as a formatted .xlsx with a summary sheet and a detail sheet.
• An auditor uploads a complex workbook and asks the skill to list all cells containing hardcoded values where formulas are expected.

When to Use It?

Use Cases

• Building financial models, budgets, and forecasting templates
• Generating automated reports from raw data exports
• Validating formula accuracy in audit or compliance workflows
• Converting CSV or TSV files into structured, formatted workbooks
• Creating data entry templates with validation rules and dropdown lists
• Analyzing tabular datasets to extract summaries, totals, or trends
• Producing client-facing deliverables in professional spreadsheet format
• Maintaining recurring operational reports with consistent structure

Important Notes

Requirements

• Input files must be in a supported format: .xlsx, .xlsm, .csv, or .tsv
• For editing tasks, the original file must be accessible and not password-protected
• Formula validation requires that all referenced sheets and named ranges are present within the uploaded workbook