Amazon Textract JSON to Excel
Reconstruct tables, forms, and text from Amazon Textract Blocks and Relationships, then export Excel or CSV.
Checks before and after data conversion
1Before converting
- Keep the source file and confirm its encoding and data format.
- Check whether the first row contains headers and whether field names look correct.
- For personal or sensitive data, confirm where processing happens and who will receive the output.
2After converting
- Use the preview to verify text, column names, and row counts.
- Open the result in Excel or the destination system and check dates and long numbers.
- Save the converted file under a new name so it can be compared with the source.
Common next steps
What is Textract JSON to Excel?
Follow TABLE, CELL, WORD, and SELECTION_ELEMENT relationships to rebuild table grids and place multiple tables on separate Excel sheets.
Rebuild tables from the Block graph
A Textract response is a graph of Blocks linked by IDs rather than a ready-made spreadsheet. This tool follows Relationships and uses RowIndex and ColumnIndex to rebuild cells.
KEY_VALUE_SET blocks go to a Forms sheet, LINE blocks go to a Text Lines sheet, and selected checkboxes are preserved as [X].
Extracted content
- TABLE and CELL grids
- WORD and selection elements
- KEY_VALUE_SET names and values
- LINE text and confidence
- Multiple pages and tables
Excel vs. CSV
How to use
- 1Choose a Textract JSON response
- 2Click convert
- 3Review the reconstructed table
- 4Download Excel or CSV
FAQ
Can it handle multiple tables?
Yes. Each table is written to a separate Excel sheet.
Are form key-value pairs included?
Yes. KEY_VALUE_SET relationships are exported to a Forms sheet.
Does it correct OCR errors?
No. It reconstructs the structure while preserving the Text returned by Textract.
Related tools for the next step
Need help choosing the right workflow?
The guide section covers format differences, compression tips, and common PDF workflows.