Uses the Xlsx package to convert excel spreadsheets to json data files and saves the output to the eleventy _data directory
$npm install eleventy-plugin-xlsx --save-dev
The default directory for excel files is /_xlsx. Any excel workbooks saved the /_xlsx directory will be parsed, converted to JSON, and saved to /_data/xlsx. These default directories can be overridden in the options array passed to the plugin.
const parseExcelData = require("eleventy-plugin-xlsx");
// Default paths shown
module.exports = function (eleventyConfig) {
eleventyConfig.addPlugin(parseExcelData, {
xlsxPath: "./_xlsx",
dataPath: "./_data/xlsx"
});
}