How to Open CSV File in Google Sheets

CSV files are used in the Back Office for exporting reports, importing-exporting items, and clients.

To open this type of file, you can use Google Sheets.

Go to Google Sheets and click on the button ‘Start a new spreadsheet’.

Google Sheets with the button ‘Start a new spreadsheet’  Sheet


Go to the ‘File’ menu and click on the ‘Import’ button.

‘File’ menu and ‘Import’ button.excel


Go to the ‘Upload’ tab of the ‘Open a file’ window and select your file from your computer.

the ‘Upload’ tab of the ‘Open a file’ window

In the Import file settings window, unselect the checkbox ‘Convert text to numbers, dates, and formulas', and then click on the ‘Import data' button.

unselect the checkbox

As a result, you have opened a CSV file as a table.

opened CSV file

Now you can edit this spreadsheet.
If you want to save the spreadsheet in the CSV format to your computer for further importing in the Loyverse Back Office, go to ‘File’ menu, select ‘Download as’, and click on ‘Comma-separated values’ button.

saving the spreadsheet in the CSV format

 

See also:

How to Export Data from Reports and Open in LibreOffice Calc or OpenOffice Calc

How to Export Data from Reports and Open in Excel

Importing and Exporting Items