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
  • 1697 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:

 

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

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.

      Eric_D_Miller
      Eric_D_MillerAuthor
      Level 5
      June 19, 2025

      Oof - I don't know of a way other than brute force: Here's my attempt at reading out the particular cell based on row/col numbers. 

       

      This "CSV" is not a single table where you could parse and fetch the value from Column X and Row Y. We're I'm doing it manually.

       

      After setting the CSV, I create that mapping, including row#, col# and a name for the variable. Seemed easiest. Then some CSV gymnastics because I can't simply split a row on a comma, since values can include commas (ex X,XXX). The purist in me shudders a bit, but it works. - Of course that assumes noone adds columns or rows 🙂 

       

      Results:

       

      JSON map

       

      resulting array of desired values

       

       

       

       


      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.

       

       

       

       

       

       

      Terms & ConditionsAccessibility statement

      Loading footer...