Read the result
After an import, the dialog says how many items were imported and how many rows were skipped. Rows that passed are saved. Each skipped row is listed with its row number, name and reason.
The number is the row in your file, with the header as row 1. For pasted cells, it counts from the header row you pasted.
Fix a skipped row
| The result says | What to fix |
|---|---|
| Name is required. | Give the row a name of at least 2 characters. |
| Expiration date is required. | Fill in the date. |
| Expiration date must be a date like 2027-03-31 or 3/31/2027. | Use one of those two forms, month first. 04.01.2028 and 04-01-2028 are not accepted. |
| Expiration date is not a real date. | Check the day and month. |
| Expiration date must be in 1900 or later. | Correct the year. |
| A field has unsupported characters. | Retype that cell. It holds a character that can't be stored. |
When nothing is read
These show before you import, and no rows are sent. See the columns and dates an import reads.
- Couldn't find a name or an expiration date column. Name the headers "Name" and "Expiration Date".
- That's one line. Copy the header row with the rows under it.
- A quote in that file isn't closed. Check the cells that hold quote marks, save the file and choose it again.
- Could not read that file. Save the sheet as a CSV, or paste the cells instead.
Rows over a limit
One import takes at most 500 rows and 900 KB of text. The result tells you which row to start a second file from.
On the free plan, the result names the rows left out once the 3 records are used. Only the workspace owner can choose a plan in Billing to import the rest. See what each plan includes.