¿Cómo importo datos de Excel a una lista existente de SharePoint 2010?

How do I import Excel data into an existing SharePoint 2010 list?

Import Excel Table or Range to SharePoint List

1. Click on the settings gear and select ‘Add an app’.
2. Search for Excel and select the Import Spreadsheet app.
3. Give the app a name and browse to the Excel file you want to import.
4. Enter the URL of the SharePoint site to where you want to import the Excel table.

These are the steps to follow:

1. Gear Icon > Add an App.
2. Scroll down to Import Spreadsheet App.
3. On the next screen, give your new app/list a name, then choose an Excel file.
4. You will now notice an Excel file open up with a pop-up window where you need to select a range of cells to import.

Browse or enter the File Location of the spreadsheet that you want to import, and then select Import. In the Import to Windows SharePoint Services list dialog, select the Range Type, and in Select Range, specify the range in the spreadsheet that you want to use to create your list.

Allow me to explain how easy is will be for you to import an excel spreadsheet to a new SharePoint List. The only way for us to tackle this issue is to simply copy/paste Excel items into the SharePoint List.

Export the Excel Table to a SharePoint List

1. Enter the URL for your SharePoint site.
2. Check the box if you want to create a read-only connection to the SharePoint list.
3. Enter a Name for the new list.
4. Enter a Description for the new list.
5. Press the Next button to review the data types selected before exporting.

Edit a spreadsheet in the browser

1. Go to a document library on your SharePoint site, and then click the link associated with the Excel workbook.
2. Click Edit in Browser.

It’s easy to push and pull data from SharePoint to Excel. You can quickly get data using the export options in either Excel or SharePoint.

To open SharePoint list settings, click on the gear icon at the top right corner of the screen and choose List settings from the drop-down menu. Scroll down to the Columns section and verify the data type of your SharePoint list’s columns matches all the columns in the CSV file.

If the workbooks are stored in SharePoint online, then the workbooks can’t be linked in Excel online directly. You must sync them to your local drive using OneDrive sync client and then using Get & Transform Data in Data tab in Excel, the workbooks can be connected.

File: Workbook

1. Select Data > Get Data > From File > From Workbook.
2. In the Excel Browse dialog box, browse for or type a path to the file that you want to query.
3. Select Open.

Windows SharePoint Services 3.0, point to the file name to display a down arrow. Click the down arrow, and on the menu that appears, click Edit in Application. 3. Depending on the settings for your library and the program that you are using to edit the file, you may see a message when you open the file.

Retrieving SharePoint List Data

1. Drag SharePoint action and select “Create Session” activity.
2. Drag the SharePoint action and select the “Get list items” activity.
3. Drag the SharePoint action and select the “End session” activity.

Another option that is available to import Excel to SharePoint is to use a Web Part called “Import Spreadsheet”. These are the steps to follow: Gear Icon > Add an App. Scroll down to Import Spreadsheet App. Click on it. On the next screen, give your new app/list a name, then choose an Excel file. Click Import.

On the Tools menu, point to Import and then click the command for the source file format (for example, from Excel). If you want to import an Excel file, browse to and select the file and then select the worksheet in the Excel file. The Data Import Wizard opens.

How to export Document Library Metadata to Excel (from SharePoint / Office 365) Select a Document Library or a Subfolder and perform the operation “Export Metadata…” (per right mouse click and selection in context menu). After that, the tool displays a dialog where the user can define which fields should be present in the output Excel report. The tool counts all files inside the selected location and displays a confirmation dialog, where the user can confirm whether he wants to generate the report or to cancel

Make sure your Excel list is formatted as a table This is super important for this process to work.