Keeping goshuin records as PDF and CSV: when to export and when to back up
A PDF is a copy laid out on pages with the photos, which suits looking back, printing and handing to someone, but it cannot be sorted. A CSV is a table of plain text with one goshuin per row: a spreadsheet can sort it and count it, but the photos themselves are not in it. A backup, the file you keep against a phone change or a breakage, exists to put your records back into the app they came from, and encrypted, it tells you nothing when you open it. A PDF and a CSV are not a way to restore: neither can put your records back the way they were. Keep one export to read and one backup to restore, and you are covered both on the day you lose the device and on the day you stop using the app.
The key points of this article
- Exports come in two kinds: a backup, which puts records back, and a CSV or PDF, which a person reads
- An encrypted backup shows you nothing when you open it, and a CSV or PDF cannot put your records back the way they were
- A CSV is a table of text only: even where it has a photo column, all it holds is the photo's file name
- A PDF lets you look back photo and all but cannot be sorted, and where it carries your notes, read them again before handing it over
- Make a backup before a phone change; choose a CSV or a PDF when you want to look back, count, or put it on paper
This article is part of “Keeping a list of your goshuin: the rows and columns that let you look one up later”.
This article covers one thing: what each of the three exported files — a backup, a CSV and a PDF — holds, and what each one can and cannot be used for. Moving records to a new phone, tidying columns in a spreadsheet, and laying out the pages you print are not covered here.
What is the difference between an export and a backup?
A backup is a file for putting your records back into the app they came from; a CSV or PDF export is a file for a person to read. Both take your records out of the app as a file, so they look like the same thing, but they are made for opposite purposes.
A backup is made for after a phone change, a breakage or a loss, so that the records come back exactly as they were. The photos, the order of books and pages, and the places attached to your shrines and temples all have to return together. Which is usually why it is not in a form a person can open and read.
An export for reading is made for looking back without opening the app, counting in a spreadsheet, putting it on paper, or showing someone. Anyone can open it, but it was never meant to go back into the app.
What a list of your records lets you look back at, and which fields deserve to be columns, is a separate piece: how to decide the columns from the way you will look back. This article picks up where that list leaves the app as a file.
A backup, a CSV and a PDF side by side
The photos are in the backup and the PDF, sorting and counting belong to the CSV, and only the backup goes straight back into the app it came from. The table covers the differences that hold for these formats generally.
| Backup | CSV | ||
|---|---|---|---|
| Made for | Putting records back into the app they came from | Sorting and counting in a spreadsheet | Looking back, printing, handing over |
| Readable when you open it | Not if it is encrypted | Yes, in a spreadsheet | Yes, by anyone |
| Puts records back | Yes | In some apps, the text only | No |
| Photos | Yes | No | Yes |
| Sorting and counting | After restoring, in the app itself | Yes | No |
| The case it covers | A phone change, a breakage, a loss | Counting for yourself, changing apps | Keeping it on paper, showing someone |
A CSV is nothing more than text separated by commas. There is no place in it for a photo at all, so even where a tool can take a CSV in, only the text comes back. A PDF is a copy of a printed page, and the text on it was never meant to be read back as records.
A sample: what comes out in a CSV and in a PDF
The same record becomes one row of text in a CSV and one entry with its photo in a PDF. Below is a sample to show the shape. The names are invented, and this is not an actual export from the app. The columns follow the app’s CSV when the app is showing English.
| Book | Page | Visit date | Visit date (Japanese era) | Shrine or temple | Reading | Note | Photo files | Type | How it was written |
|---|---|---|---|---|---|---|---|---|---|
| Book 1 | 7 | 2024-05-03 | May 3, Reiwa 6 (2024) | Sample Shrine | Sample Jinja | First day of the holiday | (file name) | Goshuin | Written in the book |
| Book 1 | 8 | 2024-05-03 | May 3, Reiwa 6 (2024) | Sample Temple | Sample-ji | (file name) | Goshuin | Pre-written |
Put the same two records into a PDF and, under a heading with the name of the book, each page number carries the photo, the visit date in both the Japanese era and the Western calendar, the name of the shrine or temple, and the note. The reading and the photo’s file name are not on it. Sort in the CSV, on the Western-calendar column; compare against the paper with the PDF.
A backup alone tells you nothing about what is in it
An encrypted backup gives you no way to see with your own eyes what it holds, short of importing it back into the app it came from. Open it in another app and no meaningful text appears.
Where that bites is when the app it belongs to is no longer usable. If you set out a few years from now to move to some other way of keeping records, ten backup files in your hands will not let you copy out a single name of a shrine or temple, or a single visit date. All a backup promises is that the same app can restore it.
The second thing is that you cannot see from outside whether a backup actually works. Whether the file arrived intact, and whether the records you meant to put in it are all there, is not knowable until you actually restore it.
An export you can read cannot put anything back
However many CSVs and PDFs you have, none of them can return your records to their original shape once the device is gone. A readable copy survives; the records themselves do not.
Take it concretely. An iPhone holding 300 goshuin breaks, and all that is left in your hands is three PDFs, one per book. You can look back through them. But to search by the name of a shrine or temple on the new phone, to add your next visit, or to correct a visit date, you are entering 300 records again. And if you have deleted the original photos from your photo library, you begin by pulling the photos back out of the PDF pages one at a time.
Had the CSV been the only survivor, the names and the visit dates would all be there as text, and not one photo would.
The only key to a backup is the passphrase
A backup encrypted with a passphrase can be read by nobody without it — not the person who made it, not whoever made the tool — and if you forget it, that file will not give the records back. How to keep the passphrase, and how to check a restore by counting entries, are in putting the exported backup off the device and testing it on the new phone.
Which one do you make, and when?
Make a backup to be ready for a phone change or a breakage; make a CSV or a PDF when you want to look back, count, or put it on paper. Working back from the purpose leaves nothing to puzzle over.
| What you want now | What to make | What to watch |
|---|---|---|
| To be ready for a phone change, a breakage or a loss | A backup | Test that it restores on the new phone |
| To count entries by year, or sort by the name of the place | A CSV | The photos are not in it |
| To look back book by book, or to print | A PDF | It cannot be sorted |
| To show family or friends | A PDF | Read your notes again before handing it over |
If you are going to open the CSV in a spreadsheet and sort it, read why sorting on the Japanese-era column breaks the order, and how to get back to book and page order first. If the PDF is going onto paper, settling which fields go on the page, and whether to group by book or by year first saves you reprints. What to check before you hand a file to someone is in how to handle notes, where a photo was taken, and the names of the people you went with.
The copy you can still read on the day you stop using the app is the readable export. Keep one of those and one backup for the day you lose the device, and neither event leaves you stuck.
What this app does
In Goshuin Ledger, the app we make, a backup can be created without a purchase, and CSV and PDF export come with the one-time Ledger Full. Here is what each of the three holds, as checked against version 1.10.0, the version on the App Store on 4 October 2026.
The backup (no purchase needed). One .goshuin file with your records and photos encrypted together under a passphrase you choose (eight characters or more). It holds your goshuin, your visits, the shrines and temples, the books and pages, the photos, and photos still waiting in Imported photos; it does not hold your purchase or your settings (on a new phone you use Restore purchase). It is not a ZIP that an ordinary unzip tool can open. Importing it adds what the backup holds to what is already on the device, without deleting the records there. Exporting it and restoring it on a new phone is written out in how a phone change goes with this app's backup.
CSV (Ledger Full). "Export CSV" in Settings turns every record into a single file. The first row holds the column names, each goshuin takes one row from the second row on, and there are ten columns: "Book", "Page", "Visit date", "Visit date (Japanese era)", "Shrine or temple", "Reading", "Note", "Photo files", "Type" and "How it was written". The column names, the words in the type and how-it-was-written columns, and the way the Japanese-era date is written all come out in the language the app is showing (what follows is how they look when the app is showing English).
- "Visit date" comes out as
2019-05-01, and "Visit date (Japanese era)" in the form "May 1, Reiwa 1 (2019)". Rows run oldest visit first, and records with no visit date come last. - The "Book" column holds the name you gave that book, and the "Page" column holds the page number. For a goshuin that is not in a book, both are empty.
- The "Photo files" column holds only the file name the app uses to point at a photo. The photo itself is not in there.
- The "Type" column holds one of "Goshuin", "Goshuinjo (castle seal)", "Tetsuin (railway seal)" or "Gosenin (ship seal)", and the "How it was written" column holds either "Written in the book" or "Pre-written". For a record where how it was written was never set, that column is empty.
- There is no location column.
- The file is in a format Excel opens without garbled characters (UTF-8 with a BOM). A cell beginning with
=,-or a similar character can be run as a formula by a spreadsheet, so in that case it is exported with a single'added at the front. A note you started with-gets that'too. - The file name carries the date you exported on (for example
goshuin-2026-09-17.csv).
PDF (Ledger Full). "Export PDF" in Settings makes one file per book. If you have goshuin that are not in a book, they become one more file.
- It opens with the name of the app, a heading for the name of the book, and a heading for each page number, and under those sit each goshuin's photo, its visit date in both the Japanese era and the Western calendar, the name of the shrine or temple, and your note. A type other than goshuin, such as a goshuinjo (castle seal), and how it was written, where you have set it, appear beside the visit date.
- The photos are copies scaled to roughly 800px on the long edge.
- The date the PDF was made is at the end.
- Locations, and the reading of the name, are not on it.
- Your notes appear as they are. There is no setting that leaves the notes out, so read what they say before you hand the file to anyone.
- There is no setting for the paper size. If you print on A4, check in the print dialog that the page is scaled to fit the paper.
Photos you have imported but not yet added to a book do go into the backup, but they are not goshuin records yet, so they are not in the CSV or the PDF. If you want them in a CSV or a PDF, add them to a book before you export. Visit records — visits where you received no goshuin — also go into the backup and are not in the CSV or the PDF. Both exports write out goshuin records only.
The things it does not do, also plainly. There is no way to open a .goshuin backup outside the app and read it. You cannot feed a CSV or a PDF back in to restore records either. And nothing is synced between devices.
Your first book needs no purchase and records as many entries as you like. What Ledger Full opens up is listed in the pricing section. For the price, check what the App Store shows.
Sources, and when they were checked
- What the app does (the CSV columns, what goes on a PDF page, what a backup holds and how it comes back): Goshuin Ledger 1.10.0, the version on the App Store on 4 October 2026, checked against its behaviour and source on that day.
- The sample table shows the shape only; its names are invented.
Frequently asked questions
- How does the CSV come out when I open it in Numbers or Google Sheets?
- In this app's CSV the first row holds the column names (Book, Page and so on, when the app is showing English), and from the second row each goshuin takes one row. The visit date in the Western calendar is exported in the form 2019-05-01, though a spreadsheet may read it as a date and change how it is displayed. The Japanese-era visit date is text in the form May 1, Reiwa 1 (2019), so sorting on that column does not put your visits in the order you made them. Sort on the Western-calendar column, Visit date, instead.
- Where should I keep the PDF so I can look back at it on my phone?
- Exporting opens the Share sheet, and saving the file into the iPhone Files app lets you look back at it without opening the app at all. This app's PDF is one file per book, so with three books the Share sheet opens three times in a row. Save them one at a time. If you have goshuin that are not in a book, that opens it once more for those.
- Can I move the exported CSV into another record-keeping app, or into a spreadsheet of my own?
- The text part can sometimes be moved. Even where the destination reads CSV, you have to match the column names, their order and the way dates are written to what that tool expects, which means tidying the columns in a spreadsheet before you import. The photos are not in the CSV, so you bring those across separately from the originals still in your photo library. A PDF is a copy of a printed page, so it is poor material to move.
- If I correct a record after exporting, does the change reach the PDF or the CSV?
- No. An exported file is a copy of your records as they stood at the moment you exported them. If you want to use one after correcting a visit date or the name of a shrine or temple, export it again. In this app the PDF carries the date it was created at the end, and the CSV carries the export date in its file name, so you can tell how current the copy in your hands is.
- How often should I make each of them again — the backup, and the CSV or PDF?
- A CSV or a PDF only needs making just before you look back, count or print. For a backup, counting the entries you have added fits reality better than counting the days. If you have added ten entries since you made a backup, those ten are exactly what is missing when you restore from it alone. This app prompts you on the home screen once 50 entries have been added since an export you confirmed had been saved off the device, or once 60 days have passed since that export if you have added or edited entries in the meantime (and if you have never confirmed a save, it prompts from your very first entry).