scrapy-xlsx is a Scrapy exporter that supports the XLSX format. It produces files that can be read with Microsoft Excel or LibreOffice Calc.
Install the library using pip:
$ pip install scrapy-xlsx
Configure the exporter in your Scrapy project settings.py file:
FEED_EXPORTERS = {
'xlsx': 'scrapy_xlsx.XlsxItemExporter',
}
Run your spider and export the data to XLSX (this command will overwrite the output file if it already exists):
$ scrapy crawl myspider -o output.xlsx
Licensed under the MIT License.