We encountered this problem today, which was the first import after upgrading from 2018 to 2021. We figured out that the format of the IIF file must now be tab-separated as opposed to comma-separated. It's an easy fix you can do in notepad, or you can do it when you select the file type to save from Excel.

Worked for us.