Power Document Extractor icon

Power Document Extractor

Extract structured blocks from any document format locally

Actions18

Extract ODS

AI-generated

Summary

Extracts data from an OpenDocument Spreadsheet (ODS) file using LibreOffice conversion with fallback to text extraction if conversion fails.

Inputs

  • binaryPropertyName — Name of the binary property containing the ODS file. Defaults to 'data'.
  • structuredLevel — Level of detail in extracted blocks. Options: raw, basic, full. Defaults to full.
  • libreOfficeUrl — Optional URL of a LibreOffice/unoserver for DOC, RTF, PPT, ODG, ODS conversion. If empty, fallback text extraction is used.

Output shape

An n8n item with json.blocks and json.metadata.

blocks: extracted content detail controlled by structuredLevel. metadata.fileName, metadata.fileSize, metadata.fileType='ods', metadata.mimeType='application/vnd.oasis.opendocument.spreadsheet'. If LibreOffice conversion fails, metadata.libreOfficeError is set to 'Conversion failed, used text fallback' and text extraction runs as fallback.

Examples

Example 1: Default execution with ODS file in 'data' binary property.

No parameters changed. Uses default 'data' property, full structuredLevel, and no LibreOffice server URL (fallback text extraction if conversion fails).

Discussion