Format for Data in CSV to be added to List

Home Forum General Format for Data in CSV to be added to List

Tagged: ,

This topic contains 2 replies, has 0 voices, and was last updated by  kiascham 6 years, 8 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #1289

    kiascham
    Participant

    I am trying to add a very extensive list of data into the List under the Account Resources. The only way I have found is to copy and paste the information, add commas where needed, and hit enter after every item. I now there is an import function but every time I use this feature it will have one enter with the first caption and the value is set as the rest of the data list. The data I have has the caption in column 1 and the value in column 2, the file is a CSV, comma separated. Please help so I do not have to enter in over 200 items by hand!

    #6291

    I just ran another test and confirmed that it does work as expected. I think your source file is not properly saved as a comma delimited CSV. If you are using Excel do a “save as” and choose CSV (Comma Delimited). Save the file as filename.csv. Excel will then give you two separate warning messages because a CSV doesn’t have full functionality in Excel. Acknowledge them but keep the type as CSV. You should then be able to import the file as a list.

    Workflow software, Process software, Procedure software

    #6292

    kiascham
    Participant

    I found out the issue was partly due to the fact that I am using a Mac and you have to save the CSV file in the windows version. After discovering that I was able to get the import to work. Thank you for your help!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Do NOT follow this link or you will be banned from the site!