Migrating from Google Sheets - Long Text an issue?

[coldcoffee]

Hello! I'm trying to migrate a very small amount of data from Google Sheets to AppSheet DB and having a heck of a time with just one of my tables, which happens to have a column of LongText with some hard returns in it

I have tried importing the data leaving that column empty, and hand pasting just that column info but the error I get is "cannot paste more than 500 rows" - there are only 75 rows

So I thought I'd go the super tedious route and hand paste cells individually. In that case, Appsheet DB asks if I want to paste it across 25 rows. The options are "OK" or "Cancel"

How can I get my data in there?

[SkrOYC]

Did you try by using another method like "add a new row to another table using values from this row" with a bot executed on all rows of your current table?

[coldcoffee]

I have not gotten to the stage of writing Actions yet, still trying to import the data