Speed of importing data from Excel file vs. importing data from dataset (EasyMorph format)

Hello,

I was wondering how much faster is it to import a dataset file from importing an Excel spreadsheet, for the same amount of data. I have an iterating module that includes 2 “import from excel spreadsheet” actions (so these actions are being repeated many times). If I were to substitute these actions for a “import from dataset”, would I save time in each iteration?

Thanks very much,

Roberto

Hello Roberto,

Import from dataset is always faster than import from Excel. It may be up to 20 times faster depending on the imported data and file type (XLS or XLSX). So repeated Import from Excel should be definitely replaced with Import from DSET if your Excel files have more than just a few rows.

1 Like