Technical FAQs—Downloading transactions to a spreadsheet

You can download your transactions into most spreadsheet programs (such as Microsoft Excel). Using this option, you'll save your transactions as a comma-delimited file, also known as a comma-separated value (.CSV) file, to your computer and import it into your spreadsheet program.

You don't need to select a download option when using the .CSV file format. When you download a .CSV file, all funds with the same Vanguard account number will be grouped together. Open the .CSV file in your spreadsheet software and manually remove any duplicate transaction entries.

You cannot import .CSV spreadsheet files into financial software packages, like Money or Quicken. Once you have downloaded the file, you do not need to maintain an Internet connection. Also, note the following:

  • You'll need to manually copy transactions into your spreadsheet program, set up any formulas necessary to calculate balances, and create charts to analyze your data.
  • You're responsible for ensuring that your transactions are downloaded and that you do not have duplicate transactions recorded. Your spreadsheet software cannot check for duplicate or missing transactions.
  • If you're calculating your balance on the spreadsheet, you must update your spreadsheet with the number of shares you owned before your first transaction. You can adjust the download start date to a convenient date for downloading, such as the beginning of a year or quarter.

For technical support, contact the manufacturer of your spreadsheet software.

Note: Vanguard warrants that all account information on is accurate. Vanguard is not responsible, however, for any errors associated with the subsequent use of such information by shareholders, including but not limited to the downloading of such information for use in preparing tax returns or financial-planning packages.