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

    I need to set up an excel form for csv to import file to an ftp

    Asked by geminicocoa on January 30, 2017 at 06:57 PM

    I have to use a specific format for ftp for my supplier for importing products and I understand how they want me to set up the file in excel and them convert it over to csv.

    My question is how do I get there form to look like what they want with out the headings.

    This is what my csv looked like now but they need it formatted with there example below.

     

    CUSTOMER NUMBER                       PURCHASE ORDER NUMBER                         TYPE                      SHIP-TO NAME    SHIP-TO ADDRESS 1          SHIP-TO ADDRESS 2          SHIP-TO CITY       SHIP-TO STATE    SHIP-TO ZIP CODE     SHIP-TO PHONE NUMBER                              SHIP VIA CODE    STORE NUMBER UNFI PRODUCT NUMBER                             QUANTITY

    90787                   100125                                               Ann Margaret Beebe        510 Henrietta     5               Algonac MI          48001    5869806366                       A             5001      2900023                             99999

     

     

    Please see below, and attached, the format this needs to be provided in. Our system requires this to be in the attached format specifically for orders to successfully flow through.

     

    1

    35045,,PO13203291,,FIL,

    John Doe,161 Willow Mill Park Road,,Mechanicsburg,PA,17050,,A,5001

    200931,,3,,,

    ***EOF***

     

  • Profile Image
    JotForm Support

    Answered by BDAVID on January 30, 2017 at 09:42 PM

    Unfortunately, there is not way to change the format the CSV, or Excel submission is downloaded. You will need to do it manually after you download it from your submissions view: https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF