Troubleshooting

My CSV import was rejected, or brought in the wrong thing

What the importer requires, what it renames, and the one character that breaks a row.

1. 1The file needs a header row and at least one row of data, and it must have a title column and a date column. Everything else is optional.
2. 2Header names are flexible. Title also accepts name or event_name; the date also accepts start_date or just date; booth fee also accepts fee or cost; income also accepts revenue or sales. Spaces and capitals do not matter.
3. 3A notes column is imported into the event’s Description. There is no separate notes field on an event, so that is where your text is — not missing.
4. 4Commas inside a value split the row unless the value is wrapped in double quotes. A location like Springfield, MA is the usual culprit: quote it as "Springfield, MA" and it imports cleanly.
5. 5Each row is one DAY. A three-day show is three rows with the same title, spelled identically, or you get three separate shows rather than one run.
6. 6An imported event has no register linked to it, so its sales report will be empty until you link one. That is expected, not a failed import.
7. 7Import and export are on the paid plans. If the option is not there at all, that is why.

Related guides