Ir al contenido principal

Import a Spreadsheet as a List in SharePoint 2010

 

Already have data in a spreadsheet that you want to be a SharePoint 2010 list? You're halfway there! Before you start, make sure you do the following:

  • Clean the list. Make sure your list looks like a table, with no blank columns or rows.

  • Make sure your list has headers. All columns should have a column title.

  • Make sure your column data is consistent. For example, if a column has a comment in what would otherwise be a Date column, remove the text.

  • Make sure your first row is representative of the rest of the data. SharePoint reads that first row and makes assumptions about the information in that column. Here is an example of a clean spreadsheet ready for importing.

    290385.image0

TIP: SharePoint looks for what it believes is the first text column and uses it as the pseudo-title field (the primary field in the list that has the Edit menu attached to it).

Therefore, try to place a text field with unique data in the first column position. Unfortunately, if your unique field is a number, such as a serial number, this can cause issues. To work around the problem, create the list and copy and paste the data from the spreadsheet.

A good example of a first column is a unique name of a person or an item, such as Event Name.

A bad example of a first column is the category of an item or a department of an employee.

To import your spreadsheet into a custom list:

  1. Choose Site Actions→View All Site Content.

    Other options include View All Site Content Link on the Quick Launch toolbar or the Create Option Link on the Site Actions menu.

  2. Select the Create command and then select the Import Spreadsheet option from the List category and click the Create button.
  3. In the Name text box, enter a name for your list.

    Follow the naming conventions for list names: keep them short and eliminate spaces.

  4. (Optional) In the Description text box, enter a description of the list.

  5. Click the Browse button, browse to your spreadsheet, select it, and click the Import button.

    A dialog box appears that asks how your range is designated. The default is Table Range, but other options are Named Range or Range of Cells. If you haven't named your range in Excel or set as a table, select the Range of Cells option.

  6. If you chose the Range of Cells option, click the Select Range field in the dialog box, and then click your spreadsheet and highlight the desired range.

  7. Click the Import button in the dialog box.

REMENBER: After you import your spreadsheet, verify the column types SharePoint chose for you. Generally SharePoint assumes text, number, and dates. You may want to change some text fields to Choice, Yes/No, and so forth.

TIP: Don’t have the patience to create all your custom columns one by one — but you don’t have a current list in another format either? Create a spreadsheet with your column headers and at least one row of data, and then import this spreadsheet and modify the column properties as necessary.

Fuente: http://www.dummies.com/how-to/content/import-a-spreadsheet-as-a-list-in-sharepoint-2010.html

Comentarios

Entradas populares de este blog

Get SharePoint Online Site and SubSites permission using PowerShell

The below PowerShell script retrieves the following for the given SharePoint Online Site All the Sub-site's URL Security group attached with each Sub-site with their permission level Prerequisites: This PowerShell script uses the latest version of SharePoint Online PnP Module. Download the installer from https://github.com/SharePoint/PnP-PowerShell/releases  Install-Module SharePointPnPPowerShellOnline  Install-Module - Name ' SharePointPnP.PowerShell.Commands.Files.Recurse ' function  connect - site( $webs , $creds ){    Connect - PNPonline  - Url  $webs   - Credentials  $cred     }    function  get - sitepermission( $web , $cred ){    $rec =@()    connect - site  - webs  $web   - creds  $cred     if ( $web   - eq  $parentsitename )  {  #Write-Host "Parent site permission" $web   $Pgroups =G...

O365 - Forms - Transferir la propiedad de un formulario

Fuente :  https://support.office.com/es-es/article/transferir-la-propiedad-de-un-formulario-921a6361-a4e5-44ea-bce9-c4ed63aa54b4 Si ha creado una encuesta, una prueba o un sondeo, puede moverlos fácilmente a un grupo para que todos los miembros del grupo se conviertan en propietarios de ese formulario. Transferir el formulario a un grupo En el explorador Web, vaya a  Forms.Office.com . En la pestaña  mis formularios  , busque el formulario que desea transferir. Haga clic en  más acciones de formulario    y, a continuación, seleccione  mover . Nota:  Solo puede mover el formulario si es el propietario de ese formulario. No puede transferir la propiedad de un formulario que está compartido con usted. Seleccione el grupo al que desea transferir el formulario y, a continuación, haga clic en  mover . El formulario que ha movido aparecerá en la pestaña  formularios de grupo  . ¿Qué ocurre con el libr...

Event ID 8031 The uri endpoint information may be stale

An exception occurred while updating addresses for connected app {6783ce5e-c88h-4021-8d5b-12614875cbfa_b79f19ab-1d40-4824-9911-3466cf8b070a}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found.    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context)    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)    at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)    at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId) After de-commissioning some SharePoint servers, you might notice the above error on other WFEs /Application server’s event viewer . It appears that the SharePoint still has a reference...