Batch File Requirements

Before uploading your file, please make sure that:

  • the file is in CSV (.csv) format;
  • you include in the first row of your spreadsheet the following headings: FRID, UPRN, RM_UDPRN, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4, ADDRESS_LINE5, ADDRESS_LINE6, ADDRESS_LINE7, POSTCODE;
  • you capitalise the headings of your file - e.g. FRID not frid;
  • you use an underscore instead of a space in your headings - e.g. RM_UDPRN not RM UDPRN;
  • you include as a minimum the property FRid and/or UPRN and/or RM_UDPRN and/or an address;
  • addresses must include at least ADDRESS_LINE1 and POSTCODE;
  • you may add the entire address in ADDRESS_LINE1 or split in between the different address lines;
  • if you populate the entire address in ADDRESS_LINE1 please use commas to separate address lines and please populate POSTCODE even if this is duplicated in the address;
  • if you are using UPRN or RM_UDPRN and are saving the file from MS Excel be sure to format the column as a number before saving.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.