CSV vs TXF vs Excel: Which Format for Your 1099-B?

You just converted your 1099-B PDF into something usable. But now you're staring at three download options — TXF, CSV, and Excel — and wondering which one actually matters. The answer depends entirely on what you plan to do next with that data.

Whether you're filing taxes yourself, handing documents off to a CPA, or just trying to double-check your broker's numbers before anything else, each format serves a different purpose. This guide breaks down the difference so you can grab the right file without second-guessing yourself.

Quick Comparison: TXF vs CSV vs Excel

	TXF	CSV	Excel (.xlsx)
Best For	Direct import into tax software	CPAs, accounting tools, flexible use	Personal review, manual edits
Works With	TurboTax Desktop, H&R Block Desktop	Excel, Google Sheets, any accounting software	Excel, Google Sheets, LibreOffice
Pros	Fully automated tax import, no manual entry	Universal, lightweight, widely accepted	Pre-formatted, easy to filter and sort
Cons	Desktop-only, not human-readable	No formatting, harder to scan visually	Larger file size, not for software import

TXF Format: The TurboTax Native Format

TXF stands for Tax Exchange Format, and it was built for one specific purpose: letting tax software read your investment data automatically. Instead of typing in each trade by hand, you import a TXF file and the software populates your Schedule D entries for you. It's the format accountants and tax programs were speaking before CSV even became common for this use case.

The file itself isn't designed for humans to read. It's structured data using short codes that tax software understands. For example, transactions are tagged with code 321 for short-term gains and losses and code 323 for long-term gains and losses — the same classification the IRS uses based on whether you held an asset for more or less than a year. The software reads those codes and drops each transaction into the right section of your return automatically.

TXF has one important limitation worth knowing upfront: it only works with desktop versions of tax software. TurboTax Online, H&R Block Online, and most browser-based filing tools do not support TXF import. If you're using desktop TurboTax (the version you download and install), TXF is the cleanest, most direct path to getting your trades imported correctly with zero manual entry.

If you have hundreds of transactions from a busy trading year, TXF is genuinely the most valuable format in the set. One import and your brokerage data flows directly into your return.

CSV Format: The Universal Standard

CSV — comma-separated values — is the workhorse format for data. It's a plain text file where each row is a transaction and each column is a field: date acquired, date sold, proceeds, cost basis, and so on. Almost every piece of software on the planet can open a CSV, which is exactly why it's been the default exchange format for financial data for decades.

For anyone working with a CPA or tax professional, CSV is typically the preferred format to send over. Accountants often use their own accounting software — QuickBooks, Drake, UltraTax, Lacerte — and CSV imports cleanly into all of them. It's also easy to email, lightweight, and doesn't carry any proprietary formatting that might not open correctly on someone else's computer.

CSV is also the right choice if you want to do your own review in a spreadsheet. Drop it into Google Sheets or Excel and you've got a fully functional working file in seconds. You can sort by date, filter by symbol, add a running total column — whatever you need. The downside is it doesn't come pre-formatted, so it opens as raw data without bold headers or freeze panes. For pure flexibility and compatibility, though, nothing beats CSV.

Many accounting platforms like Koinly, CoinTracker, and portfolio trackers also accept CSV uploads directly. If your workflow involves any of those tools, CSV is likely the format you'll end up using most.

Excel Format: The Human-Readable Option

The Excel format (.xlsx) is essentially CSV vs TXF with presentation built in. You get the same transaction data, but it arrives with formatted column headers, proper cell widths, and a layout that's immediately readable without any additional setup. Open it and you're looking at a clean, organized spreadsheet — not raw comma-separated text.

This makes Excel particularly useful for reviewing your data before you file anything. You can scan down the list and verify that dates look right, that cost basis figures match what you remember, and that nothing looks obviously wrong. Sorting by gain/loss amount can quickly surface any outliers worth checking against your original statements. It's a great sanity check step before you commit to importing or sending anything.

Excel format is also the easiest to annotate. If you want to add a column for notes — maybe flagging certain trades for your CPA to review, or adding context about wash sales you identified — Excel makes that simple. You're working in a format everyone knows, and you can share it with anyone without worrying about compatibility.

The main thing Excel isn't great for is software import. Tax programs and accounting tools generally want CSV or TXF, not .xlsx. Think of Excel as your working copy — the format you use to understand and verify your data — rather than the format you submit anywhere.

Decision Tree: Which Should You Choose?

Here's a simple guide based on what you're about to do:

Filing yourself in TurboTax Desktop or H&R Block Desktop? → Download TXF. Import it directly and skip manual data entry entirely.
Sending to a CPA or tax professional? → Download CSV. It works with every accounting platform and is easy to email.
Want to review your trades before doing anything else? → Download Excel. Open it, scan it, verify everything looks right.
Not sure yet, or doing all of the above? → Get all three formats. You're not locked into a decision.

The format question is actually less important than it might feel in the moment. As long as your underlying data is accurate — correct dates, correct cost basis, correct proceeds — any of these formats will serve you well. The format is just the container. What matters is what's inside.

Our Tool Gives You All 3 (So You Don't Have to Choose)

One of the design decisions behind 1099-B Converter was to not make you pick a format before you know what you need. When you upload your 1099-B PDF, the converter extracts every transaction and makes all three formats available for download in one step.

That means you can grab TXF for TurboTax import, CSV for your CPA, and Excel to keep as your own records — all from the same upload, at the same time. No need to upload three times or make a format decision before you understand your workflow. It's a small thing, but when you're dealing with tax prep, removing unnecessary decisions actually matters.

The free tier at 1099-B Converter supports conversions without requiring a login or credit card. If you want to see what your data looks like before committing to anything, that's exactly what the free conversion is for. Run it, download the Excel file, look it over, and then decide how you want to use the other formats.

FAQ: Format Questions

Can I import a CSV into TurboTax?
TurboTax Online has a limited CSV import for certain brokers, but it's specific to their own template format. For most 1099-B conversions, TXF is the correct format for TurboTax Desktop and gives you the most reliable import result without manual cleanup.

Does my CPA need TXF or CSV?
Almost always CSV. Tax professionals use professional-grade software that reads CSV directly, and they often want to map columns themselves. Unless your CPA specifically asks for TXF, send CSV.

Will the Excel file work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and it opens natively in Google Sheets with full formatting intact. It's a reliable format across both platforms.

What's the difference between CSV vs TXF in terms of data?
The underlying transaction data is identical — same dates, same amounts, same cost basis. The difference is purely in format and structure. TXF is encoded for tax software import. CSV is plain text for maximum compatibility. The numbers in both files come from the same source.

Can I convert a TXF back to CSV later?
Not easily. TXF files use a proprietary code structure that's hard to parse without specialized tools. That's another reason to download CSV at the same time you download TXF — treat them as complementary files, not substitutes.

Bottom Line

The CSV vs TXF question doesn't have a single right answer — it depends on your next step. If you're importing into tax software yourself, TXF saves the most time. If you're working with a professional, CSV is the standard. If you just want to see your data clearly, Excel is the easiest to read.

The good news is you don't have to commit to just one. A solid 1099-B converter gives you all three formats from one upload, so you can make the decision after you see what you're working with — not before. Pick the format that fits your workflow, and let the tool handle the rest.

Get All 3 Formats Free (No Login Required) — Upload your 1099-B PDF at 1099-B Converter and download TXF, CSV, and Excel in one step. No account needed, no credit card required for the free tier. See your data before you decide what to do with it.