Part 4 – How to Import a CSV Text File into SharePoint 2013 – Create Views in SharePoint

Home > Blogs > SharePoint > Part 4 – How to Import a CSV Text File into SharePoint 2013 – Create Views in SharePoint

Part 4 – How to Import a CSV Text File into SharePoint 2013 – Create Views in SharePoint

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

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.

This is the fourth of a five‑part video series where we’ve taken some data from the CSV file, brought into Excel, got that Excel data into SharePoint, modified the default view, set some of the list column properties and names, and went ahead and created a calculated column. That’s where we left off in the last movie.

Download the Products.csv file.

Now what we’re going to do is we’re going to create separate views, or ways that we want to look at this data.

The default view is showing everything and it’s sorted by the unit cost, from low to high.

001-how-to-create-views-in-sharepoint-2013

The first thing we’re going to do is create a view that groups the products by departments. You can see some of them are Men’s, Women’s, Accessories.

002-how-to-create-views-in-sharepoint-2013

There’s three different departments, and we’re going to go ahead and have a view that looks at things based on the department they’re on. I’ll do that by clicking up here in the ribbon. I have clicked the List Tab. I’m going to click Create View.

003-how-to-create-views-in-sharepoint-2013

What I’m going to do is start from the existing view, which is All Items.

004-how-to-create-views-in-sharepoint-2013

I’m going to click All Items. Then what I’m going to do is call this one By Department.

005-how-to-create-views-in-sharepoint-2013

I don’t actually need the unit cost in this view, so I’m going to uncheck Unit Cost.

006-how-to-create-views-in-sharepoint-2013

That’s information I’m deriving my retail price and my calculating column from, but I don’t really need it in this view.

I’ll change the sorting to RetailPrice.

007-how-to-create-views-in-sharepoint-2013

Since retail price is in this view, it will make more sense if anyone comes back later.

008-how-to-create-views-in-sharepoint-2013

What I want to do is choose, over here on the left side, the Group By section.

009-how-to-create-views-in-sharepoint-2013

There is a little plus sign. If I expand that, I want to group by the column Product Department, so ProdDept. SharePoint does all the work for me.

010-how-to-create-views-in-sharepoint-2013

I click OK, and I’ve got a view of the data in that list by department.

011-how-to-create-views-in-sharepoint-2013

By default it’s collapsed. It shows that I’ve got 28 products that are Accessories, 29 that are in the Men’s department, and 29 in the Women’s department.

If I want to see the individual items, I can click that arrow to expand and contract that.

012-how-to-create-views-in-sharepoint-2013

Again, it’s all out of the box stuff.

If I wanted them to start off expanded, that is an option. I could go Modify This View.

You may also like:  Part 3 How to Import a CSV Text File into SharePoint 2013 – Creating the list in SharePoint

013-how-to-create-views-in-sharepoint-2013

Then scroll down to that area where I grouped everything. Again, I’m going to expand Group By.

014-how-to-create-views-in-sharepoint-2013

It says by default, “Do you want to show things collapsed or expanded?” I tend to prefer them collapsed if I have a decent amount of items. I’ll click Expand it right now, to show you what that will look like.

015-how-to-create-views-in-sharepoint-2013

You’ll see it shows them already expanded.

016-how-to-create-views-in-sharepoint-2013

In this case I have enough products that it will cause some paging and I really like the idea of having just one dashboard here.

017-how-to-create-views-in-sharepoint-2013

It’s honoring the paging here, even though I have room to go back. I’m going to go back and change that, just wanted to show you that setting, because sometimes that is something you want to do.

I’m going to come down to the Group By > Collapsed

018-how-to-create-views-in-sharepoint-2013

That’s my Products by Department view in SharePoint.

I’m going to go ahead and create a view of products from $0 to under $50, so $0 to $49.99 basically.

I am going again click the List Tab, I’m going to click Create View.

019-how-to-create-views-in-sharepoint-2013

I’m going to save myself some time, because we have the option of By Department

020-how-to-create-views-in-sharepoint-2013

