exporting to excel with unique name

  • Ejake
    Asked on May 8, 2024 at 4:04 PM

    I am exporting my data to excel.

    From there, I will be importing it to a Microsoft Access database table.

    To make that second move easier, I have given all of my fields a "unique name" that matches the names of the database table.

    However, when I export, JOTFORM names the columns in the spreadsheet by the "field name"

    How can I make it use the "unique name" as the excel column header?

  • Rene JotForm Support
    Replied on May 8, 2024 at 4:35 PM

    Hi Steven,

    Thanks for reaching out to Jotform Support. Unfortunately, when submission data is exported from your form as an Excel file, it will carry the field names you've used for the form itself. It cannot be changed unless you format every field of your form to the unique fields you want to use so they can match the names you've set for the receiving end, which is Microsoft Access.

    If necessary, you can still modify the names to match with the unique names you wish to use. You must first export the submission and the edit them using Microsoft Excel or another program that allows you to change the information.

    Reach out again if you have any other questions.

 
Your Answer