Import csv or excel too slow

[Tony.Nguyen]

I actually use this, so I don’t have to deal with pandas and anvil.media:

Upload CSV file into data tables

The easiest way is to use excel to make a new column and then make a dictionary contain data of all cells. Then copy all rows of dics into a list in server module. Then insert each item to table.

Upload CSV file into data tables

It is my excel formular ="{'id': """&A5400&""", 'name': """&C5400&"""}," And here is the server code my_list = [ {'id': "real_value1", 'name': "real_value2"}, {'id': "real_value2", 'name': "real_value2"} ] for item in my_list: app_tables.my_table.add_row(id=item["id"], name=item["name"])