# Switch from Google Sheets to BigTables **URL:** \ **Category:** Ask for Help\ **Tags:** big-tables\ **Created:** [April 13, 2023, 10:20am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474 "2023-04-13T10:20:46Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Josef\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/josef_p/32/55054_2.png) [@Josef\_P](https://community.glideapps.com/u/Josef_P)\ **Post date:** [April 13, 2023, 10:20am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/1 "2023-04-13T10:20:47Z")
Hi, I have an app where I have an Orders spreadsheet. The source of the table is Google Sheets. The reason I was using Google Sheets was for backup. I can imagine that I would convert the table to BigTable (faster data writing) and make backups using some script. My table has: 10 columns that are written to Google Sheets. 200 Glide columns (Relations, Lookup,…) 3000 rows The Orders table serves as a data source for the other 10 tables. Can you advise me on the best way to switch from Google Sheets to BigTables? Thank you! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 14, 2023, 12:07am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/2 "2023-04-14T00:07:26Z")
If you have that many calculated columns then it won’t be easy to switch over. You can export a CSV to be uploaded, I imagine, but then calculated columns won’t be transferred. You would have to do everything again from scratch, and also re-configure the related components. ---
**Author:** ![darksquare](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darksquare/32/20149_2.png) [@darksquare](https://community.glideapps.com/u/darksquare)\ **Post date:** [April 25, 2023, 1:22am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/3 "2023-04-25T01:22:26Z")
Is there a timeline for glide to catch up? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 25, 2023, 1:30am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/4 "2023-04-25T01:30:21Z")
Catch up to what? 🤔 ---
**Author:** ![darksquare](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darksquare/32/20149_2.png) [@darksquare](https://community.glideapps.com/u/darksquare)\ **Post date:** [April 25, 2023, 1:32am UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/5 "2023-04-25T01:32:26Z")
like, when will be the calculated columns will be implemented to Big Tables? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 25, 2023, 12:22pm UTC](https://community.glideapps.com/t/switch-from-google-sheets-to-bigtables/60474/6 "2023-04-25T12:22:46Z")
Many computed columns are available in Big Tables, but certain ones, such as rollups are not available. The reason for that is because of the way Glide currently works. Currently, everything is computed on the client device, so all data needs to be available on the client device for rollups to work. With Big Tables, only small subsets of data are sent to a client device at one time, so all data may not be available at any one time for the client device to perform a rollup. Glide would need to modify their logic to perform some of those calculations server side against the entire big table database.