Skip navigation
Darren Gomersall
Currently Being Moderated

Delineate data in exported CSV

Mar 19, 2012 12:42 PM

Tags: #export #columns #csv

Hi everybody,

 

I hope this is a fairly simple query. I have a form with a table intended for collecting certain data. The columns represent different fields I need info for. The rows would be the data from different sources. So the columns are things like name, email, phone number etc. Each row in the form is data collected from a different person.

 

When I export the collected data as a CSV, instead of (for instance) all the email addresses being displayed one underneath the other in a single column, all the fields are their own column, so I end up with columns called name, email, phone number, each with one entry below them which is the data from the first row in the form. The columns start again with name, email, phone number and the data collected in the second row appears in these columns. And so it carries on across the excel sheet.  With some copying and pasting the fields can all be put correctly one under the other, but is there a way to specify this in the form setup?

 

We want to use the captured data for upload into our CRM software and it's a pain to have to sort the sheets first. It has a uploader function so as long as the CSV only has one column for each field but all entries are stacked in that column it will import

 

Thanks and hope question is clear enough

 

Darren

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points