# Import a spreadsheet and turn it into a Glide / Google sheet

**URL:** <https://community.glideapps.com/t/import-a-spreadsheet-and-turn-it-into-a-glide-google-sheet/47656>\
**Category:** Ask for Help\
**Created:** [August 24, 2022, 7:36pm UTC](https://community.glideapps.com/t/import-a-spreadsheet-and-turn-it-into-a-glide-google-sheet/47656 "2022-08-24T19:36:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [August 24, 2022, 7:36pm UTC](https://community.glideapps.com/t/import-a-spreadsheet-and-turn-it-into-a-glide-google-sheet/47656/1 "2022-08-24T19:36:37Z")

</div>

I am currently getting spreadsheets as excel or google sheets. I then make sure they are the correct format header-wise such as getting rid of excess headings I don’t need and making sure all the rows have all the data required in all the fields (like end-user name associated with account).

I then copy these into a master google sheet which is used by Glide.

I would like to automate this data sanitization (getting the SS and ensuring it is formatted correctly then appending it to the master list). I am not sure this can be done inside of Glide.

If it has to be done in a google sheet then I need script it.

Has anyone done this (automatically cleaned up multiple sheets based on their headers to align the data set properly and then append to a master spreadsheet)?

Thoughts? Recommendations?

TIA

---

<div class="post-metadata">

**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:** [August 25, 2022, 12:49am UTC](https://community.glideapps.com/t/import-a-spreadsheet-and-turn-it-into-a-glide-google-sheet/47656/2 "2022-08-25T00:49:18Z")

</div>

> [@MattLB](#):
>
> I then make sure they are the correct format header-wise such as getting rid of excess headings I don’t need and making sure all the rows have all the data required in all the fields

If you can derive a logic for what should be considered “excess headings” then you might get a chance to do it.

The same for “the rows having all the required data”.

I also assume you have to do this for different Sheets, so that’s gonna be a huge flow.