CSV files are commonly used in the Loyverse Back Office to export reports and to import or export items and customers. You can easily open and edit these files using Google Sheets.
Opening a CSV File in Google Sheets
Go to Google Sheets.
Click Start a new spreadsheet.
Open the File menu and select Import.
In the Open a file window, switch to the Upload tab.
Upload your CSV file by selecting it from your computer or dragging and dropping it into the window.
In the Import file settings window:
- Uncheck the option Convert text to numbers, dates, and formulas.
- Click Import data.
Your CSV file will now open as a table in Google Sheets.
Editing and Saving the File
You can edit the spreadsheet as needed.
If you want to save the file in CSV format for further importing into the Loyverse Back Office:
Open the File menu.
Select Download.
Choose Comma-separated values (.csv).
The file will be downloaded to your computer and will be ready for upload back into Loyverse.
This method helps ensure that your data format remains correct and prevents errors during import.
See also:
How to Export Data from Reports and Open in LibreOffice Calc or OpenOffice Calc