I’m new to Glide and building an self-serving app for business use. This app needs to show data from Excel files on dashboards every day. The data is about product orders and changes daily, so users have to upload a new file each day.
Right now, I’m using a form with a file picker for users to upload their Excel files. But after uploading, I only see a link to the file, not the actual data inside it.
I need a simple way to get the Excel file data to show up in Glide tables after it’s uploaded. So we can create the dashboard based on the Glide tables. Any advice on how to do this?
Simple…no. Something like that would probably require passing the uploaded file to a third party service like Make, have it iterate through all of the data, and then send it to Glide via the Glide API. A CSV file is one way to do it, but would probably require a modified process to do the same with an Excel file.
i think you can look into Microsoft Power automate. this has recently added into i believe windows 11 package and/or the standard package. with this you can copy and transfer data into the cells of the excel sheet with recorded steps. with the data now in the cells of the sheet. i believe glide columns can display the data as you want. i hope this helps and if i explained this correctly.