Hi All,
Today i am going to share one useful and interesting thing about, Excel and Sharepoint...
Okay, Let's come to the situation...
U have a Sharepoint List and U are asked to generate an Excel spreadsheet from that..
AAAhh, i know u will say easyyyyy..
Single step : Ribbon control- Export to Excel :)
Ok Now, the other way around.. U r given an Excel sheet and asked to make a Sharepoint List from that...
There are some ways,
U will first think to create a List and go to the datasheet view of that.. Copy paste that data into this view...
HMMM, That’s good.. But there is one easy and clean way to do this....
*****************************************************************************************
Make that Excel data into a table.. Steps are below
1) Select all the Data in the sheet.
2)Go to Insert Tab and Select "Table".
3)Save this.
Tip: U have to change the Default headers “Column1,Column2..”. This will be reflected as Column names in Sharepoint List...
Ok Now, Go to Sharepoint à Site ActionsàMore OptionsàListàImport Spreadsheet
1)Try creating a list based on this template
2)Next screen u will be asked to give the file location. There specify the location of Excel Sheet and select “Import”.
3)Your Excel will open with this dialog box. You can select the range of the data and range type from the dropdowns. Finally click on “Import”.
4)You have got your Sharepoint List ready….
Happy SharePointinggggg :DJ…
No comments:
Post a Comment