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

Product Version
Mac 2016
Mac 2017
Windows 2016
Windows 2017
192 people found this helpful

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.

Quicken for Windows

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 a tab delimited text file

  1. Open the report you would like to use in another program.
  2. Select the Export Data drop-down menu and select To Excel compatible format.
  3. In the Look in list, select a location for the file.
  4. In the File name field, enter the file name.
  5. Click Open.

A tab-delimited text file is created with the name and location you specified. For information about viewing this file in Excel, consult the Excel Help system.

Quicken for Mac

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.
Help us improve our support center

Still can't find what you're looking for? Contact Support

Ask our community for help and to learn more about Quicken

Ask the community