Open previously downloaded 2024_group08_mdc01.xlsx and save as facilities.xlxs

Translate spreadsheet using Google translation service: https://translate.google.co.uk/?hl=en&tab=wT&sl=ja&tl=en&op=docs

Save and reopen the translated spreadsheet

Delete all columns after the Facility name

Rename Facility name to just name

Delete rows 1 to 3 which leaves a column header

Rename column headers Notification number to number_xx where xx is the two digit current year and Serial number to number_xx where xx is the two digit last year.

Save as CSV called 0_serial and import into WampServer:

Check the number_xx column contain a 6 digit number and if not check either the spreadsheet save process has dropped a leading zero.

SELECT *

FROM `0_serial`

WHERE CHAR_LENGTH(`number_24`) != 5

   OR (`number_23` != '-' AND CHAR_LENGTH(`number_23`) != 5);

Populate the serial column:

UPDATE `0_serial` s

JOIN `0hospitals_japan_years_hostinger` h

    ON s.`number_23` = h.`number_23`

SET s.`serial` = h.`serial`;

 You will end up with a table looking something like:

Structure

And

Remove the unwanted facilities









Topic last reviewed: 01/04/26