Parse Excel to CDT

I would like to add my experiences here, since I just ran into the same issue. In most of my excel templates I use a hidden sheet that replicates the first sheet where we can control column formatting, as user pasted text may be auto-formatted by Excel. I run macros on save to move values only from the first user-facing sheet to a hidden second sheet with defined formats, the excel import then utilizes sheet #2. Only down side so far is that users have to click the 'Enable Macros' button before saving their file prior to upload. For this notation issue, I modified the macros to add a "^" character to the beginning of the text, which is parsed out in the workflow via expression rule, before saving to the primary CDT. Works great!

I would like to add my experiences here, since I just ran into the same issue. In most of my excel templates I use a hidden sheet that replicates the first sheet where we can control column formatting, as user pasted text may be auto-formatted by Excel. I run macros on save to move values only from the first user-facing sheet to a hidden second sheet with defined formats, the excel import then utilizes sheet #2. Only down side so far is that users have to click the 'Enable Macros' button before saving their file prior to upload. For this notation issue, I modified the macros to add a "^" character to the beginning of the text, which is parsed out in the workflow via expression rule, before saving to the primary CDT. Works great!