This it’s sorting by retail price and it does not have unit cost in there.

Since I have already done that work, I’m going to start there instead of from scratch. I’m going to call this Under50.

021-how-to-create-views-in-sharepoint-2013

That’s the name of my view, Under50. I can scroll right on down and go to the filter section, and I can check the radio button that says, “Show items only when the following is true.”

022-how-to-create-views-in-sharepoint-2013

What is it I am trying to say? I’m trying to say, when the retail price is less than…

023-how-to-create-views-in-sharepoint-2013

If I do less than or equal to that will be all the way and including $50. But if I do less than $50, that will be $0 to $49.99.

024-how-to-create-views-in-sharepoint-2013

I would do whatever it is that would I desire at this time, and then I’m going to click OK.

What’s going to happen is, I brought in the Group By, because that’s where I started from the view that already had that.

Here are my under $50 products and they’re all grouped.

025-how-to-create-views-in-sharepoint-2013

I have got 13 in Accessories. If I wanted to expand that, they are all retail‑priced under $50, and sure enough everything seems to be just fine. That’s great.

026-how-to-create-views-in-sharepoint-2013

I’m going to create another view. I’ll click the List Tab, Create View.

027-how-to-create-views-in-sharepoint-2013

This time I’ll start with the under $50 products view.

028-how-to-create-views-in-sharepoint-2013

I’ll say $50 to $100. This will be $50 to $100.

029-how-to-create-views-in-sharepoint-2013

I’ll scroll down and I’ll leverage everything I did, but instead of Retail Price is less than, I’m going to say is greater than or equal to $50. I will add a second condition, where the retail price is less than or equal to $100.

You may also like:  Using Navigation Controls in a Publishing Site in SharePoint

030-how-to-create-views-in-sharepoint-2013

Again, I don’t have to do anything in the Group By, because I’m starting with the view that already had that applied, so that’s applying that as well. There’s not that many products here, but you can see these are all meeting both greater than or equal to $50 and less than or equal to $100.

031-how-to-create-views-in-sharepoint-2013

Finally, the last view I want to create, I will say Create View. I’ll click the List Tab, Create View. I’m going back to starting with under $50

032-how-to-create-views-in-sharepoint-2013

And I’m going to title this View over $100.

033-how-to-create-views-in-sharepoint-2013

I’ll come back down to filtering and Retail Price is greater than, and I’m going to change $50 to $100.

034-how-to-create-views-in-sharepoint-2013

It’s a really good idea, especially when you get into views that are even more complex than this and you are filtering out how much in columns, you can really leverage that work by starting from one of those views and creating other views.

Now I have got my over $100.

035-how-to-create-views-in-sharepoint-2013

I’ve got several different views and I’ve got All Items which is just when the list was created.

036-how-to-create-views-in-sharepoint-2013

I modified that to sort by Unit Cost, low to high. I’ve got By Department, which is grouping all the products by departments.

037-how-to-create-views-in-sharepoint-2013

Since I started with the All Items, it should honor that sorting from low to high. I’ve got under $50, those are all my products under $50. There’s all my products from $50 to $00.

038-how-to-create-views-in-sharepoint-2013

Then finally, I’ve got over $100. Anything that’s over $100 should be showing up there.

039-how-to-create-views-in-sharepoint-2013

That is creating all the views.

Next video, we’re going to use all these views and leverage them on SharePoint Wiki pages, in order to create dashboards and then hook up all the navigation. Set one of those as our home page, and we’ll be done.

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

Agile Methodology in Project Management

0 47 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Creating Users and Managing Passwords in Microsoft Office 365

0 69 1

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.

Detailed Forensic Investigation of Malware Infections – April 21, 2015

2 137 1

In this IT Security training video, Security expert Mike Danseglio (CISSP / CEH) will perform several malware investigations including rootkits, botnets, viruses, and browser toolbars.

Write a Comment

See what people are saying...

  1. Pingback: Video - Creating the list in SharePoint to import a CSV Text File

Share your thoughts...

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