Using Fusion To Convert A Spreadsheet to CSV | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
March 6, 2025
Solved

Using Fusion To Convert A Spreadsheet to CSV

  • March 6, 2025
  • 1 reply
  • 423 views

Hello,

 

I am trying to build a scenario that will watch for new files being uploaded to a folder. The files being uploaded will be excel spreadsheets and the some of the data from the files needs to be sent to fields on the projects custom form.

 

Can you use Fusion to accomplish this? I am at a loss on how to

1. Configure a trigger to watch for new files being uploaded to specific project file folders

2. Convert a spreadsheet to a Csv using Fusion

 

Thank you in advance,

Eric

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

@eric_d_miller 

Fusion doesn't allow you to check whether a folder's docs were changed.  So you'll need to configure a new-document instant trigger, after that get the documents folders collection. 
I'd recommend doing the uploads to a specific TASK or issue - then you can filter the event by taskID

 

In Fusion you cannot convert an XLS/XLSX to CSV. XLS/XLSV is binary and Fusion doesn't have file converters. Options:

  1. If the file is in Excel 365, you can create a connection and use the Excel 365 modules
  2. Request that all data to be ingested by Workfront is XML, JSON or CSV
  3. Create a middleware and use Fusion to send the file, get it converted and then use the output.

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 6, 2025

@eric_d_miller 

Fusion doesn't allow you to check whether a folder's docs were changed.  So you'll need to configure a new-document instant trigger, after that get the documents folders collection. 
I'd recommend doing the uploads to a specific TASK or issue - then you can filter the event by taskID

 

In Fusion you cannot convert an XLS/XLSX to CSV. XLS/XLSV is binary and Fusion doesn't have file converters. Options:

  1. If the file is in Excel 365, you can create a connection and use the Excel 365 modules
  2. Request that all data to be ingested by Workfront is XML, JSON or CSV
  3. Create a middleware and use Fusion to send the file, get it converted and then use the output.
Terms & ConditionsAccessibility statement

Loading footer...