The data module in Excel is sued to connect to the table on the websites. In this way, when refreshing, the data will be automatically downloaded and always up-to-date.

To download data, go to the Data tab and click “From the Web”:

Then paste the address from numbeo.com:

Choose anonymous login method:

Find the tables with the data you want to download:
image
In our case, “Table 0”:
image
Before downloading, select “Edit”:
image
In the editor, expand the arrow in the “Edit” field and uncheck [Edit] “:
image
Then select Replace Values on the panel:
image
Replace “PLN for nothing, a comma for nothing, and a dot for a comma:
image
Then by clicking on “ABC” change the type to Decimal number:
image
And the last column by right clicking on it and “Delete”:
image
Then select “load”:
image
This exercise should be performed for all countries.

In our case, “Table 0”:

Before downloading, select “Edit”:

In the editor, expand the arrow in the “Edit” field and uncheck [Edit] “:

Then select Replace Values on the panel:

Replace “PLN for nothing, a comma for nothing, and a dot for a comma:

Then by clicking on “ABC” change the type to Decimal number:

And the last column by right clicking on it and “Delete”:

Then select “load”:

This exercise should be performed for all countries.

Thanks