425-882-1032 info@3sharp.com

Checkout some of our newer blog posts!

Here’s an easy way to load Excel data into a SharePoint list. In this example I’m using SharePoint Online.

  1. Here I have a table of sample data in Excel.ExcelImport-1
  2. Click the SharePoint gear icon and select Site Contents.
  3. Click add an app.ExcelImport-2
  4. Click the Import Spreadsheet app.ExcelImport-3
  5. Give your new list a name. Then browse to the location of your spreadsheet, and click Import.ExcelImport-4
    Note: if you see this warning message you will need to add the SharePoint site to your list of Trusted Sites in IE.ExcelImport-4a
  6. The import dialog will appear, select a Range Type and then select your desired range.ExcelImport-5
  7. You will be prompted in Excel to sign in to SharePoint online.ExcelImport-6
  8. And it’s that simple! SharePoint has created a list based on my Excel data.ExcelImport-7
    SharePoint even selects the appropriate column type!ExcelImport-8

I hope this post helps when you need to get data from Excel into SharePoint fast!

Until next time!

Check out some of our newer blog posts

Sharpie accomplishments

We love what we do, and our team is full of passionate, driven, industry experts. Just like our work experience, our accomplishments are all varied as well. Here are some Sharpies who have some pretty impressive and mention-worthy accomplishments....

Sharpies who have had interesting careers

Every child wants to be something when they grow up. Some people followed that route and others didn't. But people changing their careers as adults is more rare. Many of us at 3Sharp come from a wide spectrum of industries and talents. Here are a few...

Microsoft to no longer support Access Services for SharePoint

With an ever growing need to accommodate the innovative tech industry, Microsoft has decided to no longer support Microsoft Access Services for SharePoint. Microsoft Access Service will no longer be available for new apps and it will also be...

Delivering Technical Marketing with Storytelling

Delivering brand messaging in the rapidly evolving world of technology has become quite the challenge. Marketers no longer have a limited number of channels or devices to target. They constantly need new skills to manage these proliferated channels through...

Microsoft Updates Teams

Starting Monday evening, Microsoft started rolling out their most recent(and arguably the largest) feature release for Microsoft Teams since the launch of the Slack competitor over a year ago. The Microsoft Teams update makes it easier than ever to be...

Experiential Technical Marketing: It’s a thing!

In the constantly evolving tech space, the need for a great user experience remains constant. Whether we are talking about the design of a product, the seamless integration of information into our lives, or technical marketing, user experience should be...

Demo Production and Collaborating with your Product Engineering Team

Over my years in IT, I have seen many great demos and presentations. I have also seen a good number that were less than ideal. When there are time constraints or workload challenges, it can often be left to the engineering team to build the important...

Technical Marketing and Working With Video Production Companies

Occasionally, we will get a request to help out a product marketing manager to highlight a new product or feature update for Microsoft 365 and help create a promotional video. Working with production companies is a lot of fun and holds its own unique...

Microsoft’s Commitment to the Open Source Community, AI, IoT and machine learning

"Today at Connect(); we’re announcing new tools and services that help developers build applications and services for the AI-driven future, using the platforms, languages and collaboration tools they already know and love.” Open Source Commitment Toward...

Minecraft Education Edition and Training for Future Success

According to the Bureau of Labor Statistics, employment in the computing and information technologies fields is expected to grow 13 percent between 2016 and 2026 or more than 500,000 new jobs, outpacing all other industries.  Those are interesting statistics, but not...