Purchase Order: Import data from Excel

  • Profile Image
    Asked on March 17, 2015 at 06:07 PM

    I'm trying to import the purchase order data portion of my form from excel/csv but only columns for text boxes are displayed. Is there a workaround?

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

  • Profile Image
    Answered on March 17, 2015 at 10:59 PM


    Can you let us know the form you're working with? I don't believe you can import purchase order data into our payment field widgets, such as PayPal. Some details are processed entirely on the payment vendor side. We just receive confirmation of the transaction, as I understand it. We need more info to look into this further though.

  • Profile Image
    Answered on March 18, 2015 at 09:27 AM


    I'm not using any of the widgets that use authorized payments (no paypal, clickbank, worldpay, etc.)  I'm just using the purchase order in the payment widgets which you can modify to contain different product fields and add up a total.  I was using the form to try to create multiple invoices at once by importing excel/csv data. 

    When i export data from submissions I've filled out manually, there is a column with purchase order info.  If there is a way to import that data via excel, that would be great.



  • Profile Image
    Answered on March 18, 2015 at 12:45 PM

    Hi linathany,

    Thank you for providing us with more information regarding the payment tool that you are currently using.

    After doing some test, the Purchase Order field does not have the option to have data imported. I have sent a request to a developers to see if this can be implemented.

    Any update on the request will be posted on this thread.

    Thank you.

  • Profile Image
    Answered on February 03, 2016 at 04:13 PM

    This would be a fantastic feature, will devs be producing something?

  • Profile Image
    Answered on February 03, 2016 at 10:06 PM

    @andacami01, unfortunately, there is no any update about the progress of this request. This feature is not currently in a priority list, so there is no estimated time-frame for it's implementation.