Skip to main content
January 31, 2022
Question

how can we covert pdf file of w-2 to excel

  • January 31, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

January 31, 2022

Hi, co8.

 

You can only open or export the form to Excel or as a PDF file. Neither of the two options you choose, you'll need to manually convert them to Open Office.

 

Here are the steps:

  1. Open a file in Acrobat.
  2. Click on the Export PDF tool in the right pane.
  3. Choose spreadsheet as your export format, and then select Microsoft Excel Workbook.
  4. Click Export. If your PDF contains scanned text, Acrobat will run text recognition automatically.
  5. Name the Excel file and save it in the desired location.

For more information on downloading W-2s, click here.

 

Here's an article for the list of payroll reports that can be exported to Excel in QBDT: Excel-based payroll reports. It also provides a step-by-step guide on how to generate them in the system.

 

You can refer to this article for more recommended solutions: Troubleshoot PDF and Print problems with QuickBooks Desktop.

 

In case you need help with other tasks in QBDT, browse this link to go to our general topic with articles.

 

Please let me know if you have other payroll concerns or anything about QuickBooks. I'm just around to help. Take care always.