newsoft – Import

Import Dataset

Upload your JSON dataset here. The system will analyze the structure and prepare it for exploration.

Use this prompt to convert your Excel files to the correct JSON format using ChatGPT or other AI tools:

I need you to convert an Excel file into a clean JSON structure. Follow these rules exactly:

1. Use row 5 of the Excel file as the header row (these are the actual field names).
2. Remove all rows that are completely empty.
3. Remove the first column, because it only contains a running index number.
4. If a cell is empty, output an empty string ("") — never null, NaN, or omit the field.
5. Produce a JSON array of objects in this format:
[
  { "field1": "value", "field2": "value", ... },
  { "field1": "value", "field2": "value", ... }
]
6. The JSON must be properly formatted and indented with 2 spaces.
7. If the Excel file uses sharedStrings.xml or is internally structured as an OpenXML ZIP, automatically extract the data correctly (handle it the same way you would for Office XML files).

Return only the final JSON file or provide it as a downloadable file.

Import Dataset

Convert Excel to JSON