We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 54732
    • 20 Posts
    I remember when I used FormSave and any exports placed each form field into it's own column in a CSV spreadsheet. Formit seems to just use JSON strings (I think), and it is REALLY annoying. Is there a way to fix this? Maybe a script or something in Excel/LibreOffice or a modification of the extra? It's really driving my client's marketer nuts, and FormSave is no longer stable.

    This question has been answered by lkfranklin. See the first response.

    • discuss.answer
      • 17301
      • 932 Posts
      Google docs or excel should let you open or import the csv and set the separator value to format it in a readable format. Google docs detects automatically I believe, not so sure about excel been a while since I used that.
        ■ email: [email protected] | ■ website: https://alienbuild.uk

        The greatest compliment you can give back to us, is to spend a few seconds leaving a rating at our trustpilot: https://uk.trustpilot.com/review/alienbuild.uk about the service we provided. We always drop mention of services offered by businesses we've worked with in the past to those of interest.
        • 54732
        • 20 Posts
        Quote from: lkfranklin at Jan 16, 2019, 12:23 PM
        Google docs or excel should let you open or import the csv and set the separator value to format it in a readable format. Google docs detects automatically I believe, not so sure about excel been a while since I used that.

        Thank you! It was just some settings in LibreOffice. You rock!
          • 54671
          • 1 Posts
          I am not sure this question is solved already or not, but let me paste what I have done for reference. First, your JSON has nested objects prepaidgiftbalance