label1,label2
item1a,item2a
item1c,"item2c,c"
item1b,item2b

var my_object_array = [
     { my_col1_val: 'item1a', my_col2_val: 'item2a' },
     { my_col1_val: 'item1b', my_col2_val: 'item2b' },
     { my_col1_val: 'item1c', my_col2_val: 'item2c,c' }
];

• Read a CSV file already uploaded with JavaScript
• Populate a JS array with each row
• Account for strings containing double-quotes (and commas to ignore)
• Sort the resulting object array

A                                       B
-------------------------------------   ----------------------
Beijing Capital International Airport   40°4′20″N 116°35′51″E
Beijing Shahezhen Air Base              40°8′57″N 116°19′17″E
Beijing Tongxian Air Base               39°48′40″N 116°42′30″E

FIND(""",B1)   // will NOT work!
FIND("""",B1)  // will work
FIND("″",B1)   // will work

1. Open up a new workbook.
2. Get into VBA (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste the Excel user defined function below

   Sub ExtractHL()
   Dim HL As Hyperlink
   For Each HL In ActiveSheet.Hyperlinks
   HL.Range.Offset(0, 1).Value = HL.Address
   Next
   End Sub

5. Press F5 and click “Run”
6. Get out of VBA (Press Alt+Q)

Old       New       Exists in Old?
--------- --------- --------------
123456    234567
234567    345678
345678    456789
567890    597890