I'm running into an issue while importing data from Excel to create tables.
When I import an Excel or CSV file, the data isn’t fully uploading. The first row (header) appears fine, but rows 2 to 99 are completely missing—only row 100 and beyond get imported. Strangely, on the pre-import table setup screen, the first four cells show up correctly, but once I click "Next," 99 rows just disappear.
For reference, my dataset has 2,380 rows in total, including the header.
On the other hand, when I use the Google Sheets API or Excel to link tables, all the data loads correctly, but the page becomes super slow, making it hard to use efficiently. It’s convenient, but right now I’m working with 2,380 rows, and I plan to import over 5,000 rows in the future, so I’d love to get the direct import working smoothly.
Also, if there’s a way to dramatically speed up the Google Sheets API loading, I’d love to know!
Hi, Good morning !
I'm running into an issue while importing data from Excel to create tables.
When I import an Excel or CSV file, the data isn’t fully uploading. The first row (header) appears fine, but rows 2 to 99 are completely missing—only row 100 and beyond get imported. Strangely, on the pre-import table setup screen, the first four cells show up correctly, but once I click "Next," 99 rows just disappear.
For reference, my dataset has 2,380 rows in total, including the header.
On the other hand, when I use the Google Sheets API or Excel to link tables, all the data loads correctly, but the page becomes super slow, making it hard to use efficiently. It’s convenient, but right now I’m working with 2,380 rows, and I plan to import over 5,000 rows in the future, so I’d love to get the direct import working smoothly.
Also, if there’s a way to dramatically speed up the Google Sheets API loading, I’d love to know!
Looking forward to your advice!
Thanks!