I’m relatively new to Glide and have been testing the app for about a month, finding it quite impressive. I’ve successfully developed a project management app using Glide tables exclusively. Currently, I’m working on adding a feature that allows users to export data (multiple rows) from Glide tables, make changes in excel, and then re-import the modified data back into Glide tables.
The goal is to streamline the updating process, especially when dealing with multiple tasks related to a specific project. For instance, users should be able to export project-related tasks, make necessary modifications in Excel (such as editing or adding tasks), and then efficiently re-import the updated data back into Glide tables.
I’ve explored online resources for a solution but haven’t found one yet. I would greatly appreciate it if someone could offer guidance or assistance with this. Thank you in advance for your support!
Glide doesn’t support CSV import via the front end natively. It’s possible, but not a simple thing to do.
But, a question: why is this even necessary? Glide provides all the capabilities you need for editing data in the App, why do you find it necessary to export the data just to modify it?
Thank you, Darren. The ability to perform bulk imports is incredibly beneficial for end users, especially when dealing with a substantial number of activities or cost codes within a project(~300). Instead of manually adding each item one by one in the app, users can streamline the process through bulk importing.
Moreover, users might find it necessary to export all activities to adjust the budget for each activity. In such cases, exporting the data to Excel, multiplying the budget by a factor or deleting some activities, and subsequently importing it back into the app becomes a more efficient alternative to manually updating each budget entry. (Excel is still the easiest, quickest and efficient tool to analyse numbers)
Given these scenarios, a seamless integration between Glide and Excel would be highly advantageous. However, I’ve come across some posts indicating that the process involves platforms like Make or Zapier, which might be challenging for those without a background in IT or software development, myself included.
Yes, if you want to do bulk update operations, the only practical way to do that at the moment is by using the Glide API.
However, Glide are working on enhanced automations which should provide much of the sort of functionality you are describing, so there is some light at the end of the tunnel. Indications are that we’ll see some of these enhanced capabilities arrive within the next few months (don’t quote me on that).
That would be amazing, can’t wait for this feature, it be a game changer for glide! I checked the video you sent me above and this is good for adding multiple rows, is there a video/tutorial on how it was done step by step for beginners like me :)?
Below is one I made a while back that shows how to update multiple rows using the Call API action. The same thing could be done using a Trigger Webhook → Make → Glide API.