This page is for people who want to read the records exported with the app's CSV export in Excel, a spreadsheet, or an AI (ChatGPT, Gemini, Claude and others). It also has a text to paste along with the CSV when you ask an AI.
* The format on this page was checked on the Android version. The iPhone format is still being checked.
2026/02/05 07:33,"Breakfast" 2026/02/05 08:12,"Jogging start" 2026/02/05 08:40,"Jogging end" 2026/02/05 12:05,"" 2026/02/05 21:30,"Medicine 2 tablets \"as needed\""
""." inside a note is written as \", as on line 5.| Item | Details |
|---|---|
| Columns | Two: (1) date and time, (2) note. There are no ID, seconds, category, location or duration columns |
| Header row | None |
| Date and time | yyyy/MM/dd HH:mm (e.g. 2026/02/05 07:33). 24-hour clock; month, day, hour and minute always have two digits. No seconds |
| Time zone | The device's local time when the record was saved. No time zone is written. Records made abroad stay in the local time of that place |
| Quoting | Notes are always wrapped in ". Inside a note, " becomes \" and \ becomes \\ (not the "" style common in Excel). Commas inside a note are not separators because they are inside the quotes |
| Line breaks | One record per line, LF line endings. If a note contains a line break, that record spans several lines |
| Order | Oldest first |
| Range | The one month you select. Up to 10,000 records per month (as noted in the app) |
| Deleted records | Not included |
| Edited records | Only the current date, time and note. The original time and edit history are not included |
| Records added later | Records added with a past date and time look the same as records saved on the spot. You cannot tell them apart |
| Character encoding | Not set by the app, because the data is shared as text, not as a file. It is decided by the app that saves it |
| iPhone | Android | |
|---|---|---|
| Steps | On the CSV export screen, choose the month and tap the export button | "Setting" tab → "Output CSV format" → choose the month → "Output data" |
| What is shared | A text document (a file) named "TimeStampCSVData" | Text, not a file. It is passed to the receiving app as characters |
| Line format | Being checked | yyyy/MM/dd HH:mm,"note" |
When you give the CSV to ChatGPT, Gemini, Claude or another AI, paste this text too so the AI knows the format. It is for CSV exported from the Android version.
This is one month of records exported from the Android version of "Timestamp & Memo" (簡単に時間とメモ記録アプリ). - One line per record, formatted as: yyyy/MM/dd HH:mm,"note" . There is no header row. - Left: the time the record was saved (device local time, no seconds). Right: the note (may be empty). - A double quote inside a note is written as \" . - There is no end time or duration column. Format reference: https://parrot88.github.io/timestampApp/en/csv_format.html
\" inside a note is not Excel's standard style, so notes that contain " may look broken.