Export Barclays US Credit Card Transactions to CSV or Excel

Barclays US is the 9th largest credit card issuer in the United States, with over 20 million cardholders and roughly $32 billion in outstanding receivables. Based in Wilmington, Delaware, Barclays US operates almost exclusively through co-branded credit card partnerships with airlines, hotels, and retailers like JetBlue, Wyndham, Gap Inc., Xbox, Carnival, Priceline, and Frontier Airlines. Despite its massive cardholder base, the Barclays US online portal at cards.barclaycardus.com provides no CSV export, no Excel download, and no spreadsheet-friendly transaction export of any kind. If you need your Barclays US credit card transactions in a structured format for bookkeeping, tax preparation, or accounting software, converting the PDF statement is your best option.

Can You Download CSV Directly from Barclays US?

No. The Barclays US credit card platform does not provide any CSV, Excel, or spreadsheet export. This is a consistent source of frustration for the 20 million people who carry Barclays-issued cards. Here is what you are working with:

• No CSV or Excel export: The Barclays US portal (cards.barclaycardus.com) does not offer any option to download transactions as CSV, Excel, or any spreadsheet format. This applies to all Barclays US credit cards, regardless of card type or brand partnership.
• No direct OFX connection: Barclays US credit cards do not support direct OFX connections, which financial software like Quicken, Moneydance, and QuickBooks rely on for automatic transaction downloads. Users on support forums consistently report failed or broken connections.
• QFX/OFX may exist on legacy portal: Some users report being able to download QFX or OFX files from the older barclaycardus.com/servicing portal, but this is inconsistent, poorly documented, and not available for all card types. It is not a reliable method for ongoing use.
• PDF is the reliable format: Monthly PDF statements are the only consistently available export. You can view and download them from the Statements section of cards.barclaycardus.com or the Barclays US mobile app. Barclays US retains statements for up to 7 years.

The bottom line: Barclays US is one of the most export-limited major card issuers in the country. Chrome extensions and open-source GitHub projects have been created specifically because the native export is so poor. For a reliable, repeatable workflow, downloading the PDF and converting it with CapyParse is the simplest solution.

Barclays Statement Formats and Quirks

Barclays US is a credit-card-only issuer in the United States (it does not offer checking or savings accounts to US customers). All statements follow a credit card format, but the specifics vary depending on the co-branded partner. Here is what to expect:

Key things to know: Barclays US entered the American market in 2004 when it acquired Juniper Financial Corporation, which had roughly 700,000 customers at the time. Today it serves over 20 million cardholders, making it one of the top 10 card issuers by outstanding balance. Unlike Barclays UK, which offers full-service banking with checking accounts, savings, and CSV/OFX export from its online banking portal, Barclays US is purely a credit card operation. All Barclays US cards are managed through the same portal (cards.barclaycardus.com), but statement layouts vary slightly depending on the co-branded partner. CapyParse handles all Barclays US statement variations.

Convert Barclays PDF to CSV with CapyParse (Step-by-Step)

Whether you carry a JetBlue card, a Gap Mastercard, a Wyndham Rewards card, or any other Barclays US product, here is how to convert the PDF statement into a clean spreadsheet or accounting file:

Barclays Card Types and Features

Barclays US goes to market primarily through co-branded partnerships. Unlike issuers like Chase or Citi that offer their own branded cards alongside co-brands, nearly every Barclays US card carries a partner brand. Here are the major card families:

JetBlue Cards

The JetBlue partnership is one of Barclays' flagship programs in the US. Barclays issues three consumer JetBlue cards: the JetBlue Card (no annual fee), the JetBlue Plus Card ($99 annual fee, 6X points on JetBlue purchases, 2X at restaurants and grocery stores), and the JetBlue Business Card. JetBlue cards earn TrueBlue points that can be redeemed for flights. Statements include a rewards summary showing points earned during the billing cycle, plus any anniversary bonus or companion certificate status. CapyParse extracts all transaction data from JetBlue card statements, including the purchase categories that determine your points multiplier.

