Skip to main content
Question

How can I convert an Excel sheet to JSON data in JavaScript?

  • December 19, 2016
  • 3 replies
  • 44 views

3 replies

david_r
Evangelist
  • December 19, 2016

Do you want to use Javascript to convert the Excel data to JSON, or do you want to convert the Excel data to JSON to use it in a Javascript module somewhere?

If it is the latter, you can let FME generate the workspace for you:

  • Open FME Workbench
  • File / Generate workbench...
  • Reader: Excel, point it to your input Excel file
  • Writer JSON, set your desired output filename
  • Ok

Then run the workspace by pressing F5.


redgeographics
Celebrity
Forum|alt.badge.img+49

Unless you have specific requirements as to what's supposed to happen to the data during that conversion, the Quick Translater should work just fine. Just select your Excel sheet as input and supply a path/filename for the JSON output file and that's it.


Thanks for sharing a useful information

Seo Expert


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings