What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Copy data to a spreadsheetAsked by seaba on July 23, 2011 at 09:14 PM
I would like to be able to take data in 3 contiguous fields of a submission (the Email Address & the 2 Phone Numbers) and quickly & easily paste the data into 3 columns in a spreadsheet that I am maintaining. I would like to do it in one copy & paste action from the Submission screen, but it looks like I can only do each field individually. I'm not just appending the data to the end of my spreadsheet; I want to copy the data into a particular row of my choosing. Is there a way to do this?
I'm not quite sure I understood your concern correctly but incase you missed this feature, you might find the Download as Excel/CSV feature useful.
You can export your form submissions into Excel spreadsheet. Just go to the submissions page of your form the look for this button:
You can choose which columns to include in the Excel copy, i.e. email address and phone numbers, but there is no way to control which row to paste a particular entry
We hope you find this information useful. Thank you for using JotForm!
In addition to allanftd's answer, there's currently no way in JotForm that you can copy and paste all of your submissions in just one copy and paste action to your spreadsheet. The best thing for you to do is to import submissions to Excel from the submissions page and from there, you can copy the entire row and paste it in a particular row prior to your liking.
If you have further issues, please feel free to contact us. We will be more than happy to help you.
Albert | JotForm Support
I guess I didn't explain what I was asking very well. My form is used by people who want to volunteer for an event. After someone fills out the form, I contact that person and assign them to a particular volunteer activity. I record their contact information (Name, Day & Evening Phone numbers & Email Address) in a Master Schedule spreadsheet I created. So that I don't have to retype the info (and make mistakes), I copy and paste that person's data from their submission into my spreadsheet. I have to copy & paste these 4 fields individually to my spreadsheet, but I'd like to be able to do all 4 fields at once since they're contiguous columns in the spreadsheet. I could do it if I could access the spreadsheet-like record I see at the bottom of the screen when I look at the submission, but I can't seem to copy and paste directly from there. I have to go to the individual fields at the top of the screen and copy & paste those one-by-one.
I don't want to have to export the entire file, find the right record, and copy the data from a different window to do this, especially since it's all there when I look at the submission. I would think other people would like to do similar things with the data from their forms. Any suggestions? Thanks!
Thanks for clarifying seaba,
The spreadsheet-like records that you see in the submissions page of your form is for viewing purposes only, with provision for deleting and flagging several fields. I have underlined the word spreadsheet-like to stress that it is actually not a spreadsheet that you can edit, its more of a data grid.
The ability to edit is not in place in order to preserve the actual submissions made by your prospective volunteers. For editing the entries, you have to download an Excel or CSV copy of the submissions. Excel copies also serve as a backup copy of your data so it is really a good idea to export it regularly.
We hope you still find this tip useful. Please let us know if you need further assistance.
I'm not sure if I'm getting my point across. I'm not trying to edit the data. All I want to do is copy the data from the grid to my spreadsheet so I don't have to retype it.
I can do the copies one field at a time (from the data above the grid). I was just hoping to do all the fields I want (and only the fields I want) in one copy & paste step, and I thought the grid would be the place to grab the data. But I can't seem to highlight any of the fields in the grid so I can copy them.
I know it may not seem like a big deal because I can accomplish my goal of getting the data to my spreadsheet in multiple copy steps. But when I'm dealing with lots of volunteers, eliminating/streamlining any steps I can helps a lot.
Thx for listening one more time!
I couldn't find a way to select fields in the submissions grid but there is a workaround using Firefox.
Hold the CTRL key while highlighting the information you want to copy, then press the letter C on your keyboard (while still holding ctrl) or just right click then choose copy.
Then, paste the copied text onto your spreadsheet file. It will automatically segment the copied text into separate cells in the column. Please watch this short video for a demo.
Please remember to begin the highlighting from the white space in front of the field value. This is to include a carriage return in the copied text so that the values are pasted in separate cells.
If you want the values to be copied in rows (horizontally), you must use the Paste Special > Transpose function of Excel. Please click here to learn more about that.
Hope you find this helpful. Let us know if there's anything else. Thanks!
Thanks so much for looking into this. I realize it's a bit outside the scope of Jotform itself.
Your workaround works, but it does feel awkward, partly because there are a number of steps involved. (There's actually one extra step because I'm copying from a non-Excel format.) But I'll keep trying it, and maybe with a little practice, it'll feel easier.
Your help is much appreciated!
I understand why you want to accomplish a one-click process to get things done. I mean, in this day and age, everything should be pretty much automatic, right?
Believe me, I have been in such situations, especially when dealing with Excel data. I know how gets repetitive and boring such tasks can get.
Anyway, hope you find the workaround I offered helpful. Feel free to contact us again if you have other questions or concerns.
Thank you and have a nice day!
I just randomly tried doing this again, and I am now able to copy and paste directly off the grid! I just highlight the fields in the row I want, click Command-C to copy them (I use a Mac), and then Command-V to paste them into my Excel spreadsheet. Works beautifully! You must have changed something since last year. Thanks very much!!
Thanks for letting us know that you are now able to copy and paste directly on the grid. Our developers work on numerous releases and updates are made weekly.
Your last message came in blank, is it that you were also adding to this post?
No, I wasn't going to add anything. I think I just clicked submit again accidentally. But once again, thanks for making the change. It's enabled me to work much faster with fewer steps and keystrokes.