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.


  • Profile Image

    When using importrange still can't modify spreadsheet.

    Asked by Jasoncaouk on October 14, 2014 at 07:15 AM
    IF I USE IMPORTRANGE, I STILL CANT MODIFY THE SPREADSHEET
  • Profile Image

    Answered by Shadae on October 14, 2014 at 10:01 AM

    Hi Jasoncaouk,

    To confirm, you are having an issue with editing the second spreadsheet that you have created to import information from your integrated spreadsheet?

    You would not be able to edit the data on the spreadsheet that the information is imported to, as it is only showing the information from the original spreadsheet. Any changes to the information you would do on the original spreadsheet and it would change in the new spreadsheet.

    You are however able to create additional columns and edit those within in the new spreadsheet. You should also be able to do your formatting edits on the new spreadsheet.

    I hope this helps, please inform us if you need additional assistance.