Convert Excel to JSON

Here is a quick tutorial to convert your offline Excel documents to JSON file to feed to your web applications. It goes without saying, there are multiple ways to solve the problem.

But when you need to process more complex files, or multiple documents, such manual solutions simply are not worth the candles. Too tedious, too slow. Is there a way to automate XLS to JSON conversion? You bet! The app is called Advanced XLS Converter, and it does the trick completely automatically.

Step 1: Choose the source Excel file (or folder)

Run Advanced XLS Converter and click the "Browse" button to select the Excel spreadsheet you want to convert. Alternatively, you can specify a folder here to convert all XLS files in it to corresponding JSON files.

excel to json conversion

Step 2: Select what dat you want to export to JSON

What makes Advanced XLS Converter stand out from competitors is flexible and fully customizable conversion. The dialog shown below allows you to configure the conversion.

common options

Now, you can filter out some data from the Excel file, select specific columns to export and adjust other settings. When you are done, click Next.

Excel to JSON conversion via Command Line

"c:\Program Files (x86)\Advanced XLS Converter\xlscnv.exe" file.xlsx outfile.json [/FILTER | /COLUMNS | /SORTBY | /SHEETNUM]

Simple conversion

"c:\Program Files (x86)\Advanced XLS Converter\xlscnv.exe" sample.csv sample.json

Convert Excel to JSON with columns selection

"c:\Program Files (x86)\Advanced XLS Converter\xlscnv.exe" sample.xlsx out.json /COLUMNS:NAME,STREET

Convert to JSON with filter

"c:\Program Files (x86)\Advanced XLS Converter\xlscnv.exe" sample.xlsx out.json /FILTER:myfilter.txt

Conversion with sorting order

"c:\Program Files\Advanced XLS Converter\xlscnv.exe" sample.xlsx out.json /sortby:DATE

Convert folder with Excel files to JSON

"c:\Program Files (x86)\Advanced XLS Converter\xlscnv.exe" d:\base\*.xlsx d:\out\ /TOJSON


Updated Mon, 19 Apr 2021

Back to XLS Converter Home