Poorly Formatted CSV Export

  • I just purchased the pro version and things are working well except that the csv export puts data into up to 3 different columns. And the data is inconsistent depending on the row, e.g. one row may have several columns worth of data in column B and the other row has those same data in column C. So I can’t do a normal text-to-column operation to get a workable report. Need to know how to fix this.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Richard Royal

    (@richardroyal)

    You need to import it into your spreadsheet program and select the correct delimiter “;”

    Depending on your spreadsheet program, is should give you a preview that will put the data in the correct columns. How this works by default depends on your spreadsheet program and region.

    Thread Starter revadigital

    (@revadigital)

    Thanks. That’s what I was doing and it didn’t work for some reason in Excel Mac 2011, but using Semicolon plus Tab and Comma finally worked.

    Plugin Contributor Richard Royal

    (@richardroyal)

    Correct, depending on your program and region, you may need to use the import region. The same program will import differently using a double click open in different regions (Europe or US for example).

    Hi revadigital,
    I’m so glad Richard was able to address the csv importing issue. Would you mind updating your review? We depend on reviews to help future customers make the best decision.

    thanks so much for choosing WP Simple Survey!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Poorly Formatted CSV Export’ is closed to new replies.