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.
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.
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]
"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 Wed, 06 Oct 2021