I'm currently trying to develop a macro that allows me to transfer excel data into Notepad in the following format.

$json['Name'] = 'Taylor Street., west side, in front of Hamilton Hotel';
$json['Latitude'] = '11.111111';
$json['Longitude'] = '-222.222222';
$json['StreetAddress'] = '1856 Taylor Street';
$json['ZipCode'] = '28356';
$data[] = $json;

The excel columns are Location, Area, Lat Long, Reference Marks, Address.

I have about 100 rows of data in the spreadsheet.

Any help on how I do this would be appreciated!

Thanks.