0
votes
1answer
110 views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
0
votes
1answer
26 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
1
vote
1answer
138 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
1
vote
0answers
24 views

Import excel spreadsheet with photos

I am trying to import an excel spreadsheet with photos, It import without problems, except that it removes the photos. What am I doing wrong?
2
votes
1answer
202 views

How to import one single row of data from excel to one list item in a SharePoint 2010 list?

I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
2
votes
2answers
3k views

Working with data imported from Excel into a SharePoint List

I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
1
vote
1answer
396 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
1
vote
0answers
131 views

Excel -> SP List with correct column types?

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...
3
votes
3answers
16k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
0
votes
0answers
685 views

Import Excel as List Fails

I have an Excel Spreadsheet that I want to import into SharePoint 2010 as a list but upon doing so I receive the following errors. As a work around I have saved the spreadsheet as csv and then ...
0
votes
0answers
221 views

Import from Excel Spreadsheet works in IE6 not IE8

I'm having an issue in SharePoint 2007 in IE 8 where, when creating a new List using Excel Spreadsheet Import, I get redirected to a 403 error. This feature works in IE 6 but not IE 8. Can anyone ...
1
vote
4answers
9k views

Import from Excel to an existing list

I'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient. Any ...
2
votes
3answers
1k views

Excel import to SharePoint

I'd like to be able to import a spreadsheet from Excel into SharePoint and be able to select a list template I've already built. Is this possible? I need to be able to do this so the proper ...