The Excel files can be opened in Microsoft Excel. If you do not have Microsoft Excel installed on your system, you may open the Excel file in alternative spreadsheet components of LibreOffice, OpenOffice, Ultra Office, etc.   

Export button for all Report types on Ledger analyser 1 / Ledger analyser 2

You may save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type:

oText files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options.

oCSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). 

To save reports or document layout files as a Excel file:

1.On the "Reportman print preview" screen, select Save (Ctrl+S) reportman-preview-icon-save – This will launch the “Save Metafile As” screen. 

2.Select the directory (folder) where you need to save this file, if necessary. 

3.Enter a file name. 

4.Select the "Excel file (one sheet)" or the "Excel file" file type.

5.Click Save.

 

"Excel file (one sheet)" - For example, a Trial balance consisting of 2 or more pages, will be opened in one sheet.

 "Excel file" For example, a Trial balance consisting of 2 or more pages, will be opened in separate sheets for each page (e.g. Sheet1, Sheet2, etc.).


An example, of the "Income statement" saved as an "Excel file (one sheet)" file type, and opened in LibreOffice Calc (spreadsheet) is as follows: