cancel
Showing results for 
Search instead for 
Did you mean: 
hozak
Level 1

How do I convert w2's to .csv file

Pennsylvania  wants all w2's uploaded via a .csv or EFW2 file.  How do I convert my w2'S to a csv file?

6 Comments 6
Anonymous
Not applicable

How do I convert w2's to .csv file

Nelda
Level 1

How do I convert w2's to .csv file

This saves in the txt format. I cannot convert to .csv file for submission to the state of pennsylvania. Please advise.

SterlingD
QuickBooks Team

How do I convert w2's to .csv file

Welcome to the Community, @hozak.

 

I'll be happy to explain how to convert W-2s from .pdf to .csv.

 

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.

 

Please remember, I'm always here for any other questions or concerns.

modest hawking
Level 1

How do I convert w2's to .csv file

You can use https://www.docuclipper.com to automatically convert W2-s to Excel. They have a video showing how: https://www.youtube.com/watch?v=Iw0xPBhL-9g

Tutorial on how to extract information from W2 documents using DocuClipper. https://www.docuclipper.com/docuclipper
NotoriousCPA
Level 1

How do I convert w2's to .csv file

These answers are useless information for what the person is trying to accomplish.

 

PA has a specification format that is 29 columns long.  QB Desktop says that it spits out a file that you can submit electronically through the state site (etides), but that's not true.  no one at QB can help or knows anything about the actual requirement.  They tell you to call the state.  You then end up entering everything by hand.

NotoriousCPA
Level 1

Need to get in touch?

Contact us