Sheets to Tables

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

Contents

• Usage
• Installation
• Requirements
• Changelog
• License

Usage

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.

Supported file formats

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

Installation

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

From the Plugin Store

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.

Using Composer

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

Requirements

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

---

Brought to you by Miranj