Excel doesn't like CSV formatting

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 01/01/2016 at 1:08 pm #359570
    Dirk Leeward
    Guest

    Thanks for adding the CSV output of all the fields together. One issue needs fixed to work with Excel. Excel does not like spaces to follow delimiters, comma in this case. When there are spaces, Excel ignores the next quote and fields that have commas in them end up getting separated into multiple columns.

    I did a search and replace in a text editor to remove the extra spaces and it then imported fine into Excel.

    01/02/2016 at 10:09 am #359697
    Steven Zahm
    Keymaster

    @ Dirk

    Thanks for letting me know. I removed that space from after the delimiter. This change will be in the next update planned for the end of the week (or so).

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You cannot reply to this support topic. Please open your own support topic.