Below is a ready-to-use script. Review and adapt variables to your environment.
Connect-ExchangeOnline Get-EXOMailbox -ResultSize Unlimited | Get-EXOMailboxStatistics | Select DisplayName,TotalItemSize,ItemCount | Export-Csv mailbox_sizes.csv -NoTypeInformation