Home/Integrations/SoftAdvice apps/SoftAdvice PowerPack/Excel Reader
SoftAdvice PowerPackFrom spreadsheet to M-Files, without retyping
The PowerPack Excel Reader reads values from Excel files into metadata, and creates or updates objects and value lists in bulk from Excel or CSV. Rows that fail are reported back in the file itself.
See the functions Discuss PowerPack
Illustrative example
In short
The SoftAdvice PowerPack Excel Reader brings Excel data into M-Files. The Property Extractor reads cells or named ranges from xls, xlsx, xlsm or xlsb files into the metadata of a document at check-in. The Object Importer creates or updates objects from Excel or CSV rows in the background and writes an errors sheet back into the file. The Value List Importer fills value lists from CSV or Excel. The Excel Reader is part of the PowerPack Full edition.
Three ways to bring Excel into M-Files
Values from the spreadsheet on the metadata card
Store an Excel file in M-Files and chosen cells or named ranges are read into its properties every time the file changes.
- Works with xls, xlsx, xlsm and xlsb
- Value list items matched by ID, name or display ID, and created when allowed
Illustrative example
Hundreds of objects from one file
Each row of an Excel or CSV file becomes a new or updated object, such as customers, projects or contracts. The import starts when the file is created or reaches a workflow state, and runs as a background task.
- Columns filled with fixed values, cell values or matched objects
- Updates by external or internal ID
- Files attached from local paths, network folders, SFTP or FTPS
- An errors sheet written back into the Excel file
Illustrative example
Value lists filled in one go
Import value list items from CSV or Excel, including the owner item for sub-lists, instead of adding them one by one.
Illustrative example
Questions about the Excel Reader
Which edition do we need?
The Excel Reader module is part of the PowerPack Full edition.
What happens with rows that cannot be imported?
They are listed on an errors sheet that PowerPack writes back into the Excel file, so you can correct them and import again.
Can we update existing objects?
Yes. The Object Importer matches rows on an external or internal ID and updates the object instead of creating a new one.
Do imports slow down M-Files?
Imports run as a background task on the server, in batches, so users keep working.
Which spreadsheet would you like in M-Files?
Send us an example and we show how the Excel Reader brings it in.