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 separator 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.

Leading zeros are removed when I export to Excel

By default, Excel removes leading zeros in number fields. But, some users need to retain exported zeros (for use in payroll software, for example).

To work around this:

  1. Select cells with leading zeros you wish to retain.
  2. Right click on the selected cells, and click the Format cells option.
  3. Under the General tab, click Custom.
  4. Type a 0 for each digit you want to retain. For example, type 00000 to retain an imported value of 00121.

Or, you could open exported CSV files in software that retains leading zeros, such as Notepad, rather than Excel.

Some numbers display in date format in the export

Numbers may display using a date format if you export a report using .csv format. To fix this, change your export format to .xml.