LibreOffice XLSX to PDF Report

Convert Excel workbooks to multi-page PDF reports via LibreOffice and merge batch outputs

Convert spreadsheets to printable PDF reports using LibreOffice CLI.

Highlights:

  • Supports .xls and .xlsx
  • Multi-page report output from workbook print layout
  • Batch conversion with merged PDF output

Example Results

2 examples

Batch Workbook Report PDF

Convert two XLSX files and merge into a single PDF report

libreoffice-xlsx-to-pdf-report-example1.pdf View File
View input parameters
{ "sourceFiles": [ "/Users/quyue/www/elysia-tools/public/samples/xlsx/basic.xlsx", "/Users/quyue/www/elysia-tools/public/samples/xlsx/data.xlsx" ], "singlePageSheets": false, "mergeReports": true }

Single Workbook One-Page Sheets

Export one workbook with SinglePageSheets enabled

libreoffice-xlsx-to-pdf-report-example2.pdf View File
View input parameters
{ "sourceFiles": [ "/Users/quyue/www/elysia-tools/public/samples/xlsx/financial.xlsx" ], "singlePageSheets": true, "mergeReports": false }

Click to upload files or drag and drop files here

Maximum file size: 300MB Maximum files: 30
Supported formats: application/vnd.ms-excel, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Key Facts

Category
Documents & PDF
Input Types
file, checkbox
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The LibreOffice XLSX to PDF Report tool provides a reliable way to convert your Excel workbooks into professional, printable PDF documents using the LibreOffice engine. It respects your existing print layouts and offers flexible options to merge multiple files into a single report or format individual sheets for streamlined document sharing.

When to Use

  • When you need to convert Excel workbooks into standardized, non-editable PDF reports for distribution.
  • When you have multiple spreadsheet files that need to be combined into a single, cohesive PDF document.
  • When you want to ensure your Excel print settings, such as page breaks and margins, are accurately preserved in the final PDF output.

How It Works

  • Upload your .xls or .xlsx files using the file selector.
  • Toggle 'Single Page Per Sheet' if you want to force specific layout constraints on your output.
  • Enable 'Merge Output PDF' to combine multiple uploaded workbooks into one single file.
  • Click the convert button to process your files and download the generated PDF report.

Use Cases

Generating monthly financial statements from multiple department spreadsheets.
Creating a consolidated project status report from various team tracking workbooks.
Converting complex data tables into printable, read-only PDF documentation for stakeholders.

Examples

1. Batch Financial Reporting

Financial Analyst
Background
The analyst has two separate quarterly financial workbooks that need to be presented to the board as a single document.
Problem
Manually exporting and merging PDFs is tedious and prone to formatting errors.
How to Use
Upload both XLSX files and ensure the 'Merge Output PDF' option is checked.
Example Config
mergeReports: true, singlePageSheets: false
Outcome
A single, professional PDF file containing all financial data from both workbooks, ready for distribution.

2. Individual Sheet Export

Project Manager
Background
A project manager needs to share a specific dashboard sheet from a large workbook without including extraneous data tabs.
Problem
Standard exports often include unnecessary sheets or break the layout.
How to Use
Upload the workbook and enable 'Single Page Per Sheet' to ensure clean, isolated page formatting.
Example Config
mergeReports: false, singlePageSheets: true
Outcome
A clean PDF where each sheet is formatted as a single page, perfect for quick review.

Try with Samples

xml, xlsx, xls

Related Hubs

FAQ

Which file formats are supported?

This tool supports standard Excel formats, specifically .xls and .xlsx files.

Can I merge multiple Excel files into one PDF?

Yes, by enabling the 'Merge Output PDF' option, the tool will combine all uploaded workbooks into a single PDF document.

Does the tool respect my Excel print settings?

Yes, the conversion process utilizes LibreOffice to interpret your workbook's print layout, including page breaks and defined print areas.

What is the 'Single Page Per Sheet' option?

This option adjusts the output to ensure each sheet within your workbook is rendered as a distinct page in the resulting PDF.

Is there a limit to the number of files I can upload?

You can upload up to 30 files at once, provided the total size does not exceed 300MB.

API Documentation

Request Endpoint

POST /en/api/tools/libreoffice-xlsx-to-pdf-report

Request Parameters

Parameter Name Type Required Description
sourceFiles file (Upload required) Yes -
singlePageSheets checkbox No -
mergeReports checkbox No -

File type parameters need to be uploaded first via POST /upload/libreoffice-xlsx-to-pdf-report to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "mcpServers": {
    "elysiatools-libreoffice-xlsx-to-pdf-report": {
      "name": "libreoffice-xlsx-to-pdf-report",
      "description": "Convert Excel workbooks to multi-page PDF reports via LibreOffice and merge batch outputs",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=libreoffice-xlsx-to-pdf-report",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]