# Crosstab Report export to excel

**URL:** <https://forum.inductiveautomation.com/t/crosstab-report-export-to-excel/56309>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [February 18, 2022, 4:23pm UTC](https://forum.inductiveautomation.com/t/crosstab-report-export-to-excel/56309 "2022-02-18T16:23:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![monc](https://avatars.discourse-cdn.com/v4/letter/m/48db29/32.png) [@monc](https://forum.inductiveautomation.com/u/monc)\
**Post date:** [February 18, 2022, 4:23pm UTC](https://forum.inductiveautomation.com/t/crosstab-report-export-to-excel/56309/1 "2022-02-18T16:23:04Z")

</div>

Hello,

I’m creating a report using the Crosstab Component and I would like to export it in excel (xlsx or xls) format.

The report is ok on preview and when exported in PDF but have a problem with formatting when exported in Excel as you can see below.

(PDF Format)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f6797b5df8a49d4bb7ee44787961ab03824e7cda.png)

(excel format)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/9/397a2f9784ace5d6dd764e7b08a841c4e7ee5bdd.png)

Any tips on how I can format the crosstab so it looks good when exported in excel?

Thanks and Regards,  
Mon

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [February 18, 2022, 5:05pm UTC](https://forum.inductiveautomation.com/t/crosstab-report-export-to-excel/56309/2 "2022-02-18T17:05:28Z")

</div>

That’s kind of the nature of the beast. Reports that don’t have a simple table structure get mangled when you export them to formats like excel or csv. Your left most column is the likely culprit, if you could simply repeat those values for each line it **might** come out better.