Troubleshooting Conversion from Excel

There are some things that can cause your conversion to fail.

 

The best rule to follow is that if your worksheet fails to convert, try selecting only those rows and columns that contain the REQUIRED data and Copy, and the Paste-As-Values into a new worksheet.

 

Also, you must ensure that every column in your sheet has a header and that all rows are fully populated (all columns should have the same number of entries).

 

In the image below, please note that there is one cell with a "comment' that is not part of the actual data:

This will cause our converter to fail because it detects "potential data" in a cell that has No Column Header AND is not a fully populated column.