I have a basic text column with a few different types of values used as row identifiers. The rows are coming in via integration, and there are good reasons why I’m not using a Row ID column. When I generate a CSV, I’m have some of them turned into scientific notation. And not even accurately! (rounded). For the relations to work in the table into which they will be imported, I need them to stay as-is. Any way to coerce it? The overall scenario is archiving records to a separate app using big tables.
Are they actually that way in the CSV file itself, or is the spreadsheet you are using rendering it that way?
Maybe there’s a different way to do this altogether, but my process is use workflows to generate and open the CSV. When I open the CSV in my browser it’s a URL that starts https://storage.googleapis.com/glide-prod.appspot.com/uploads-v2/5v…
In Chrome, these CSVs open in a “Basic editor for Microsoft files” with an option to Save as Google Sheets. So it’s more like a glorified file viewer than an actual spreadsheet. The screenshot is from that file viewer. Is there a way to generate and download CSVs from Glide and/or inspect the file directly?
I guess it depends on the browser and how those files are served up, but I guess the point I’m getting at is if you can download and view the raw CSV in notepad or some kind of text editor, you should see a bunch of rows of comma separated values. You are viewing it in what I assume is a stripped down version of Excel. Spreadsheets have a habit of guessing the data type of each column and sometimes it gets it wrong. The raw data is correct, but it’s being formatted incorrectly in the viewer.
It’s probably correct in the CSV.
Sorry if this is a dumb question, but how do I download a CSV that is generated by Glide? It’s not a menu choice in the viewer.
I figured it out! If I click on the link in the Glide data table to highlight it, then right-click, I can save the file locally. Uploading the saved file works beautifully, no formatting applied. 