So I have a CSV of Accounts I need to import. I was able to get the account IDs for existing accounts (because some of the account names match). So now my spreadsheet has existing accounts to be updated, and new accounts. The account ID of new accounts are blank in the CSV.

When I try to import this CSV, the existing accounts update, but no new accounts are created. I've tried running the import as "Both Update and Add New" and also just "Add New Accounts". But the new accounts will not add.

Any suggestions?