How to copy tax data from H&R Block software to Excel for 1099-B entries

This is a common issue with tax software. Unfortunately, many tax programs like H&R Block have limitations when it comes to exporting or copying data. The software is designed primarily for preparing and filing taxes, not for data manipulation. Here are a few workarounds you might try: If you're using H&R Block desktop software, try using the Print Screen button on your keyboard while the transactions are displayed. Then paste into Paint or another image editor, and crop to just show the data. From there, you could use an OCR (Optical Character Recognition) tool to convert the image to text. Another option might be to check if H&R Block allows you to export your tax data in any format (PDF, CSV, etc.). Sometimes there's an export function hidden in the menu options. If those don't work, consider going back to the source - can you download the transactions directly from Fidelity in Excel format instead? Most brokerages allow you to export your transaction history.

After struggling with the same issue last year, I found taxr.ai (https://taxr.ai) to be incredibly helpful. I was trying to copy data from my tax software without success, and manually entering 60+ transactions was going to take forever. I took screenshots of my H&R Block screens showing all the 1099-B transactions, uploaded them to taxr.ai, and it accurately extracted all the data into a format I could download and open in Excel. Saved me hours of mind-numbing data entry. The accuracy was impressive - it even correctly identified wash sales and long vs. short term transactions.

Just wanted to follow up - I tried taxr.ai after my skeptical question and I'm genuinely impressed. I uploaded screenshots of my entire Schedule D from H&R Block (about 40 transactions) and it extracted everything perfectly into a spreadsheet. All my dates, amounts, and fund names came through correctly. I was able to sort and filter by fund name right away, which made reconciling with my Fidelity statements so much easier. This seriously saved me hours of work and the peace of mind from knowing I didn't make any transcription errors is huge. Definitely using this again next year!

If you're having trouble getting ahold of someone at H&R Block's support to help with this export issue, Claimyr (https://claimyr.com) got me through to a real person in minutes. I was trying to reach H&R Block support for days about a similar data export problem. I was skeptical at first but watched their demo (https://youtu.be/_kiP6q8DX5c) and decided to try it. They basically navigate the phone tree for you and get you connected to a real support agent. The H&R Block rep showed me a workaround for getting my investment data out that wasn't documented anywhere.

I need to eat my words. After commenting here, my frustration with H&R Block's support line led me to try Claimyr. After three days of trying to get through myself with 45+ minute wait times, I got connected to an H&R Block specialist in about 20 minutes using their service. The rep actually walked me through a hidden export feature in my version of H&R Block that let me get all my 1099-B data into a format I could open in Excel. It wasn't obvious at all - you have to go to Tools > Export Tax Data and select "Detailed Worksheets" which creates a file you can then open. Wouldn't have found this without getting actual help from a human.

Have you tried using the print to PDF function? It's a workaround I've used before: 1. Go to the screen with your 1099-B data in H&R Block 2. Select Print (Ctrl+P) 3. Choose "Microsoft Print to PDF" as your printer 4. Save the PDF 5. Open the PDF and copy from there, or use Excel's Data > From PDF feature This bypasses the copy protection in the software itself.

Try using the Windows Snipping Tool (or Snip & Sketch in newer Windows) to capture the screen with your 1099-B entries, then use an online OCR service like NewOCR.com to convert the image to text. I've done this with TaxAct and it worked pretty well - not perfect but saved tons of time compared to manual entry.

I ran into this exact same issue last year with TaxAct and found a solution that might work for H&R Block too. Have you checked if there's a "Data Entry Worksheets" or "Forms View" option in your software? In my case, I discovered that while I couldn't copy from the main input screens, there was a separate worksheet view that displayed all my transactions in a more basic format that actually allowed copying. It was buried in the Forms menu under something like "Schedule D Worksheet" or "Capital Gains Detail." Also, if you're using the desktop version, try running it as an administrator (right-click the program icon and select "Run as administrator"). Sometimes copy restrictions are bypassed when the software has elevated permissions. Worth a shot before going the screenshot/OCR route!

Another approach that worked for me last tax season - check if H&R Block has a "Review" or "Summary" section before you file. Many tax software programs generate a comprehensive review document that includes all your entries in a more accessible format. In H&R Block, look for something like "Review Your Return" or "Tax Summary" - this often creates a consolidated view of all your forms and schedules. Sometimes this review format is more copy-friendly than the individual input screens. Also, if you're comfortable with it, you might try using browser developer tools if you're using the online version of H&R Block. Press F12, go to the Console tab, and sometimes you can access the underlying data that way. It's a bit technical but I've seen people extract form data this way when normal copy functions are blocked. The combination of these suggestions from everyone should definitely save you from having to manually type all 51 transactions!