Hi there,

I am having an issue with my CSV file I am trying to import into webhook.  
 

When I use formatted to read my file, it seems to output correctly however, when I try and use the output, it is incorrect.

see below:

I have approx 3 heading (code, name, points) and each row under that represents a different person e.g:

1. 12345,Jane Doe, 50
2. 16535, Sam Test, 100
3. 17546, John Doe, 4000

when I look at the output of my test, each row seems to be looking correct.

1.

code-12345

name- Jane Doe

points- 50

2.

Code-16535

name- Sam Test

points-100

3.

code- 17546

name- John Doe 

points- 4000

unfortunately though, when I go and  

 use that information in other apps (such as webhook, it seems to be grouping the columns together in one string. Eg:

Code: 12345,16535,17546

Name: Jane Doe, Sam Test, John Doe

points: 50,100,4000

With this, it’s causing an error as it’s not importing the single item. Also, I tried importing into a database to confirm how it would import into, say, a spreadsheet and it imports the entire string

I have tried each of the settings in formatter, tried to play around with the format of the spreadsheet etc  but nothing 

Wondering if anyone has a solution OR even if there is a way for Zapier to read a file, csv or text without having to use formatter

Thanks in advance

Jordan