To import questions into EASE, navigate to Manage / Question Library, first download the template file and save it to a convenient location.

  1. Click Upload Questions icon: 
  2. In the pop-up window, click Template to download the .csv or .xlsx file.
  3. Fill out the file with all information to be imported.
    1. If you are using .csv, ensure the file is saved as .csv with UTF-8 encoding, or the import will not succeed.
    2. Questions can be imported into all audit categories that your organization may use. 
    3. There are few libraries' restrictions, and those restrictions mirror the setup of questions in each library.
    4. Each row in the file will be imported as one question with the appropriate settings. The table below is a guide for acceptable inputs in each column.
  4. Click browse or drag and drop to attach the file. Then click the Upload button to import the questions into the library.
Note: Use this page to upload excel files in the old format. How to Import old excel files to Ease Audits


ATTENTION! 

When importing Questions to the library number of Tags added to the question is limited to 5.



Click here to watch the Importing Questions tutorial.



Tips:

  • Do not delete nor modify the contents of the header row from the template.
  • Save the file as a CSV UTF-8 (MS Excel 2016 and above have this option as shown below):
  • If a column is Required, then the value must be present in each row.
  • Quotation marks are not valid and are used below for descriptive purposes only. Including them will result in an error when importing.
  • Columns A, C, and F are the bare minimum for an import.


    ColumnEligible Value (pick one if multiple are listed)Note
    Template type/ Activity*The name in this field must match one of these or match a custom template type you created: "LPA" / "5S" / "Safety."Required
    TitleTextRequired for the following languages: Japanese, Chinese, Korean, Thai, and Arabic. Optional for other languages, and we will auto-generate a title.
    Question*TextRequired
    ReasonTextOptional
    Reaction PlanTextOptional
    Response Type*"Pass_Fail" / "Score" / "Free_Form"Required
    Required"Yes" / "No"Optional, if blank -  then 'Yes' is selected
    Photo Input"Off'" / "Optional" / "Required" / "Required_Fail"Optional, if blank - then 'Optional' is selected
    Mitigation"Off" / "Optional" / "On"Optional defaults to 'On' for Pass/Fail and to ‘Off’ for Score if no value is entered under 'Minimum Passing Score.'
    Alternate Responsible Party"Off" / "On"Optional defaults to 'Off.'
    ScoreInteger (1-10)Required if the Response type is 'Score,' must be empty otherwise.
    Minimum passing scoreInteger (0-Score)Optional, if empty - then no pass range is defined. Must be empty if the response type is not 'Score.'
    tag1TextOptional, if the tag does not currently exist, then create it.
    tag2TextOptional, if the tag does not currently exist, then create it.
    tag3TextOptional, if the tag does not currently exist, then create it.
    tag4TextOptional, if the tag does not currently exist, then create it.
    tag5TextOptional, if the tag does not currently exist, then create it.
    ScopeTextOptional, must be one of the scopes listed under Admin / Organization / Scopes.


  • If your Excel region has semicolons (;) as the default delimiter in CSV files, you will have to convert them to commas (,).On Windows, you can change the List separator setting in the Regional and Language Options as specified on the Office support website:
    • Change the separator in a CSV text file.
    • Click the Windows Start menu.
    • Click Control Panel.
    • Open the Regional and Language Options dialog box.
    • Click the Regional Options Tab.
    • Click Customize / Additional settings (Win10).
    • Type a new separator in the List separator box.
    • Click OK twice.
    • Note: this only works if the Decimal symbol is not designated as a comma (in line with the Wikipedia citation above). If it is, Excel will not use a comma as the List separator, even if chosen. For many non-United States regions, a comma is the default Decimal symbol.