How to sync Excel files with Google Drive?
The time has come to build performance reports. Since we're a bit understaffed, I need to pitch in. The amount of copy-pasting between spreadsheets (Excel files and the main Google spreadsheet) is unbearable and, I imagine, unnecessary. I need to automate the process so that the changes in one sheet reflect in the other. Ideally, it would work both ways, but maybe I'm asking for too much. There is a good chance this will become a monthly thing (now it's being done every three months), so we have to change the way we do it now. My search showed me a couple of solutions that seemed complicated and/or not complete. As you can guess, I am neither an Excel fan nor an expert.
I don't know if you're interested in getting software, but there's one that gives you this option. Actually, the two-way integration that you mentioned is also possible. Here's how it works, you link excel to google sheets and set the flow direction (2-way in your case), and that's it.
This seems to be exactly what I need, thank you. To be fair, it's quite a process to set it up, but at least I know for sure it will work. And I can exclude some rows from syncing if I understood correctly?
Yes, you set rules to filter them out. I know it seems like a lot to do, but you can duplicate a flow you created, so you only need to do it once. Hope it's some kind of comfort.
Dolores eos nemo maiores molestiae magni explicabo non. Aut et quia nemo molestias molestiae maxime. Impedit et eum inventore praesentium vero est. Et natus necessitatibus quos aperiam.
Qui praesentium iste architecto sit. Ab adipisci qui ut excepturi consequatur tenetur. Itaque blanditiis quam quas aut ut a.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...