How to output excel from Azure document intelligence？

Question

How to output excel from Azure document intelligence？

ok 5

Hi,i'm a student major in aduit.this is my first time to try azure document intelligence to transform pdf to excel.But the output is json form.i dont know how to transfer it to excel.and it seems when i copy the json data to some online website, which can transfer json to excel,thing turn out to be something wrong.

please help me.

1 answer

Your answer

Answer 1

Azar 31,610 MVP Volunteer Moderator

Hi ok

Let me suggest you two ways you can do this,Follow these steps:

Copy the JSON data from your Azure Document Intelligence output.
Visit json-csv.com and paste your JSON data.
Adjust the settings if needed.
Click on the "Download" button to download the Excel file.

or you can do this over excel If you have Microsoft Excel installed, you can directly import JSON data into Excel:

Open Excel.
Go to the "Data" tab.
Click on "Get Data" or "Get External Data."
Choose "JSON" and import your JSON file.
Follow the import wizard to map JSON properties to columns.

If this helps kindly Accept the answer and if you have any queries kindly ping here thanks very much.

ok 5 Reputation points

2024-01-07T14:01:12.2266667+00:00

Hi，Azar,

i‘m glad to see you answer my question. but i'm rookie to the whole code thing.i try the two method you provide above.But i don't see any good outputs.the first pic is that i paste the json data to the json-csv and download it as excel,and it show a mess-up data.the second pic is that i get data from json in excel,it automatically start with power query,it's obvious not the right table that i want to extract from the orginial pdf.i dont how to deal with this kind of data form.
mastix 0 Reputation points

2024-04-03T16:09:47.9766667+00:00

I have excel and when I export first as Json and try to import (Get External Data) in Excel selecting the Jason I only get a small table with a few data and not all the large data detected in Azure Document Intelligence. It is really confusing and not friendly for beginners.

I only get a table with 4 fields with weird stuff like : status succeeded , and some dates. Nothing from the extracted data of the invoice

Share via

How to output excel from Azure document intelligence？

1 answer

Your answer