Skip to main content
S
samkrishnan
Participant
June 12, 2018
Answered

Error uploading CSV to update user profile information - Admin console

  • June 12, 2018
  • 2 replies
  • 5760 views

I am using the Admin console to edit information about multiple users.

I download the user list as a CSV.

I open in Excel

I add user group info & save as CSV

Then I try to upload. It gives an error saying

Headers (first line of the CSV) are missing or invalid

Not sure how to fix?

thanks

Sam

    This topic has been closed for replies.
    Correct answer alisterblack

    Hi,

    Make sure that your CSV has not been turned into a different format by Excel.

    For example if your OS or Excel uses something other than comma for separation it is no longer a CSV.

    Try the following steps:

    1. Open a new (blank) spreadsheet

    2. From the "Data" menu choose "Get External Data" -> "Import Text File"

    3. Select the CSV file

    4. Select "Delimited"

    5. In the "File origin" drop-down menu, choose "UTF-8", and click "Next"

    6. Select only "Comma" as the delimiter and click "Next"

    7. Leave the Column data format as "General" and click "Finish"

    Hope that helps.

    2 replies

    alisterblack
    alisterblackCorrect answer
    Inspiring
    June 13, 2018

    Hi,

    Make sure that your CSV has not been turned into a different format by Excel.

    For example if your OS or Excel uses something other than comma for separation it is no longer a CSV.

    Try the following steps:

    1. Open a new (blank) spreadsheet

    2. From the "Data" menu choose "Get External Data" -> "Import Text File"

    3. Select the CSV file

    4. Select "Delimited"

    5. In the "File origin" drop-down menu, choose "UTF-8", and click "Next"

    6. Select only "Comma" as the delimiter and click "Next"

    7. Leave the Column data format as "General" and click "Finish"

    Hope that helps.

    kglad
    Community Expert
    kgladCommunity Expert
    Community Expert
    June 12, 2018

    [ moved from Adobe Creative Cloud to Deployment for Creative Cloud for Team, Enterprise, & CS]

    Firefly Community Gallery
    Adobe Firefly

    Remix with Firefly Community Gallery

    Thousands of free creations to fall in love with and remix in Firefly.

    Explore now
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices