Import files
Bring in CSV, spreadsheets, emails, PDFs and photos of documents. Every import is previewed before anything is written.
If the data already exists in a file, import it. Countdat reads the file, shows you exactly what it would add, and writes nothing until you confirm.
#What you can import
| File | What's read |
|---|---|
| CSV | Each line becomes a row. |
| Spreadsheets | Every table on every sheet - not just the first one. |
| Emails | The figures and records in the message. |
| PDFs | Tables and records in the document. |
| Photos of documents | A receipt, a printed report, a whiteboard tally. |
#Import a file
- Open the counter you want to add rows to - or start a new counter from the file.
- Choose the file.
- Read the preview. You'll see what was found - which sheets and tables, how many rows - and how they map to the counter's fields.
- Confirm. Only now are rows written. Each one says it came from this import.
If the preview looks wrong - columns in the wrong field, dates read as text - don't confirm. Fix the file and import again, or tell Countdat what's off and check the new preview.
#Importing the same file twice
Every import adds rows. If you import the same file again, you'll get the rows again. To bring in a fresh copy of data that changes, consider a scheduled job instead.
#Tips for clean imports
- Give columns clear headers -
date,amount,location. - Keep one kind of thing per table.
- For photos, shoot straight on, in good light, with the whole page in frame.
Countdat doesn't sync with Google Sheets or pull files over SFTP. Download the sheet as a file and import it.
Still stuck? Write to us and a person will reply.
Email support
Updated 2026-10-09