CSV import errors
Last updated [DATE]
Most import errors come from the file's size, type or number of rows; split or re-save the file and import it again.
Who can do this: owners and editors.
File errors
| Message | What to do |
|---|---|
| "That file is over 100 KB. Split it into smaller files." | Split the file and import each part. |
| "That doesn't look like a CSV file." | Save the sheet as CSV (comma-separated) and try again. |
| "That's more than 200 rows. Split it into smaller files." | Import up to 200 rows at a time. |
| "There's nothing to import. Add at least one prompt." | Put prompts in a column named prompt, or in the first column. |
| "Too many imports in a short time. Try again in a few minutes." | Wait a few minutes. |
Skipped lines
After Check prompts, each line shows what will happen:
| Outcome | Meaning |
|---|---|
| Will be added | A new prompt. |
| Will be reactivated | A prompt you removed earlier; it comes back with its past answers. |
| Already tracked | Already an active prompt. Skipped. |
| Duplicate in this list | Appears more than once in the file. Added once. |
| Empty line | Nothing on this line. Skipped. |
| Over 500 characters | Too long. Shorten it and import again. |
| Over the 20-prompt limit | Adding it would go over your active-prompt limit (20 per project on Solo and Agency Lite, 50 on Agency Pro). Remove prompts or see Plans and limits. |
Steps to fix a file
- Open the file in a spreadsheet app.
- Make the first row a header named
prompt, or keep the prompts in the first column. - Remove empty rows and rows over 500 characters.
- Save as CSV, under 100 KB and up to 200 rows.
- Import again. See Import prompts from a CSV.
Related
- Docs: CSV import and export
- Help: Import prompts from a CSV
Still stuck? Contact us.