Split multi-tabbed excel into CSVs in Workfront | Community
Skip to main content
J
JonathanMa1
December 5, 2023
Question

Split multi-tabbed excel into CSVs in Workfront

  • December 5, 2023
  • 2 replies
  • 514 views

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Kurt_Jones
Community Advisor
Kurt_JonesCommunity Advisor
Community Advisor
December 5, 2023

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.

If my response answered your question, please mark it answered, so others can find the answer
lgaertner
lgaertner
Level 9
December 6, 2023

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

Terms & ConditionsAccessibility statement

Loading footer...