This Craft CMS plugin adds a Twig function to convert Spreadsheets into HTML tables.

• Usage
• Installation
• Requirements
• Changelog
• License

To convert a spreadsheet file into an HTML <table>, pass an craft\elements\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.

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

You can install this plugin from the Plugin Store or with Composer.

Go to the Plugin Store in your project’s Control Panel and search for “Sheets to Tables”. Then click on the “Install” button in its modal window.

Open your terminal and run the following commands:

# go to the project directory
cd /path/to/project

# tell composer to use the plugin
composer require miranj/craft-sheets-to-tables

# tell Craft to install the plugin
./craft plugin/install sheets-to-tables

This plugin requires Craft CMS 3, 4, or 5.

Brought to you by Miranj