Users can import CSV, XLSX, and ODS files into Glide Tables and Glide Big Tables. When the data is imported, Glide attempts to detect the type of data each column represents (e.g., number, email, date, text). If you import a CSV file and the auto-detection gets a column type wrong, try converting the file to the ODS format and then importing again.
Convert a CSV file to ODS using Microsoft Excel
Open the CSV file in Microsoft Excel
Under the File menu, select Save As, and choose Download as ODS or set the file format to ODS
Save the file to your local device
Convert a CSV file to ODS using Google Sheets
Open the CSV file in Google Sheets
Under the File menu, select Download, and choose OpenDocument (.ods)
Save the file to your local device
Import an ODS file into a new Glide Table
Open your app in the Builder and navigate to the Data tab
Click the plus sign (+) to add a new data source and choose Blank Table
A new table will be added on the left side of the screen
Give the table a name or accept the default
Right-click the table name and click Import...
In the modal, click Choose a file
Select the ODS file on your local device and click Open
Click Continue