Hi
I am a happy Glide developer but I am getting very nervous when using the import feature.
I have a .csv file with 6988 rows and 10 colums. Everytime I get different number of rows imported when I import the file. It’s not the same rows that is left out.
The table is very simpel:
What to do ?
Kind regards
Peter
Hi Peter, ideas to help you troubleshoot:
- Go the the table you want to import to.
- Export that table.
- Open that table in Excel or Google Sheets. You now have your template spreadsheet.
- Remove the data from that spreadsheet starting row 2. Leave row 1 with the columns headers.
- Without changing anything (don’t change the order of the column), put the data you want to import inside this sheet. If need be, duplicate the sheet and work on the duplicate. At the end of the day, the template sheet is the one you want to stick with.
- Make sure you don’t have empty rows of data in the middle of your data.
- Make sure you don’t have tons of empty rows of data at the end (below) the data.
- Once all the data is in this template sheet, remove any other sheets in the spreadsheet.
- Save to csv.
- Import to the table in question in the data editor.
Is this what you did?
