Can this skill handle large datasets?

Yes, it includes streaming scripts designed to process large volumes of data efficiently without exceeding system memory limits.

Does the Excel export support multiple sheets?

Yes, the Excel utility allows you to map different data objects to specific named sheets within a single .xlsx file for structured reporting.

Can I integrate this with database tools?

Absolutely. This skill is optimized to take query results from tools like BigQuery or SQL and pipe them directly into your preferred export format.

How do I fix character encoding issues in Excel?

You can use the --bom flag during CSV export to include a Byte Order Mark, which ensures Excel correctly displays Japanese and other non-ASCII characters.

Data Analyst Export

Name: Data Analyst Export
Author: takemi-ohama

bytakemi-ohama

데이터 과학 및 ML

Exports data analysis results into multiple professional formats including CSV, Excel, JSON, and Markdown with customized formatting.

소개

The Data Analyst Export skill provides a robust suite of utilities for transforming raw data and query results into production-ready files. It automates the complex aspects of data presentation, such as handling UTF-8 BOM for Excel compatibility, generating multi-sheet workbooks, and creating formatted Markdown tables for documentation. Whether you are extracting insights from a database or summarizing local data, this skill ensures your outputs are structured, readable, and ready for stakeholders.

주요 기능

Multi-format support for CSV, JSON, Excel (.xlsx), and Markdown tables
Streaming processing for exporting large datasets without memory errors
Global compatibility via UTF-8 BOM and customizable delimiters
0 GitHub stars
Advanced Excel options including multi-sheet support and cell formatting
Automatic header generation and data type alignment

사용 사례

Generating formatted monthly sales reports in Excel for business teams
Converting SQL query results into CSV files for data portability
Automating the insertion of live data tables into GitHub README files

소개

주요 기능

Multi-format support for CSV, JSON, Excel (.xlsx), and Markdown tables
Streaming processing for exporting large datasets without memory errors
Global compatibility via UTF-8 BOM and customizable delimiters
0 GitHub stars
Advanced Excel options including multi-sheet support and cell formatting
Automatic header generation and data type alignment

사용 사례

Generating formatted monthly sales reports in Excel for business teams
Converting SQL query results into CSV files for data portability
Automating the insertion of live data tables into GitHub README files