none
Import Spreadsheet returns error RRS feed

  • Question

  • Hi,

    I'm trying to import excel spreadsheet. For one file it works and for another it doesn't.

    On examination I found that the one that doesn't work has got filters applied on some of it's columns. Is this the reason that it doesn't work.

    Can anybody please let me know if that is the reason then is there any workaround.

    Many Thanks,

    Praj

    Monday, August 18, 2014 5:46 AM

Answers

  • Hi Praj,

    I could not reproduce your issue. I did a test as the followings:

    1. Create a excel , and insert a tabel
    2. Type some value for this tabel
    3. Filter the value on two columns
    4. Save the excel
    5. Create a Import Spreadsheet list using the above excel file
    6. After creating the list, all values of the tabel in the excel displayed in the list.

    What data did you use for the Import Spreadsheet list?

    Which error did you meet when you imported the problematic excel file?

    Please try create another excel containing same data with the problematic excel, then import it, compare the result.

    If this issue still exists, please check the log file to find more information about this issue.

    Best Regards,

    Wendy


    Wendy Li
    TechNet Community Support

    • Marked as answer by John.P.Smith Tuesday, August 19, 2014 11:03 AM
    Tuesday, August 19, 2014 5:43 AM
    Moderator

All replies

  • Hi Praj,

    I could not reproduce your issue. I did a test as the followings:

    1. Create a excel , and insert a tabel
    2. Type some value for this tabel
    3. Filter the value on two columns
    4. Save the excel
    5. Create a Import Spreadsheet list using the above excel file
    6. After creating the list, all values of the tabel in the excel displayed in the list.

    What data did you use for the Import Spreadsheet list?

    Which error did you meet when you imported the problematic excel file?

    Please try create another excel containing same data with the problematic excel, then import it, compare the result.

    If this issue still exists, please check the log file to find more information about this issue.

    Best Regards,

    Wendy


    Wendy Li
    TechNet Community Support

    • Marked as answer by John.P.Smith Tuesday, August 19, 2014 11:03 AM
    Tuesday, August 19, 2014 5:43 AM
    Moderator
  • Hi Wendy,

    Thanks for the help. I copied the data from the excel file to another one which I created locally on my desktop and I'm able to import the new file without any errors.

    Alternatively, I also did "Format as table" first and then when I tried to import the excel file I could import the table data without any error.

    The problem was with the filtered columns I guess.

    Thanks again for your help.

    P.S.: The error message that I was getting is: "The Selected range cannot be converted to a list before publishing or the existing table is invalid"

    Regards,

    Praj

    Tuesday, August 19, 2014 11:09 AM
  • Hi

    Got the same issue

    After removing filters, I was able to successfully import speadsheet

    Thanya

    Thursday, August 17, 2017 8:40 AM