PNC Bank lets you download your transaction history directly from online banking in CSV format — which opens cleanly in both Google Sheets and Excel. Whether you have a standard checking account or a PNC Virtual Wallet, the export process is similar across account types.
This guide walks through the full export process step by step. If you manage PNC alongside accounts at other banks — or you want your transaction data to stay current without manual downloads every week — the end of this guide covers how to connect PNC to a spreadsheet automatically so new transactions arrive in your spreadsheet daily on their own.
How to export PNC transactions as a CSV
Step 1: Log in to your PNC account
Go to pnc.com and sign in to online banking.
Step 2: Select your account
From the account summary, click on the checking, savings, or credit card account you want to export.
Step 3: Find the download option
In your transaction history view, look for a Download Transactions link or button — typically located above or near the transaction list. PNC may label this as ‘Download’ or show it as an icon.
Step 4: Choose your date range and file format
- Select a date range for the transactions you want.
- Choose CSV as the file type for best compatibility with Google Sheets and Excel.
- PNC may also offer OFX and QFX formats. These are designed for Quicken and aren’t ideal for direct import into a spreadsheet.
Step 5: Download the file
Click Download and save the CSV file to your computer.
Note for PNC Virtual Wallet users: The Virtual Wallet interface organizes accounts into Spend, Reserve, and Growth categories. Each account type can be exported separately using the same steps above. Just select whichever account you want from the account list first.
How to open your PNC CSV in Google Sheets
- Go to sheets.new to open a new Google Sheet, or go to the home page for your Google Drive or Sheets account.
- Click File → Open → Upload.
- Drag and drop your downloaded CSV file or click Browse to locate it.
- Google Sheets will import the file and display your PNC transactions.
How to open your PNC CSV in Microsoft Excel
- Open Excel and click File → Open.
- Browse to your downloaded CSV file and open it.
- If the Text Import Wizard appears, select Delimited, click Next, check Comma, and click Finish.
- Your PNC transactions will appear in columns ready to work with.
For Excel Online, go to excel.cloud.microsoft, click Upload a File, and select your CSV.
PNC’s CSV typically includes columns for Date, Description, Withdrawals, Deposits, and Balance. You may want to consolidate the Withdrawals and Deposits columns into a single Amount column (using negative values for withdrawals) and add a Category column before merging with an existing transaction sheet.
Limitations of manual PNC exports
Manual CSV exports from PNC work but have some limitations for consistent financial tracking.
- Separate exports per account: Each PNC account requires its own separate download.
- Limited window: PNC typically limits exports to 90 days at a time. Longer histories require multiple exports stitched together.
- Split amount columns: PNC’s CSV uses separate Withdrawals and Deposits columns rather than a single signed Amount column, which requires cleanup before the data can be used with standard spreadsheet formulas.
- No scheduling: There’s no automated export option. You repeat the full process manually every time you want updated numbers.
- Pending transactions: Pending transactions typically don’t appear in CSV exports.
Automate PNC transaction tracking with Tiller
If you’re tracking PNC alongside other financial accounts, or just want your spreadsheet to stay up to date without manual effort, Tiller eliminates the entire export process.
Tiller connects your PNC accounts directly to Google Sheets or Excel and delivers transactions automatically each day. Your PNC Spend, Reserve, and Growth accounts, plus any PNC credit cards, appear already formatted in your spreadsheet alongside accounts from other institutions. Tiller’s Foundation Template lets you keep a clear view of your finances in one place.
AutoCat handles categorization based on rules you set. After a few weeks of setup, most recurring transactions, such as your PNC monthly service fee, regular merchants, and bill payments, categorize themselves automatically.
Frequently asked questions
Q: Can I export all my PNC Virtual Wallet accounts at once?
No. PNC requires a separate download for each account. If you have Spend, Reserve, and Growth accounts plus a PNC credit card, that’s four separate exports to run and combine. Tiller connects all PNC account types simultaneously and consolidates everything into one spreadsheet automatically.
Q: How far back can I download PNC transaction history??
PNC typically allows exports covering up to 90 days per download. For longer histories you’ll need to run multiple exports covering different date ranges and combine them manually. Check PNC’s current online banking interface for the exact limits available on your account type.
Discover pre-categorizes some of my transactions. Can I use that in my spreadsheet?
In Google Sheets or Excel, add a new Amount column and use a formula to combine them. If the Withdrawals column has a value, use that as a negative number; if the Deposits column has a value, use that as a positive number. A formula like =IF(C2<>"", -C2, D2) works if withdrawals are in column C and deposits are in column D. Tiller handles this formatting automatically, so you never see the split-column issue.
Q: What file format should I choose when downloading PNC transactions?
Choose CSV for Google Sheets or Excel. PNC may also offer OFX or QFX formats, but these are designed for Quicken and aren’t the right choice for direct spreadsheet import.
Can Tiller automatically import Discover transactions into my spreadsheet?
Yes. Tiller supports PNC account connections, including Virtual Wallet accounts, and delivers daily transactions to Google Sheets or Excel alongside your other financial accounts.
