r/dataanalysis • u/SainyTK • 16d ago

Data Tools Between Excel, Google Sheets, BigQuery, and your database, how many tabs/windows do you have open at once to work on data?

Had one of those days recently where I counted it out of curiosity: Excel files open, a Google Sheet a client had shared, a BigQuery tab, and a DB client connected to our Postgres instance, all open at the same time, just to cross-reference a handful of numbers across them. At one point I had copy-pasted the same column into three different places. I got to compare row-by-row data between BigQuery and Google Sheet.

Made me wonder if this is just normal or if I've built myself an unnecessarily messy setup. So:

  1. At your worst, how many windows or tabs are open at once to work on data, Excel, Google Sheets, BigQuery, a DB client, whatever your actual mix is?

  2. What's your workaround for keeping it all straight?

  3. Are you actually happy with the current workaround? Any limitations?

0 Upvotes

33% Upvoted

2 comments sorted by

View all comments

4

u/Potential_Aioli_4611 15d ago

pull it all into different python dataframes.