Replicon logo

Help Project Managers

Exporting a report to Excel or PDF

You can export report data to Excel or to PDF.

Exporting report data to Excel

Before exporting data to Excel, check that your Excel export settings are configured appropriately.

Configuring Excel export settings

You can choose the Excel file format the report will be exported to – either .xml or .csv. If you choose .csv, you can choose what character is used as a separator in exported CSV files.

To configure Excel export settings:

  1. Click the  icon in the top, right-hand corner of the page, and select Settings.

  1. From the Report Excel Export Format field, choose .xml if you’re using Excel XP or higher, and .csv if you’re using an older version of Excel.

  1. If you selected .csv format, enter the character that should be used as a field seperator in reports exported to Excel.  This field is set to comma (,) by default.
  2. Select Compress Excel Email Attachment if you want email attachments to be compressed and sent as .zip files. This can be useful in decreasing the file size when sending large reports.
  3. Click Save.

Exporting data to Excel

To export data to Excel:

  1. Go to Reports, and open the report whose data you want to export.
  2. Click the  icon in the top, right-hand corner of the report.

The Excel file will be generated.

Exporting report data to PDF

To export data to Excel:

  1. Go to Reports, and open the report whose data you want to export.
  2. Click the  icon in the top, right-hand corner of the report.
  3. Select print options in the dialog that displays.

You can choose the page size, orientation, font size, and margins. You can also choose to include page or column headers, page numbers, and a report header on its own page, and to separate report groupings with page breaks.

  1. Click Export.

The PDF will be generated.

FAQs

Why can't I open an export in Excel?

The report or export likely uses .xml format. Files of this type often open in a web browser by default, rather than in Excel.

To open this type of report or export in Excel:

  1. Open Excel.
  2. Open a blank workbook.
  3. Select File > Open, and select the report or export file.

Can I set the currency symbol and amounts to appear in different cells in exports?

Yes, you can. To set the currency symbol and amount to display in different cells.

  1. Click the  icon in the top, right-hand corner of the page, and select Settings.

  1. Select the Separate Currency and Amount check box, which is located at the bottom of the page.

  1. Click Save.

Related links

Emailing and printing reports
Saving and sharing reports
I can't open an Excel report or export