Get Started

Introduction

Excel to JSON is a Microsoft Excel add-in which can convert Excel to JSON.

Requirements

This add-in works with Excel 2013(or higher) and Excel Online.

Quick Started

Get add-in

  • Get it from Office Store link https://store.office.com/app.aspx?assetid=WA104380263
  • Click on the above link and, in the top right corner, click Sign in.
  • Type the email address and password you use with Office/Microsoft.
  • Click on the “add” button after login.
  • The next page you will see will show that you have successfully added this add-in to your account.
  • Now go to Excel 2013/2016 or Excel Online.
    • If you use Excel 2013/2016 , in the top right corner, click Sign in.
      • Type the email address and password you use with Office/Microsoft。
    • If you use Excel Online, login Excel Online using your Office/Microsoft account.
  • Insert Tab > My Add-ins.
  • In the Add-ins for Office box, find “Excel-to-JSON”. If you don’t see it, verify that you’re signed into Office. Press Refresh to update the list.
  • Double-click the add-in to start it.
  • Now you are ready to use this add-in.

Use add-in

    Note that you should select at least two rows as the first row will be considered as header.
  • Prepare your Excel sheet
  • Select data you'd like to convert
  • In the Excel-to-JSON add-in, check the conversion type you'd like to use
    • Regarding conversion type, check here.
  • Click on "Go" button
  • You will later see the converted JSON below the "Go" button
  • Later you can "copy+paste" / "copy to clipboard" / "save as" JSON and save it to your computer