> ## Documentation Index
> Fetch the complete documentation index at: https://dexflip.app/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Export to Sheets

> Sending cards and their photos to a Google sheet, and who can open it

Export to Sheets writes cards to a spreadsheet in your Google Drive, one row per card with its photos. It needs a linked Google account. See [Linking Google](/docs/setup/linking-google).

<Warning>
  **Anyone with the link can open the folder, the sheet and the photos.** The app shares its Drive folder that way so the photos can show in the sheet. Do not post the link anywhere you would not post the cards.
</Warning>

## Exporting

<Steps>
  <Step title="Pick the cards">
    In Compose, tap the **Export to Sheets** icon at the top, tick the cards, and tap **Export** in the bar. On [Published](/docs/selling/published-cards), tap **Select** first.
  </Step>

  <Step title="Add a timestamp photo, if you want one">
    **Take a photo** or **Choose from your library**. A photo of the cards with today's date proves when you had them. It goes on the **Timestamps** tab.
  </Step>

  <Step title="Tap Export">
    The sheet counts through **Preparing the sheet**, **Photo 3 of 20** and **Writing rows**. **Stop** ends the photo uploads. Export again to pick up where it stopped.
  </Step>

  <Step title="Open the sheet">
    Tap **Open the sheet**. Then choose **Allow access** at the top of the sheet, or the photos stay blank.
  </Step>
</Steps>

The camera and photo library behave as they do for a lot cover. See [Building a lot](/docs/selling/building-a-lot#taking-or-choosing-your-own-photo).

## What it creates

| In your Drive                         | Contents                                                  |
| ------------------------------------- | --------------------------------------------------------- |
| A folder named **DexFlip**            | Everything below. Shared as anyone with the link can view |
| A spreadsheet named **DexFlip cards** | Tabs **Cards** and **Timestamps**                         |
| One JPEG per card side                | Named after the card and the side                         |
| One JPEG per timestamp photo          | Named with the date and time                              |

## Cards tab

| Column                      | Holds                                  |
| --------------------------- | -------------------------------------- |
| Front, Back                 | The photos, shown in the cell          |
| Front link, Back link       | Links to the photo files               |
| Name, Set, Number, Printing | The card                               |
| Condition                   | NM, LP, MP or HP/DMG                   |
| Asking                      | Your price, blank if the card has none |
| Market, Market as of        | The market price and its date          |
| % of market                 | Asking as a share of market            |
| Lot                         | The lot the card is in, if any         |
| Exported                    | When the row was written               |
| Card id                     | DexFlip's id for the card              |

## Exporting again

**A card already in the sheet is updated in place.** Its row is rewritten with the current price and condition. Its photos are not uploaded again. New cards are added at the bottom.

Exported cards show **Exported to Sheets** and the time in Compose.

## Notes

* The app can reach only the folder and sheet it created. It cannot see anything else in your Drive.
* If you delete or trash the folder, the next export makes a new folder and sheet and uploads every photo again. If you delete only the sheet, a new sheet is made in the same folder.
* If you link a different Google account, the next export starts a new folder in that account. The old one stays where it was.
* Deleting a card in DexFlip does not delete its row or photos from Drive. Delete them in Drive.
* Uploads run one at a time, so a large batch takes a while. Keep the app open.