Thank you for your email.
Yes, you can use our W2 Mate software to import your data from an Excel spreadsheet and then create a W2 electronic filing submission in the EFW2 format ready for upload to the SSA BSO website. We can provide you with a template spreadsheet for W2s and the definition of each of the fields. You can send an email to email@example.com to receive the template. If you provide the name of the legacy accounting system you are using, we might have step-by-step instructions for your system.
For Iowa, our W2 Mate software also creates a file in correct format ready to upload to their online system. You can refer to the post below for more information:
Real Business Solutions Support Team, Makers of W2 Mate, 1095 Mate and Payroll Mate