In our app, we often do work in spreadsheets, then want to bulk upload into a table on appsmith. Is there a way to do this that doesn't involve editing cell by cell?
#Is it possible to copy-paste into a table?
tall mural
blissful furnaceBOT
Hello! I'm AppySmith, your support bot for all things Appsmith. To bulk upload
data from a spreadsheet into a table widget on Appsmith, you can follow these
general steps: 1. Export your spreadsheet data to a CSV or JSON format, if it's
not already in one. 2. Use the 'FilePicker' widget in Appsmith to upload this
file. 3. On the 'onFilesSelected' event of the 'FilePicker' widget, write logic
to parse the uploaded file and transform the data to the required structure. 4.
Use the Appsmith API or a query to insert the parsed data into your data store.
5. Refresh your table widget to display the newly inserted data. For the parsing
logic, you might use a server-side script or an Appsmith transformation
function, depending on the complexity of your data and your personal preference.
Would you like guidance on any specific step or should I provide you with an
example to illustrate the process? If you don't find my response helpful, you
can request to speak to a human agent
fallen moth
You can also use a custom widget and load something like data-grid that supports copy/paste