Header Mapping
Column names are field names, and therefore a column named “price” yields a price for each row.
Spreadsheets are used for storing data your application won’t be able to read directly. ExtractMails works with Excel to JSON. It reads supported workbooks one sheet at a time and returns every row of a sheet as a JSON object, with the JSON keys being your column names.
ExtractMails opens the workbook, maps columns to fields, and supplies JSON that your code can parse.
Column names are field names, and therefore a column named “price” yields a price for each row.
Combine one tab or multiple tabs of similar workbooks.
Numbers, dates, and text are retained as they are, rather than being converted to a long string of numbers.
Only select the columns required and keep the rest always out.
Compare the JSON with the sheet prior to delivery.


Running Excel to JSON conversion on a regular basis takes one setup, and each later workbook follows it.
Upload a workbook or forward an email with the file attached.
Choose which tabs and columns should be converted.
Tell the tool which row holds your column names.
Download the result or send it to your application.
Real workbooks are rarely tidy, so an Excel parser must cope with more than a single clean table.
Set which row holds the headers when a title or logo sits above them.
Skip empty rows, empty columns, and spaces between blocks of data.
A category name merged across rows is carried down to every row it covers.
Separate blocks of data on one tab can be read as separate lists.
Excel to JSON output should follow the shape of your sheet, so your application can read it without extra cleanup.

Each row becomes one object inside a list.
Keys come from the header row, and you can rename them.
Related columns can be grouped under one key, such as an address with street, city, and postal code.
Empty cells come back as empty values, so no object is missing a key.
Any team that loads spreadsheet data into an application can use an Excel parser in place of manual imports.

Send SKUs, prices, and stock counts to an online store.
Read supplier price sheets and update item records.
Convert bulk order sheets into records ready for processing.
Move customer lists into a CRM with each value in the right field.
Feed sheet totals into dashboards and internal tools.
Spreadsheet data is only useful to your code when the structure is predictable.
Replace one-off conversion code that breaks whenever a column moves.
Workbooks with one layout return the same field names.
Preview the JSON before it goes to another system.
A sheet with thousands of rows follows the same setup as a short one.
Convert the workbook you use most, then add others.
It reads the rows and columns of a spreadsheet and writes them as JSON objects, using each column header as a field name.
ExtractMails works with supported workbooks. Available file types depend on your setup.
Yes. You can pick one sheet, several sheets, or all of them.
They are returned as empty values, so every object keeps the same keys.
Yes. You can compare the output with your sheet before it leaves ExtractMails.
It can be downloaded or sent to supported systems through webhooks and APIs.
No. You choose sheets and fields during setup. Developers can use the API where their plan supports it.
Add ExtractMails to your workflow for Excel to JSON conversion. Upload one workbook, choose the sheets and columns you need, and compare the JSON with the original rows.