Expand my Community achievements bar.

Split multi-tabbed excel into CSVs in Workfront

Avatar

Level 1

I have a deliverables spreadsheet for my creatives that split across multiple tabs in Excel (one tab for the social assets, one for the CRM assets etc...). Anyone know if it's possible to split each tab of that Excel into a CSV using Fusion so I can ingest it into Workfront? 

2 Replies

Avatar

Community Advisor

JonathanMa1, there isn't a way with the current CSV module to split tabs, that mod just looks at the first tab and its headers and you can parse that.  There is a 365 Excel module but we're not able to connect and use that in our environment due to security lockdowns so I don't know if it has the ability to see tabs and data and allow you parse.  Sorry this wasn't overly helpful, me someone that has used the Excel mod as additional insight to help.

Avatar

Level 10

Hi Jonathan,

 

We are not having setup an Office365-Connector either, but having a look onto the available modules, Retrieve Data looks promising.

 

Regards

Lars