Import App: How to format address data of address field?

  • Profile Image
    Asked on January 24, 2016 at 05:46 PM

    Your example with the address field can not be understood:

    "This would require that you not only change the headers, but to apply the changes to the address data as well"

    Because in your example picture you mostly have empty columns ("","","","") in the address field. And it seems you just deleted the columns but mine are not empty as yours.

    So, how do I adjust the data (I use a .xls file)?

    Shall I move the content of all the address fields into one single address field?

    If yes, how shall I separate the content in this one single column so it will be imported correctly ***and can be exported properly to Excel again*** with all the new data which is to come in future. (by a tab, a semicolon or how?)

    This is a re-post of a comment on Import App: Easily Import Your Excel or CSV Data into Jotform

  • Profile Image
    Answered on January 25, 2016 at 03:37 AM

    Hello Kailash108,

    I am not sure if I have understood your question correctly. Do you want to import excel file with address field. You do have to actually combine the address fields in your excel file. You should only have one address column in the excel file form where you want to import data. Please check the screenshot below:


    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    Answered on January 25, 2016 at 06:10 AM

    Wow! You had so much work with it!

    You could put this video in that tutorial, where I asked the questions. It is good for other customers as well.

    But the main part of the question was:

    How do I separate the different columns in a single column?

    In your example you did it by a comma.

    Does the comma make that the text will appear in different columns when I export it again from Jotform to Excel? Or is it a line break? If comma: with a space behind it or without?

    I would believe it is a line break.

    These line breaks gave a lot of trouble to me when I exported data from my forms in the past.

    I don't want to try, and try and try. That's why I'm asking.

    If it really is a comma, then it would be a problem when the data in an answered question has a comma in it.


    By the way (tip for other customers): To add three columns in Excel one would use a formula like this:

    =B3&", "&C3&", "&D3

    After combining the columns one has to copy the new column and past it as values or use the button

    Data->Data Tools->Text to Column

    to convert the formulas into text


    How to insert a line break in a formula I don't know.

  • Profile Image
    Answered on January 25, 2016 at 12:15 PM

    If your question is related to commas and address fields, yes you need to use a comma. Inside of mentioned guide there is a an example for address field:

    The address field, might be imported with just one header for it, but your file might have several fields for the address data. The tool will replace these fields:

    "Street Address","Street Address Line 2","City","State / Province","Postal / Zip Code","Country"

    with just this one:


    *This would require that you not only change the headers, but to apply the changes to the address data as well"


    Following this we continue as previously mentioned, one field at a time. 

    If I did not understood you correctly please explain in more details what are you trying to achieve.