Instructions for Excel-to-Python Converter

Excel File Format

File's first row should be the column names. Keep only the first row for column names and second row for the data and formulas.

We currently do not support multi-row formulas and arrays.

Currently Supported Functions

• AND
• AVERAGE
• AVERAGEIFS
• IF
• IFERROR
• MAX
• MAXIFS
• MIN
• MINIFS
• OR
• SUM
• SUMIFS
• VLOOKUP

Planned Function Support

Coming Soon: COUNTIF, COUNT, SUMIF

Identified Limitations

SUMIFs within other sheet is not possible as of now

VLOOKUP - No approximate match allowed

MAX - It ignores NAN in python code while Excel gives error in Nan