Azure AI Document Intelligence
An Azure service that turns documents into usable data. Previously known as Azure Form Recognizer.
1,845 questions
Every content is in one cell
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 78%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Joe Diedrich (DE)
0
Reputation points
Hello together, Do any of you use the Forms Recognizer? I have a question about it. The following case. I have consolidated reports in .pdf. I would like to extract tables from them. This works very well with Forms Recognizer, it recognises the tables and I can look at them all separately in the preview. If I download the scan as a .json file and open it in Excel, there is a problem. All the information is written into one cell. This means that all the tables are written in one cell below each other. If you look into the .json script, you can see that every word and every number is declared as "content". For this reason, everything is written in the same cell. Do any of you know this problem and have a solution? As I said, in the preview in Form Recognizer, the tables are displayed correctly and separately. Thanks!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VasaviLankipalle-MSFT 18,386 Reputation points2023-07-14T01:34:52.93+00:00 Hello @Joe Diedrich (DE) , Thanks for using Microsoft Q&A Platform.
When you download the JSON file, I believe this is not formatted in a way that Excel is able to read and separate the tables.
I would suggest using a tool to convert the JSON file into a format like Json to csv reader something like that so that Excel can read. Could you please try this and see if that helps?
-
Joe Diedrich (DE) 0 Reputation points
2023-07-14T06:15:50.9733333+00:00 Hey Vasavi thanks for your comment,
I used Microsoft Power Query. In Excel, if you go to "Data" -> "Get Data" -> "From File" -> "From Json", there is an option to configure the .json. Like in this video. https://www.youtube.com/watch?v=0X6NxRDzMDQ
Shouldn't this also work with the .json from Forms Recognizer?
Even if I use another programme to change the file into a .csv, I still have the problem that all tables are described as "content". I don't know how to separate the tables in the .json. That's why I thought that there might be a setting option when using the Forms Recognizer?
Sign in to comment
Sign in to answer