Is there a way to optimize a csv to Excel automation such as a csv to Google Sheets one?

How To
, ,
1

Hi everyone!

I’ve just started using Make.com because I wanted to automate tasks to save time on preparing and collecting data for reporting.

I began by setting up an automation that transfers data from a downloaded CSV file to Google Sheets, which worked quite well. Later, I discovered I could achieve the same with Excel, so I attempted to implement it there as well.

The main drawback is that doing the same thing with Excel is noticeably heavier and slower in my automation.

I’m wondering if there’s a more optimized solution you could suggest?

My main requirements for this automation are:

  • Always update existing row values
  • Add new rows as they appear

The Google Sheets module has a “Bulk Update Rows” option, which essentially does what I need. However, I couldn’t find a similar option for Excel.

Here’s the Google Sheets scenario:

And the resources it used:

Here’s the Excel scenario:

And the resources it used (it adds rows one by one, which seems less efficient):

Thanks in advance for any recommendations!

2

That’s a great idea! I’m sure others would agree that this is a nice feature to have.

It looks like the API endpoint exists here: TableRowCollection: add - Microsoft Graph v1.0

Somebody just needs to add this module.

You can submit this suggestion to the Idea exchange, under App improvement ideas

Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
Screenshot_2024-01-17_130153

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like