Importing data from a CSV file to a dataset
You can import or upload data from a CSV file to your dataset.
Click the Import CSV button and then select the CSV file.
While importing a CSV file, you need to be aware of the file requirements.
CSV file requirements
The supported CSV file type is comma-separated values.
The CSV column names can be alphanumeric but should contain only the following characters: space, hyphen (-), and underscore (_).
The CSV file should be in UTF-8 format.
You cannot import data from a CSV file for the following field types: Attachment, checklist, signature, and image.
For Yes/No fields, you can use any of these binary values: True/False, 1/0, Yes/No.
The supported date formats are:
Data Format |
Example |
DD-MMM-YY |
02-DEC-20 |
DD-MMM-YYYY |
02-DEC-2020 |
DD/MM/YY |
02/12/20 |
DD/MM/YYYY |
02/12/2020 |
MM/DD/YY |
12/02/20 |
MM/DD/YYYY |
12/01/2020 |
DD.MM.YY |
02.12.20 |
DD.MM.YYYY |
02.12.2020 |
DD-MM-YYYY |
02-12-2020 |
YYYY-MM-DD |
2020-12-02 |
The supported datetime formats are,
Datetime Format |
Example |
DD-MMM-YYTHH:mmZ |
01-Jan-20T12:00Z |
DD-MMM-YY hh:mm A |
01-Jan-20 05:00 AM |
DD-MMM-YY HH:mm |
01-Jan-20 05:00 |
DD-MMM-YYYY HH:mm |
01-Jan-2020 05:00 |
DD-MMM-YYYY hh:mm A |
01-Jan-2020 05:00 AM |
DD-MMM-YYYYTHH:mmZ |
01-Jan-2020T05:00Z |
DD/MM/YY HH:mm |
01/12/20 05:00 |
DD/MM/YYTHH:mmZ |
01/12/20T12:00Z |
DD/MM/YY hh:mm A |
01/12/20 12:00 AM |
MM/DD/YY HH:mm |
12/01/20 12:00 |
MM/DD/YYTHH:mm |
12/01/20T12:00 |
MM/DD/YY hh:mm A |
12/01/20 12:00 AM |
MM/DD/YYYY HH:mm |
12/01/2020 12:00 |
MM/DD/YYYYTHH:mmZ |
12/01/2020T12:00Z |
MM/DD/YYYY hh:mm A |
12/01/2020 12:00 AM |
DD.MM.YY HH:mm |
01.12.20 12:00 |
DD.MM.YYTHH:mmZ |
01.12.20T12:00Z |
DD.MM.YY hh:mm A |
01.12.20 12:00 PM |
DD.MM.YYYY HH:mm |
01.12.2020 12:00 |
DD.MM.YYYYTHH:mmZ |
01.12.2020T12:00+05:30 |
DD.MM.YYYY hh:mm A |
01.12.2020 12:00 PM |
- Timestamp formats
Timestamp |
Example |
D - Date |
DD - 01, 24 |
M - Month |
MM - 01, 02, 12 MMM - Jan, Feb |
Y - Year |
YY - 99, 00, 01 YYYY - 1999, 2001 |
T - Constant Character (As per ISO) |
T |
H - 24 Hour |
HH - 05, 17 |
h - 12 Hour |
hh - 03, 05 |
m - Minute |
mm - 00, 15, 59 |
A - Meridiem |
A - AM, PM |
Z - Time Zon |
Z - Z, +05:30 |
CSV file import
Once the file is uploaded, it will be validated and verified.
Kissflow checks your data types to match the fields in your dataset.
If you have more than 5000 rows, contact our support team.
Map fields
After the data is validated, click Next, and you will see a preview of the first 10 rows. Some headers of the dataset and CSV columns will be mapped automatically, but ensure to map all your dataset fields with your CSV columns. You must map one column to the Key field of the dataset. Unmapped field data will not be imported.
Import Notifications
After clicking Next, the import process will start. After it is completed, you will receive a notification and email. There are 3 possible scenarios.
All the imported data was successfully uploaded into the dataset.
Some of the data was imported successfully, but some rows failed. You can download the failed rows, work on them, and upload the file again.
The import was aborted. View the error logs to see what went wrong.
FAQ:
Q) Can I use the Import CSV option in the dataset when auto-lookup is enabled in your dataset's lookup field?
Ans) When an auto lookup is enabled, you cannot use the import CSV option for a lookup column in Dataset. Auto lookup is designed to automatically populate the lookup column based on existing data relationships, which conflicts with manually importing data for that column.
