xlsx

Automate spreadsheet creation, editing, and analysis to streamline data workflows in Excel-like files. It applies formulas and formatting to build consistent financial models, reports, and ad hoc analyses across .xlsx, .xlsm, .csv, and .tsv formats.

Yes, you can modify existing spreadsheets while preserving formulas and established patterns. This ensures data cleanup and reporting workflows maintain their original logic without breaking established financial models or data structures.

Recalculate formulas using a dedicated recalculation workflow to keep outputs up-to-date after edits. This built-in recalc.py tool ensures your spreadsheet analysis and reporting reflect the latest data changes automatically.

Yes, spreadsheet automation supports reading, analyzing, and validating data from .xlsx, .xlsm, .csv, and .tsv files. You can perform data analysis and visualization directly within these formats with reproducible results.

Perform data analysis and visualization directly within spreadsheets to reduce manual effort and ensure consistent results. This approach handles data cleanup, reporting, and ad hoc analyses across complex workbook workflows.

Formulas may not update automatically after modifying workbook data. Use the dedicated formula-recalculation workflow to ensure up-to-date results, keeping your spreadsheet analysis and reporting outputs accurate after edits.