The account names for subaccounts in Modern view are formatted as parent# parent name:sub# sub name while in Spreadsheet Sync they are sub# parent name:sub name. This mismatch in the formatting of the names is creating issues for data load and validation.