Understanding Parsing/Mapping Data From A .CSV File | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
May 27, 2025
Solved

Understanding Parsing/Mapping Data From A .CSV File

  • May 27, 2025
  • 2 replies
  • 1662 views

Hello,

 

I am attempting to pull information from a .csv file and would like to map that data to specific fields on a project. The csv is originating from a spreadsheet. There are a few cells in the spreadsheet that I would like to map data to some project fields.

 

The CSV file that is being uploaded parses with no data in the bundles, only the header:

 

Any insight on what I need to do in order to access the rest of the data in the csv? Could it be how the excel sheet is formatted?

Why are my bundles showing up blank?

 

Here is my Parse CSV Module for context:

 

Best answer by Sven-iX

Sven,

 

Thanks for the details and the Blueprint!

 

I am lost on how to set the initial 'set variable' module to pull the date from the .csv being uploaded rather than the text I sent as the example.

 

Do I still download the document in Fusion? If so how do I push the data from the downloaded .csv to the variable?

 

Thank you in advance.

 

 

 

 

 

 


Hi @eric_d_miller 
you don't need that variable technically (I needed to because I didn't download the CSV)
Just use the 3.data field from the download

 

2 replies

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
May 27, 2025

2 thoughts:

1. why not select comma from delimiter dropdown? maybe that is impacting results...

2. We use aggregator into custom data structure post parse CSV module to organize everything :

I hope this helps

Rafal

    Sven-iX
    Community Advisor
    Sven-iXCommunity Advisor
    Community Advisor
    May 27, 2025

    Hi @eric_d_miller 
    Can you check what the {3.Data} value is? (I assume it's from a document download?)

    Also - when you download the CSV and open in Excel - does it look as expected? 

      Eric_D_Miller
      Eric_D_MillerAuthor
      Level 5
      May 28, 2025

      Hello @sven-ix ,

      The  {3.Data} value is indeed from a document download. The downloaded file is a .csv format.

       

      The .csv file is getting exported from an Excel spreadsheet that includes plenty of formatting, but when I open it via .csv all of the data is still in there.

      Sven-iX
      Community Advisor
      Sven-iXCommunity Advisor
      Community Advisor
      June 23, 2025

      Sven,

       

      Amazing! This got it! Very helpful to see how you brute forced certain rows/columns.

      As always, I appreciate your expertise.

       

      -Eric


      Glad I could help Eric. 

      If you have Office 365 you could also look into the Excel modules 

       

      One thought: 

      If you create a separate sheet where you reference the cells you need with a formula, and export THAT sheet you could save yourself the brute-force trouble: 

       

      E.g. 

       

      Then your CSV module would import these 4 "columns" as you expect. 

       

       

       

        Terms & ConditionsAccessibility statement

        Loading footer...