Excel and Google Sheets Compatibility¶
Use a recent version of Microsoft Excel when working with Spreadsheet reports, and when creating custom reports with templates, you should use the same version of Excel to create and view the template.
- Check the System Requirements document for the version of Excel that aPriori has tested Spreadsheet Reports against.
- Except for the Component Sourcing report, all aPriori report templates are
.xlsxfiles. - Template-based reports work properly when the OS running the report supports the same version of Excel on which the spreadsheet report template is based
It is possible to view aPriori Spreadsheet reports in Google Sheets, however, you may need to unhide tabs that are hidden in the reports. If you open a report in Google Sheets and the display looks incomplete or incorrect, try the following workaround:
- Open the report in Excel.
- Right-click on the tabs and unhide them.
- Import into Google Docs