[RFE] Enhanced file imports

[rromannissen]

CSV has some limitations in its capabilities, and it's not the most widespread spreadsheet format used by organizations worldwide. Even though the contents of a spreadsheet in other formats can be adapted to fit the CSV template that Konveyor uses, the process can be cumbersome especially when dealing with dependencies at scale, since Record Types are not the most practical approach.

To solve this, the proposal would be to include support for Excel (extensions .xlsx and .xls) and OpenDocument Format (extension .ods) spreadsheets. This would be aligned with the most used tools in the market, while easing the declaration of different record types (applications, dependencies and potentially more in the future) through the usage of dedicated tabs.

[Shevijacobson]

@rromannissen I wanted to clarify the scope of this issue regarding support for additional spreadsheet formats. From what I understand, the proposal suggests extending support to Excel (.xlsx, .xls) and OpenDocument Format (.ods), alongside CSV, to simplify working with large datasets and dependencies.

Could you please confirm whether the intention is to:

1.Support these new formats with a single sheet structure that mirrors the current CSV template—containing all data (Applications, Dependencies, etc.) in one unified sheet, but in a different file format.
Or, alternatively:
2. Leverage the unique capabilities of these formats to use multiple tabs, where each tab can represent different record types (e.g., one tab for Applications, another for Dependencies, etc.), rather than consolidating everything into one sheet.

Implementing the second approach would indeed streamline data organization but would differ in structure from the CSV template. It would be helpful to know which of these approaches aligns with the intended functionality.

Thank you!