Importing from Excel files
Since excel sheets are a widespread form of information collection, Txture offers various ways to import information from this file format:
- Export Excel files to CSV and use CSV importers
- Use the generic Excel importer
- Use the Excel template importer
Exporting Excel to CSV
Please follow the documentation of your spreadsheet software provider to export Excel or similar formats to CSV. Note that most spreadsheet software provides more than one sheet in a file. This is not the case for CSV and thus you might end up with several files when transforming to CSV. Once done with exporting, please following our documentation to import CSV.
Use the generic Excel importer
The generic Excel importer expects a proper laid out table with assets and links in rows and properties or link targets in columns.
Use the Excel template importer
The Excel template importer is a configurable data source that can be set to capture exactly the amount of data required in a data collection process. E.g. those properties that are used in a second level assessment on cloud readiness of an application.
See the documentation on Excel Template Importer for further information.