If you already track your queries in a spreadsheet, you can bring them all in at once instead of adding them one by one.
Prepare your file
Save your spreadsheet as a .csv file. The first row must be column headings. Query Tracker looks for these headings (capitalisation doesn't matter):
- Agent (also accepts Agent Name, Agent / Recipient, Reviewer or Reviewer Name)
- Manuscript (also accepts Manuscript Title, Book or Title)
- File Type (or Type): PDF, DOCX, RTF, EPUB or Other
- Status: Initial Inquiry Sent, Requested Full, Sent Full, Offer of Rep, No Response, Uninterested, Withdrawn or Other
- Sent At (also accepts Sent Date or Sent)
- Notes
Other columns are ignored. A file exported from Query Tracker with Export already has the right headings.
Import it
- Open Query Tracker from the left sidebar.
- Click Import CSV and choose your file.
- Check the preview table. It lists every row that will be added.
- Click Import (the button shows how many submissions will be added).
Good to know
- Rows with neither an agent nor a manuscript are skipped.
- If a status isn't one of the values above, the row is imported as Initial Inquiry Sent. An unrecognised file type becomes PDF.
- Rows with no sent date are given today's date. A year-month-day date such as 2026-03-15 is the safest format to use.
- Importing always adds new submissions. It doesn't check for ones you already have, so importing the same file twice creates duplicates. If that happens, remove the extras with the trash icon on each row.
- Keep each row's notes on a single line. Line breaks inside a cell can split a row in two.
- Custom statuses aren't imported. Use Other in the file, then set your custom status after importing.