Exporting data to XLS / XLSX
When you export data from Planon to Microsoft Excel, Planon converts its internal data formats to corresponding Excel cell formats. This ensures that exported values can be used directly in Excel—for example, for calculations—without requiring additional formatting.
Mapping between Planon and Excel
Planon field type | Excel cell format | Remark |
|---|
Numbers | General | The Planon mask is not applied. The value is exported in its raw internal format, and Excel determines how the value is displayed. |
Dates/date-time/time | Custom | The Planon mask is applied. The value is exported already formatted according to the Planon mask and displayed in Excel exactly as formatted. |
Additional behavior and limitations
• Time values
Planon and Excel store time values differently. In Planon, time is stored as a numeric value with a different zero reference than Excel. As a result, comparing time values between Planon and Excel may produce unexpected results.
• Totals and group totals
Totals and group totals follow the same formatting rules as the underlying field type.
• Group headers
Group headers are not formatted during export.
• Expressions
◦ If a Planon mask is applied and the result is a number, date, date-time, or time, the value is exported and formatted according to the Planon mask.
◦ If no Planon mask is applied, the result is exported using the Planon Java mask. This mask may differ from the Excel format, which can cause the value to appear differently in Excel than in Planon.
• Separators
Date, decimal, and thousand separators are determined by the Excel user locale, not by Planon.