What file formats can this skill convert spreadsheets to?

This skill can convert spreadsheets to XLSX, CSV, PDF, and HTML formats. It also supports conversion from XLSX to ODS (OpenDocument Spreadsheet) format.

What Python libraries does this skill support for spreadsheet manipulation?

The skill supports Python scripting through the UNO (Universal Network Objects) API, the ezodf library for simplified ODS handling, odfpy for ODF manipulation, and Pandas for data analysis tasks.

Can this skill import data from external sources like databases or APIs?

Yes, the skill includes database connectivity for data import and export workflows, and can accept data sources from CSV files, databases, and APIs as inputs.

Skill

Automate LibreOffice Calc Spreadsheet Operations

Name: LibreOffice Calc
Availability: OnlineOnly
Author: Antigravity

A LibreOffice Calc skill for creating, converting, and automating ODS spreadsheets via soffice CLI and UNO/Python scripting.

Get skill

Works with libreoffice

Antigravity

Own this? Claim it

Spark score

out of 100

Updated 4 days ago

Version 15.5.1

Add to Favorites

Why it matters

Leverage LibreOffice Calc for robust spreadsheet automation, including creation, editing, complex data processing, and format conversion. This skill streamlines repetitive tasks and enhances data analysis capabilities.

Outcomes

What it gets done

Create and manage ODS spreadsheets from scratch or templates.

Convert between ODS, XLSX, CSV, and PDF formats.

Automate formula calculations, data import/export, and batch processing.

Generate reports, dashboards, and perform data analysis with pivot tables.

Install

Add it to your toolbox

Run in your project directory:

curl -fsSL https://spark.entire.vc/get/ag-calc | bash

Overview

LibreOffice Calc

A LibreOffice Calc skill for creating, converting, and automating ODS spreadsheets via the soffice CLI and UNO/Python scripting. Use it for ODS spreadsheet creation, conversion, and data automation, especially batch operations across many files.

What it does

This is a LibreOffice Calc skill for creating, editing, converting, and automating spreadsheet workflows using the native ODS (OpenDocument Spreadsheet) format. Its five capability areas: spreadsheet creation (from scratch, from templates, data entry forms, dashboards), format conversion (ODS to XLSX/CSV/PDF/HTML and back, plus batch conversion), data automation (formula automation, imports from CSV/database/APIs, batch processing), data analysis (pivot tables, statistical functions, validation, conditional formatting), and integration (command-line automation via soffice, Python scripting with UNO, database connectivity). Format conversion is driven entirely from the command line:

### ODS to XLSX
soffice --headless --convert-to xlsx spreadsheet.ods

### ODS to CSV
soffice --headless --convert-to csv spreadsheet.ods

### ODS to PDF
soffice --headless --convert-to pdf spreadsheet.ods

### XLSX to ODS
soffice --headless --convert-to ods spreadsheet.xlsx

### Batch convert
for file in *.ods; do
    soffice --headless --convert-to xlsx "$file"
done

When to use - and when NOT to

Use this skill when creating new spreadsheets in ODS format, converting between ODS/XLSX/CSV/PDF, automating data processing and analysis, creating formulas/charts/pivot tables, or batch-processing spreadsheet operations. Spreadsheets can be built three ways: the plain soffice --calc template.ods command line, Python via the UNO bridge (connecting to a running LibreOffice instance over a socket, then setting cell values and formulas programmatically), or the simpler ezodf library for basic cell writes. Best practices named: use named ranges for clarity, document complex formulas, use data validation for input control, template recurring reports, store ODS source files in version control, and test conversions thoroughly. If the socket connection fails, the fix is to kill any stray soffice.bin process and restart it in headless, socket-accepting mode.

Inputs and outputs

Input is spreadsheet data, templates, or existing files in ODS, XLSX, XLS, CSV, DBF, or HTML format; output is a created or converted spreadsheet (ODS, XLSX, XLS, CSV, PDF, or HTML), with formulas, pivot tables, or conditional formatting applied as needed. Python automation relies on ezodf for straightforward ODS handling, odfpy for lower-level ODF manipulation, or pandas for the data-analysis side.

Who it's for

Developers and analysts automating spreadsheet creation, conversion, or data processing who want command-line and Python-scriptable control over ODS files rather than manual spreadsheet editing, especially for batch operations across many files. The skill sits alongside related LibreOffice-suite skills for Writer, Impress, Draw, and Base documents, plus a dedicated xlsx-official skill and a general workflow-automation skill, so a task spanning multiple document types or a broader automation pipeline may need more than this skill alone.

FAQ

Common questions

Discussion