• Overview
• How to format the file
• As an Example
• Common errors to avoid when submitting a csv data file
• What Next?

Overview

The Employment Tribunals Service have incorporated a multiple claim facility that will enable organisations representing more than 28 claimants to export the claimants details from another database in .csv (Comma Separated Values) format and attach them to the PDF ET1 claim form.

Back to top

How to format the file

The file you attach be in .csv format and the data within it must be in the correct order.

The ET1 claim form always contains the first claimants details the other (Multiple) claimants details should be entered in the ET1a section of the form (if there are less than 28 claimants) or attached in .csv format. The .csv data file MUST contain the following information:

• Title

• Forename

• Surname

• Date of Birth

• Address Line 1

• Address Line 2

• Address Line 3
  

• Address Line 4

• Postcode

Each element i.e. First Name must be in its own vertical column, if you do not have the information for say Address Line 4 leave the column blank.

Please Note: The Date of Birth must be in DD/MM/YYYY format.

Back to top

As an Example

A large number of spreadsheet and database tools will enable you to save data in .csv format e.g. Open Office and Microsoft Excel. Please read the relevant help guides for more information on how to save data in .csv format.

Back to top

Common errors to avoid when submitting a csv data file

Please review the following before saving and submitting a claim with a csv attachment.

• The spreadsheet should not contain less or more than 9 columns of information. For example if you do not have information for Address Line 4 leave the column blank, Do not remove column:

• The spreadsheet must provide the following information:
  

  • Title (e.g. Mr, Mrs, Miss)

  • Forename (First name)

  • Surname (Last name)

  • Address line 1 (1st line of address e.g. building name, number and street)

  • Address line 2 (2nd line of address e.g. local borough or Town/City)

  • Postcode (Full postcode e.g. PRY 3GH)
    

• The form should only contain letters and numbers (AaBbCc123) other than in the Date of Birth field which must be in DD/MM/YYYY format. If a comma or speech mark is contained within the spreadsheet before saving in csv format it will corrupt the saved csv and the form cannot be submitted.
  

• Do not include apostrophes and hyphens in the name or address.
  

• The spreadsheet should only display information in a single row.
  

• The title of the saved csv tile should only contain letters and numbers (AaBbCc123) and no spaces.

Back to top

What Next?

Once you have saved the data in .csv format click the “I want to make a claim on behalf of more than one person” box on the 1st page of the ET1 claim form and then click “Attach Multiple Claim File” read the alert box and click OK then “browse” for the file you have saved on you computer, click on it and lastly click “Select”. The file is now attached to the form.

Once you have submitted the form online you will be presented with an on screen success receipt if the submission is successful. If an error has been detected you will be presented with an error receipt, please check your form and .csv file and try again.

If the problem persists please save the form and contact our support team at ets@legatio.com

Back to top