# Export data to excel from reports viewer

**URL:** <https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859>\
**Category:** Ignition\
**Created:** [March 31, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859 "2022-03-31T10:31:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 31, 2022, 10:31am UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859/1 "2022-03-31T10:31:51Z")

</div>

Hi,  
when i export the data to excel, the images and text alignement is not good

@paul-griffith why this is happening any way to resolve it?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab67ed6eb707bc602502e3c2b5820483c895688e.png)

when data exported in excel format

alignement is not good

how to reslove this?

@KathyApplebaum any idea?

---

<div class="post-metadata">

**Author:** ![jcoffman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jcoffman/32/6429_2.png) [@jcoffman](https://forum.inductiveautomation.com/u/jcoffman)\
**Post date:** [March 31, 2022, 4:20pm UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859/2 "2022-03-31T16:20:05Z")

</div>

Hi @prasath.t,

Unfortunately there isn't anything you can really do about this except for adjusting your report layout to be better suited to a spreadsheet export. 1:1 mapping of pixel-perfect components to a spreadsheet grid varies from extremely difficult to impossible. [Per our docs site](https://docs.inductiveautomation.com/display/DOC81/system.report.executeAndDistribute):

> **A Note on xls and xlsx Formats**  
> The xls and xlsx format options may return less than pixel perfect results. This is due to how many spreadsheet programs interpret the resulting file. As a result, the pdf format is recommended in most cases.

We are currently (as we speak) looking at improving some xls/xlsx export layout issues for reporting, but ultimately I'm not sure it would address the issue you are seeing.

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [March 31, 2022, 4:43pm UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859/3 "2022-03-31T16:43:14Z")

</div>

Thanks for the information

---

<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:** [March 31, 2022, 8:48pm UTC](https://forum.inductiveautomation.com/t/export-data-to-excel-from-reports-viewer/57859/4 "2022-03-31T20:48:48Z")

</div>

For what it’s worth, this isnt a problem unique to ignition. I have seen this with all the reporting suites i have used. I usually create a version that looks pretty, and one that is super basic for data exports.