Part 1 – Importing a CSV file into SharePoint 2013 – Introduction

Home > Blogs > SharePoint > Part 1 – Importing a CSV file into SharePoint 2013 – Introduction

Part 1 – Importing a CSV file into SharePoint 2013 – Introduction

Like This Blog 0 Spike Xavier
Added by October 5, 2016

In this SharePoint 2013 training videos series, we’re going to take you step-by-step through the process of taking a Comma Separated Values (CSV) text file, with some data inside of it, importing it into Excel, preparing the Excel document, and then importing that into SharePoint 2013. Download the CSV file.

Download the Products.csv file.

5 Part SharePoint Video Training Series – Importing a CSV file into SharePoint 2013.

  1. Introduction
  2. Prepare the Excel File
  3. Create the List in SharePoint 2013
  4. Create the Views in SharePoint 2013
  5. Create the SharePoint Home Page Dashboard

For instructor-led SharePoint training, see our class schedule.

The SharePoint list, once it’s put into SharePoint, will have all of the data we imported, and then we’re going to go ahead and add a Retail Price column to that list.

001-import-csv-text-file-into-sharepoint-2013

The Retail Price column is going to be based on a calculation that we’re going to perform on the unit cost of the product that was brought in.

When we’re done, we’re going to have a numerous products that belong to different departments and have different price ranges. Then we’re going to go through the process step-by-step of creating different views, or ways of looking at the data in that list.

We then will have a view of all the products by department that looks like this:

002-import-csv-text-file-into-sharepoint-2013

You can see that there are 28 products in the Accessories Department, and if we expand that down, you can see them sorted by Retail Price from low-to-high.

003-import-csv-text-file-into-sharepoint-2013

We’re also going to be creating several views on the list of the ProductsByPrice. For example, all of the products that are under $50,” so we’ll create a view.

004-import-csv-text-file-into-sharepoint-2013

Next, we will create a view of products that are between $50 and $100, and finally we’ll create a view of products that are over $100.

005-import-csv-text-file-into-sharepoint-2013

When we’re finished, we’re going to create a series of dashboard pages and add to the navigation of the Quick Launch bar. We’re going to have one page that’s a dashboard of the ProductsByDeparment.

006-import-csv-text-file-into-sharepoint-2013

We’re going to have another dashboard that’s going to be of the ProductsByPrice and Department.

Here is the ProductsByPrice and Department.

007-import-csv-text-file-into-sharepoint-2013

You can see that products that are under $50, which are sorted by Department.

008-import-csv-text-file-into-sharepoint-2013

Then users can quickly come in and expand that, and they can see the individual products that are under $50 in the accessories department, etc…

009-import-csv-text-file-into-sharepoint-2013

We’re also going to have a page that just shows the ProductsByDepartment, which is leveraging that view.

010-import-csv-text-file-into-sharepoint-2013

You can see within each department, it has the full range of prices of each of the products. They’re grouped by Department.

All of this is going to be done with out‑of‑the‑box SharePoint functionality. None of it it’s going to require custom programming. We’re even going to go through the process of making our products by DepartmentsByPrice, dashboard page. We’re going to go ahead and make that our home page of our new sub‑site.

Because there’s a lot of information for this, we’re breaking this up into five steps-by-step videos.

This is the intro.

The next topic will be preparing the Excel file. Then we’ll go ahead and use that Excel file, that’s now brought in as an XLSX file from the CSV, into SharePoint, and create the list.

Then we’ll do a bunch of work on the list; add the calculated column and create the views. Next we will create the Dashboard pages, add them to the navigation and set one of them as the home page.

Hopefully, you’ll find this really useful. Again, all of this out‑of‑the‑box. No special programming, no workflows, not even using SharePoint Designer. Just out‑of‑the‑box collaboration team site and a CSV file. Enjoy.

Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ

5 Part SharePoint Video Training Series – Importing a CSV file into SharePoint 2013.

  1. Introduction
  2. Prepare the Excel File
  3. Create the List in SharePoint 2013
  4. Create the Views in SharePoint 2013
  5. Create the SharePoint Home Page Dashboard

 

Videos You May Like

A Simple Introduction to Cisco CML2

0 3877 0

Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2

Cable Testers and How to Use them in Network Environments

0 724 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Data Models in Business Analysis

0 200 0

This video is from our PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification now available at Interface Technical Training. Also see Steve’s PMP Project Management Certification Course: Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition  Video Transcription: Data Models are part of the elicitation analysis in PMI-PBA. This is the way … Continue reading Data Models in Business Analysis

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.