Identify the names and addresses of guest houses, B&Bs and small hotels in Edinburgh

Identify the names and addresses of all guest houses, B&Bs and small hotels in Edinburgh and place them in an Excel file. Most addresses will be four lines. Below are some you can put straight into the file. Some addresses you find might include 'Edinburgh City', 'Lothian' or 'Midlothian'. Remove these words.

A site you might use to scrape addresses from is https://www.visitscotland.com/destinations-maps/edinburgh/accommodation/bandbs-guesthouses/. Warning: if you refresh the page the addresses that appear will be different.

Any questions, please ask me.

Gifford House
103 Dalkeith Road

Edinburgh

EH16 5AJ

Granville Guest House
13 Granville Terrace

Edinburgh
EH10 4PQ

Fernielaw House
Fernielaw Avenue

Edinburgh

EH13 0EF

Corstorphine Lodge Hotel
188 St John's Road
Edinburgh

EH12 8SG

Abcorn Guest House
4 Mayfield Gardens

Edinburgh

EH9 2BU

Classic Guest House
50 Mayfield Road

Edinburgh

EH9 2NH

Falcon Crest Guest House
70 South Trinity Road

Edinburgh

EH5 3NX

Sandilands House
25 Queensferry Road

Edinburgh

EH4 3HB

Pillars House
125/3 Constitution Street

Edinburgh

EH6 7AE

Alpha Guest House
19 Old Dalkeith Road

Edinburgh

EH16 4TE

Sherwood Guest House
42 Minto Street

Edinburgh

EH9 2BR

Heriott Park Guest House
254 Ferry Road

Edinburgh

EH5 3AN

11 Belford Place

Edinburgh

EH4 3DH