What is the easiest way to convert an Excel spreadsheet with tabular data to JSON

Question

I want to convert spreadsheet data from Excel or Open Office saved as *.xls to *.json

Answer 1

Assuming you really mean easiest and are not necessarily looking for a way to do this programmatically, you can do this:

1. Add, if not already there, a row of "column Musicians" to the spreadsheet. That is, if you have data in columns such as:

   Rory Gallagher      Guitar
   Gerry McAvoy        Bass
   Rod de'Ath          Drums
   Lou Martin          Keyboards
   Donkey Kong Sioux   Self-Appointed Semi-official Stomper
   

   Note: you might want to add "Musician" and "Instrument" in row 0 (you might have to insert a row there)

2. Save the file as a CSV file.

3. Copy the contents of the CSV file to the clipboard

4. Go to http://www.convertcsv.com/csv-to-json.htm

5. Verify that the "First row is column names" checkbox is checked

6. Paste the CSV data into the content area

7. Mash the "Convert CSV to JSON" button

   With the data shown above, you will now have:

   [
     {
       "MUSICIAN":"Rory Gallagher",
       "INSTRUMENT":"Guitar"
     },
     {
       "MUSICIAN":"Gerry McAvoy",
       "INSTRUMENT":"Bass"
     },
     {
       "MUSICIAN":"Rod D'Ath",
       "INSTRUMENT":"Drums"
     },
     {
       "MUSICIAN":"Lou Martin",
       "INSTRUMENT":"Keyboards"
     }
     {
       "MUSICIAN":"Donkey Kong Sioux",
       "INSTRUMENT":"Self-Appointed Semi-Official Stomper"
     }
   ]

8. Go here: http://jsonlint.com/

9. Paste the JSON into the content area

10. Pres the "Validate" button.

If the JSON is good, you will see a "Valid JSON" remark in the Results section below; if not, it will tell you where the problem[s] lie so that you can fix it/them.