How to extract table data to excel file from Document Intelligence Studio

Question

We've been exploring Document Intelligence Studio for our documents. Everything works perfectly. We only have 1 question. Is there a way to extract tables into excel file? As of the moment, we just happened to copy and paste the tables from Document Intelligence to excel manually.

Answer 1

@John Salabsabin Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

To extract Table data from documents into an Excel Spreadsheet follow either of the below steps explained in this document:

https://techcommunity.microsoft.com/t5/ai-azure-ai-services-blog/extracting-table-data-from-documents-into-an-excel-spreadsheet/ba-p/3796841

Option 1:
Azure Function (HTTP Trigger based): This function takes a document and generates an Excel file with the table data in the document. This is done using the Azure Document Intelligence service.

.

.

Option 2:

Apache Spark in Azure Synapse Analytics (in case you need to process large volumes of documents).

.

.

Option 3:

Similar to what you are doing now (manually), you can refer to the steps mentioned her:

https://learn.microsoft.com/en-us/answers/questions/1481440/how-to-output-excel-from-azure-document-intelligen

.

.

Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

**

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.