Open, modify, and generate xlsx, xlsm, csv, and tsv spreadsheets.
npx skills add https://github.com/LiamMarega/astro-portolio --skill xlsx-liammarega
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/LiamMarega/astro-portolio/tree/main/.agents/skills/xlsx Command: npx skills add https://github.com/LiamMarega/astro-portolio --skill xlsx-liammarega
Use this skill to automate the creation, cleaning, and manipulation of spreadsheet data across common formats (xlsx, xlsm, csv, tsv). It enables transforming messy tabular data into well-structured spreadsheets ready for analysis, reporting, or sharing, reducing manual rework and errors.
Create a polished Excel workbook from provided data by applying formulas, formatting, and data-cleaning steps.
High-intent search queries and answers about installing and using this skill.
Automating Excel spreadsheet creation from messy CSV exports involves opening multiple tabular files, cleaning and restructuring the data, applying formulas, and generating a polished xlsx workbook with standardized headers and calculated totals.
Yes, converting between xlsx, csv, and tsv files without losing formatting is possible by processing spreadsheets while preserving data integrity across multiple sheets and maintaining templates during transformations.
Yes, openpyxl supports applying Excel-ready formulas with zero errors by enforcing strict computation logic during spreadsheet modifications, ensuring calculated totals and column operations execute correctly in the output xlsx file.
The best way to merge multiple CSV files into a single Excel workbook is to open each file, standardize headers, perform data cleaning, and write the consolidated data into one xlsx file with applied formatting and computed formulas.
Cleaning and restructuring spreadsheet data for reporting requires opening the input file, performing column operations for consistency, applying formatting and charting, and outputting a well-structured spreadsheet ready for analysis or sharing.
Generating charts and applying formatting in an xlsm file using Python involves utilizing libraries like openpyxl to modify the spreadsheet, apply visual formatting, and insert charts while preserving the file's macro-enabled data integrity.
omardelarosaConvert CSV, TSV, and Excel files into clean .xlsx spreadsheets.
ZanebonoAlterOpen, read, edit, and convert xlsx/xlsm/csv/tsv spreadsheets with Python.
Marwan78888Automate pandas data cleaning, groupby aggregations, and feature engineering on large DataFrames.
miriamdongClean, transform, and format XLSX, CSV, and TSV files with Python.