Gap Inc. Cards (Gap, Old Navy, Banana Republic, Athleta)

Barclays is the exclusive credit card issuer for all Gap Inc. brands, with Mastercard as the exclusive network. Each brand has its own card (Gap Encore Mastercard, Old Navy Encore Mastercard, Banana Republic Encore Mastercard, Athleta Encore Mastercard), but they all share the same rewards structure: 5 points per dollar at any Gap Inc. brand and 1 point per dollar everywhere else, with no annual fee. Applicants are first considered for the Mastercard version (usable anywhere), and if not approved, they are automatically considered for the store-only credit card. Statements show spending across all four Gap Inc. brands with combined points tracking. CapyParse handles these statements and correctly separates purchases, rewards credits, and payments.

Wyndham Rewards Cards

Barclays issues the Wyndham Rewards Earner suite of cards, which earn Wyndham Rewards points redeemable at 9,000+ hotels worldwide. The Wyndham Rewards Earner Card earns 5X points at Wyndham hotels and on gas, 2X on dining and groceries, and 1X everywhere else, with Gold elite status included. Higher-tier versions offer Platinum status and additional perks. Statements include rewards point summaries and may reference hotel night redemption thresholds. CapyParse extracts the full transaction detail from Wyndham card statements.

Xbox Mastercard

The Xbox Mastercard is one of Barclays' more unique co-branded products, designed for gamers. It earns card points that can be redeemed for Xbox gift cards, Game Pass subscriptions, and other Microsoft gaming products. There is no annual fee and no foreign transaction fees. Statements follow the standard Barclays US format with a rewards points summary section. CapyParse processes Xbox Mastercard statements the same as any other Barclays card.

Carnival, Priceline, and Frontier Airlines Cards

Barclays also issues co-branded cards for Carnival Cruise Line (the Carnival World Mastercard), Priceline (the Priceline Rewards Visa), and Frontier Airlines (the Frontier Airlines World Mastercard, with a $99 annual fee and 5X miles on flyfrontier.com purchases). Each card has its own rewards structure, but all share the same underlying Barclays US statement format. The Frontier card includes a $100 flight voucher anniversary bonus when you spend at least $2,500 per year. CapyParse handles all of these card types.

Former AAdvantage Aviator Cards

Barclays previously issued the AAdvantage Aviator Red, Silver, and Business cards for American Airlines. As of late 2025, Citi took over the AAdvantage credit card portfolio from Barclays, and existing cardholders are being migrated to Citi products throughout 2026. If you still have older Barclays AAdvantage statements that need conversion, CapyParse can process those PDFs as well.

Import Into QuickBooks, Excel, or Google Sheets

QuickBooks

Barclays US does not support direct OFX connections to QuickBooks, and the inconsistent QFX availability on the legacy portal makes automated downloads unreliable. The most dependable approach is to download your Barclays statement as a PDF, convert it to QBO format using CapyParse, and import it into QuickBooks via Banking > Upload transactions. This works for both QuickBooks Desktop and QuickBooks Online. For a detailed walkthrough, see our guide on importing bank statements into QuickBooks.

Excel and Google Sheets

The CSV export from CapyParse opens directly in Excel or Google Sheets. All transaction fields (date, post date, description, amount, type) land in separate columns, ready for sorting, filtering, pivot tables, or custom formulas. This is particularly useful if you carry multiple Barclays co-branded cards and want to consolidate your spending across JetBlue flights, Gap purchases, and Wyndham hotel stays in a single workbook. For more details, see our Google Sheets import guide.

Xero and Other Accounting Software

Xero, FreshBooks, Wave, and Sage all accept CSV imports for bank transactions. Export from CapyParse in CSV format and follow the import wizard in your accounting platform to map the columns. Since Barclays US does not support any automated bank feeds reliably, this manual file upload approach is the most consistent method. See our guides for Xero, Wave, or Sage.

Need to convert QBO or OFX files instead? Check out our QBO to CSV conversion guide.

Tips for Barclays Conversions

Frequently Asked Questions

Related Articles