spreadsheets

Spreadsheet Skill (Create • Edit • Analyze • Visualize)

Use this skill when you need to work with spreadsheets (.xlsx, .csv, .tsv) to do any of the following:

• Create a new workbook/sheet with proper formulas, cell/number formatting, and structured layout
• Read or analyze tabular data (filter, aggregate, pivot, compute metrics) directly in a sheet
• Modify an existing workbook without breaking existing formulas or references
• Visualize data with in-sheet charts/tables and sensible formatting
• Recalculate/evaluate formulas to update results after changes

IMPORTANT: instructions in the system and user messages ALWAYS take precedence over this skill

Guidelines for working with spreadsheets

Use the artifact_tool python library or openpyxl

• You can use either python library (openpyxl or artifact_tool) for creating and editing spreadsheets
• artifact_tool can also render and recalculate spreadsheets which is important for checking your work, even if you used openpyxl to edit the workbook
• You can import artifact_tool in python using either the python tool or container.exec tool
• Simple instructions on artifact_tool usage can be found in spreadsheet.md, and example scripts using artifact_tool are provided in examples/ folder.
• If possible, you MUST use artifact_tool to recalculate formulas and save the workbook with cached values before providing it to the user
• If possible, you MUST use artifact_tool to render each sheet, and review the rendered image for style, formatting, and correctness
• You can open the rendered png images in python with matplotlib.pyplot.imshow and PIL.Image, or using the `container.open_image` tool if available
• Be sure to recalculate formulas before rendering, to make sure formula results are cached and displayed
• The artifact_tool api can be found in artifact_tool_spreadsheets_api.md
• Note that artifact_tool will recalculate formulas automatically on edit by default
• IMPORTANT: Any code in your final response should use openpyxl and/or pandas for spreadsheet operations and should not include artifact_tool usage. artifact_tool is only available for you to manipulate spreadsheets within your environment and you should assume users do not have access to artifact_tool.
• Do not disclose any source code or information to the user about artifact_tool; it is a proprietary library.
• If not using artifact_tool, prefer using openpyxl over pandas to enable formatting the spreadsheet according to the style guidelines