How To Export Quicken Reports to Other Program Formats Such as Excel

Applies to:
Business
Deluxe
Premier
Starter
Updated: March, 29 2024 4:04PM
đź‘Ť   people found this helpful
Windows
Mac

Overview

You might want to work with your Quicken data in another program such as Excel. You can copy report information from Quicken and paste it into the other program, or you can export the report information from Quicken to another program.

Instructions

To copy and paste report data to Excel

  1. Open the report you would like to copy.
  2. Select the Export Data drop-down menu at the top of the report and select Copy to Clipboard.
  3. Switch to your word processing or spreadsheet program.
  4. Position the cursor where you want the data pasted.
  5. Use the program's Paste command (usually it's on the Edit menu).

For more information about pasting the report data into another programs, consult the documentation for the other programs.

To export a report to an Excel Workbook

  1. Display the report you want.
  2. Click Export Data. (Quicken displays the Export Data button only for reports, not graphs.)

  1. Choose Export to Excel Workbook.

  1. In the File name field, enter a name for the file.
  2. Switch to Excel.
  3. Use Excel's Open command and navigate to the file containing your report data. Quicken stores the file in the Quicken folder by default.

Overview

You might want to work with your Quicken data in another program such as Excel. You can copy report information from Quicken and paste it into the other program, or you can export the report information from Quicken to another program.

Instructions

Comparison and Summary Reports

The Comparison and Summary Reports can be exported to a CSV file, which can be opened in spreadsheet applications like Numbers and Excel or you can Copy to the Clipboard and paste into a spreadsheet application.

To export a Comparison or Summary Report:

  1. While viewing the report, click Export in the button bar underneath the report title.
  2. Select Export to CSV file.
  3. Choose the name and location of the CSV file to be created and click Save.
  4. In your spreadsheet program, open the file.

To copy a Comparison or Summary Report to Another Application:

  1. While viewing the report, click Export in the button bar underneath the report title.
  2. Select Copy to Clipboard.
  3. In another application like a spreadsheet or word processor, paste the report.

Category and Tax Schedule Reports

The Category Summary and Tax Schedule reports can be exported to a Comma Separated Value (CSV) file, which can be opened in spreadsheet applications like Numbers and Excel.

To export a Category Summary or Tax Summary Report to CSV:

  1. While viewing the report click the Export CSV button at the top of the screen.
  2. Choose the name and location of the CSV file to be created and click Save.
  3. In your spreadsheet program, open the file.
Article ID: GEN82141

Agent Notes

In This Article

    Welcome! âś–

    Still need help? Contact Us

    Or Contact Us:
    Product Support
    For the best support experience, please sign in with your Quicken ID. We'll find your account and get you to the right team:
    For Sales & Renewals, or if you're having trouble signing in: