Sheets to Tables

To convert a spreadsheet file into an HTML <table>, pass an Asset object as an argument to the sheetstotables(asset) Twig function.

{% set spreadsheet = craft.assets.kind('excel').one() %}

{{ sheetstotables(spreadsheet) }}

If the spreadsheet file contains multiple sheets, only the contents of the first sheet will be rendered as a table.

Supported file formats

• CSV
• Excel (.xlsx, .xls)
• Open Document Format (.ods)
• Other formats supported by PhpSpreadsheet