iPhone app download submissions to Excel format feature request to keep the same column order as it has in the Table

Hi,

I export my data daily from Jotform to an excel spreadsheet. I know there are automated options but I use iCloud not Onedrive and the automated options require Onedrive.

Anyway, I am looking for the easiest way to do this. When I use the website, I have to open a table, then click download all and select Excel. It then places the file in my downloads folder with the unique name that includes the date and time. I then rename the file to my standard filename and move it to the appropriate folder where my spreadsheet automatically picks out the data it needs from this spreadsheet.

I found that I could save a couple of steps by exporting the data from the iPhone App. This allows me to select the correct folder overwrite the existing file with the correct name - it's much simpler and quicker this way.

The problem is that when you export from the iPhone app, the order of the columns changes to what they are when you export from the website. It means I need to modify my spreadsheet depending on where I get the data from, I can't just swap and change.

Is it possible for you to make the column order the same no matter where I export from? Am I doing something wrong?

Thanks.

Hi Mark,

Thanks for reaching out to Jotform Support. I am sorry you are having trouble with this. There is a direct integration with Google Sheets. This way, all the submissions are automatically updated in real time for both the Submission Table and the Integrated Google Sheets. Let me show you how:

1. In Form Builder, click on Settings at the top of the page.
2. In the Settings menu, click on the Integrations option and Google Sheets integration again.
3. Now, select and connect your Google account.
4. Select an option.
5. Choose your form field.
6. Click on Save, and that's it, you're done.

We also have a guide about Google Sheets integration that you can check out.

Let us know if this integration works for you, if not, we can move forward with a workaround.

Hi Joshua,

Thanks, I was aware of the Google integration but I prefer not to use Google for anything that I need to use a login with. Given they are a company who’s business model relies on selling data, I place no trust in them at all.

So are you saying that the problem with the column order changing depending on the method used to export is not fixable?

Hi Mark,

Thanks for reaching out to Jotform Support. The order on how the column will display depends on the method or how the 3rd party application display it. Compatibility could be an issue as well. We pass the data that's needed in the right format. Sadly, we don't have control over the application. 

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

Let us know if you have any other questions.