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

Product Version
Mac 2017
Windows 2017
195 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

Still can't find what you're looking for? Try these:

Contact Support

Free expert help from our Quicken
Customer Support team.

Talk to Support
Community

Get help from expert users — the best
place for your tough questions.

Ask Our Community
Premium Support

Get priority access to our expert Quicken agents.
Skip the line and enjoy shorter wait times.

Learn More
Contact Support
Find what you need right now. Or talk to our support team for expert help.
Chat with us Wait time: Estimating...
Call us (650) 250-1900 Wait time: Estimating...
Ask the community