Importing Spreadsheets into a Sharepoint site as a web part RRS feed

  • Question

  • we're using SP 2007 and MS Office 2007.  When I try to create a new list by importing a spreadsheet, and then identify the file to be imported I get a pop up that says that it is not a valid spread sheet format, which it is.  I can see that there is an option to select certain cells, but I'm not offered that option since Sharepoint rejects the file immediately.   I've tried various alternatives, but always get the same result.  I can see no reason for the file not to be valid.
    Monday, April 4, 2011 2:58 PM


  • HI Gary ,

    Just check the columns in the excel sheet all the columns should have the string data type.

    Still you have a problem let us know we will figure it out.

    • Edited by Mike Walsh FIN Tuesday, April 5, 2011 6:45 AM Let US know - these aren't private conversations
    • Marked as answer by David HM Monday, April 11, 2011 3:52 AM
    Tuesday, April 5, 2011 3:45 AM