β οΈImportant: The import of the Addressbase data is failing. This is due to the settings in Excel automatically converting the data to numbers with exponentials, which the application can't read.
Solution steps:
Open the Addressbase data in Excel and expand all the cells to fit the text within.
Right-click the cells that display exponential and select Format Cells.
Select Number > Change decimal place to 0.
Once there are no numbers with exponentials, select File and then click Options.
Select Data and then click Automatic Data Conversion.
Then Untick 'Keep first 15 digits of long numbers and display in scientific notation' and then 'Convert digits surrounding the letter "E" to a number in scientific notation'.
Save the file as CSV, and then upload that saved file.
