How to convert an excel spreadsheet to python data structures
- Step 1Upload your Excel file — Drop an .xlsx or .csv. The first sheet is read into a row array.
- Step 2Choose output format — Select list_of_dicts for quick iteration, dict_of_lists for column access, or pandas for DataFrame creation.
- Step 3Copy or download the Python code — The snippet is shown in a code preview. Copy to clipboard or save as data.py.
Frequently asked questions
How many rows are included?+
Up to 500 rows are inlined in the generated code. A comment notes the truncation if the file has more. For large files use pandas.read_excel() instead.
Are None values handled?+
Yes. Empty cells become Python None in the generated code.
Does it handle multi-sheet workbooks?+
Currently only the first sheet. Multi-sheet Python generation is on the roadmap.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.