Loyverse allows you to export reports from the Back Office in CSV format, which can be opened and edited using spreadsheet applications such as LibreOffice Calc or OpenOffice Calc.
Exporting a Report from the Back Office
Log in to the Back Office and open the Reports section.
Select the report you want to export (for example, Sales by category).
Choose the required reporting period.
Click the Export button.
Enter a file name and save the file to your computer.
The report will be downloaded as a CSV file.
Opening the CSV File in LibreOffice Calc or OpenOffice Calc
Open LibreOffice Calc or OpenOffice Calc.
Go to File → Open (or press Ctrl + O) and select your CSV file.
The Text Import window will appear.
In the Text Import window, configure the following settings:
- Character set: select Unicode (UTF-8)
- Separator options:
Select Separated by
Check Comma
Once these options are selected, the preview window will display the data as a table.
Click OK to open the file.
The exported report will open as a spreadsheet, allowing you to view, analyze, and edit the data as needed.
This method ensures correct data formatting and helps prevent issues with special characters or incorrect column separation.
See also: