# Backup My Data In My Spreadsheet

**URL:** <https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147>\
**Category:** Ask for Help\
**Created:** [October 13, 2019, 11:58pm UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147 "2019-10-13T23:58:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\
**Post date:** [October 13, 2019, 11:58pm UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/1 "2019-10-13T23:58:41Z")

</div>

Alguém sabe como faço para realizar o backup das vendas minhas para evitar que se algo acontecer elas estejam salvas em outra planilha

Minha preocupação e pois o glideapps não está estável tenho medo de perder meus dados

Alguém tem alguma dica de como fazer esse tipo de backup

---

<div class="post-metadata">

**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:** [October 14, 2019, 12:29am UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/2 "2019-10-14T00:29:05Z")

</div>

First of all, google does keep a history of any changes. You can access them by clicking the link at the top of the sheet:

 ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/27dd2861913cdaf78d4e8042d80f6bbe8911e180.jpeg)

I also use this script to backup my sheet every week. The only thing that needs to change in the script is the destination folder. This gives me a weekly backup with a timestamp attached to the name:

```
// Abhijeet Chopra
// 26 February 2016
// Google Apps Script to make copies of Google Sheet in specified destination folder

function makeCopy() {

// generates the timestamp and stores in variable formattedDate as year-month-date hour-minute-second
var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd' 'HH:mm:ss");

// gets the name of the original file and appends the word "copy" followed by the timestamp stored in formattedDate
var name = SpreadsheetApp.getActiveSpreadsheet().getName() + " Backup " + formattedDate;

// gets the destination folder by their ID. REPLACE xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx with your folder's ID that you can get by opening the folder in Google Drive and checking the URL in the browser's address bar
var destination = DriveApp.getFolderById("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");

// gets the current Google Sheet file
var file = DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId())

// makes copy of "file" with "name" at the "destination"
file.makeCopy(name, destination);
}
```

---

<div class="post-metadata">

**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\
**Post date:** [October 14, 2019, 12:38am UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/3 "2019-10-14T00:38:22Z")

</div>

se ele salva automaticamente nao tem como se perder correto

---

<div class="post-metadata">

**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:** [October 14, 2019, 12:44am UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/4 "2019-10-14T00:44:33Z")

</div>

Correct, as long as Google doesn’t lose it. It creates a seperate spreadsheet that is not attached to the app.

---

<div class="post-metadata">

**Author:** ![aumarivero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aumarivero/32/22787_2.png) [@aumarivero](https://community.glideapps.com/u/aumarivero)\
**Post date:** [November 28, 2022, 2:30pm UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/5 "2022-11-28T14:30:01Z")

</div>

Is there a way to backup data to a separate spreadsheet with photos/image URLs on it?

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 28, 2022, 2:46pm UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/6 "2022-11-28T14:46:19Z")

</div>

In Settings / Data, you can manually export the data of the project.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 12, 2024, 1:35am UTC](https://community.glideapps.com/t/backup-my-data-in-my-spreadsheet/1147/7 "2024-01-12T01:35:40Z")

</div>