Study guide

Import Data from Online Sources

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Import Data from Online Sources

Key Takeaways Explain This Topic AI

Data → From Web (under Get Data / Get & Transform) imports HTML tables and web-accessible data into Excel

The Navigator lists detected tables; select the correct table preview before Load

Imported web queries can be refreshed when the online source updates; know where Refresh lives on the Data tab

Use From Web when the task names a URL or online table; use copy-paste only when the task asks for static values

  • At Associate level, pick the right table and load it—deep Power Query reshaping belongs to Expert exams
  • Last updated: August 2026

Online import on the Associate exam

Certiport’s MO-210 objective domain lists import data from online sources alongside text/CSV import. In Microsoft 365 Excel, that skill centers on the From Web connector in Get & Transform Data . You paste or type a URL, authenticate if prompted, pick a table Excel detected on the page, and load it into the workbook.

Exam projects may give you a local HTML file path or a documented URL in the instructions panel. Treat whatever address the task provides as the "online" source—even if the lab environment hosts it locally for reliability. The clicks you practice are the same: Data → From Web (or Data → Get Data → From Other Sources → From Web , depending on how your ribbon is labeled).

Step-by-step: From Web

Go to the Data tab.

Choose From Web , or open Get Data and select the Web connector.

In the dialog, enter the URL from the task instructions exactly (watch for https:// vs http:// and trailing paths).

Click OK . If Excel asks for credentials, follow the project’s guidance (Anonymous is common for public sample pages).

In Navigator , browse the list of detected tables and items. Click each candidate and read the preview grid.

Select the table that matches the columns named in the task (for example, a rate table with Region and Rate ).

Click Load for a new sheet, or Load To… for a specific sheet/cell, or Transform Data only if cleanup is required.

Reading the Navigator

Navigator is the make-or-break screen. Web pages often expose multiple tables—navigation menus, footers, and the real data table. MO-210 tasks usually describe the columns you need. Match by:

  • Column names in the preview
  • Approximate row counts when stated
  • Whether the first row looks like headers

If two tables look similar, open Web View (when available) to see how the table sits on the page, then return to Table View to confirm the grid.

Refresh considerations (Associate level)

A From Web (or From Text/CSV) import typically creates a query connection . That means the worksheet table is linked to the source:

Select a cell in the imported table → Data tab → Refresh (or right-click the table → Refresh).

Queries & Connections (Data tab) lists queries; you can refresh one query or refresh all.

Refresh pulls the latest content from the same URL or file path. It does not re-ask you to pick a different table unless you edit the query.

What Associate candidates should know for tasks:

  • Situation What to do
  • Task says "refresh the imported data" Click Refresh on the Data tab or table shortcut menu
  • Source URL temporarily unavailable Refresh fails; do not replace with paste unless instructed

You need a one-time snapshot Copy values after load, or use Paste Special → Values—but only if the task wants static data

Task never mentions refresh Loading correctly is enough; do not over-engineer

You are not expected to schedule background refresh, write custom refresh VBA, or build multi-step ETL pipelines.

From Web vs copy-paste vs From Text/CSV

Choose the method the task descriptor implies:

From Web — Instructions mention a website, URL, online table, or "import from the web."

From Text/CSV — Instructions name a .csv / .txt file in the exam files folder.

Copy-paste — Instructions say to copy a range from a webpage or document and paste into Excel as ordinary cells. Pasted data is usually static (no query). Use paste when the project literally tells you to copy, or when you are transferring a small block that is not presented as a Get Data source.

Why Get Data is preferred when the skill is "import"

Import via Get Data keeps column types more consistent, can preserve a refresh link, and matches the objective wording import data from online sources . Pasting can break numeric formats, bring unwanted HTML formatting, and leave no connection to refresh. On a performance exam, matching the intended tool matters as much as ending with similar-looking cells.

Exam-style scenarios

Scenario A: "Import the currency rates table from the URL provided in the instructions onto a new worksheet named Rates."

Data → From Web → paste URL → OK.

In Navigator, select the table whose preview shows currency codes and rates.

Load To → Table → New worksheet, then rename the sheet to Rates (or load then rename, depending on what is fastest and allowed).

Scenario B: "Update the workbook so the imported web data shows the latest values."

Click inside the existing imported table.

Data → Refresh All (or Refresh).

Confirm row values changed if the source changed; do not re-import a second copy unless asked.

Scenario C: "Add the three product names from the company webpage into cells A1:A3."

That wording points to a small manual copy, not a full From Web table load. Overusing From Web here can create an entire table and extra query the grader did not request.

Associate boundaries (avoid MO-211 drift)

Stay out of Expert-only complexity unless the task explicitly requires a simple transform:

Do not build parameterized URLs, API keys, or OAuth flows beyond accepting a credential prompt.

Do not design multi-query merges, appends, or data models for their own sake.

Do not rewrite page HTML. If Navigator cannot see a table, re-check the URL and try another listed table—or follow alternate instructions in the project.

Practical tips that save time

Paste URLs carefully; a missing character yields empty Navigator results.

After Load, rename the sheet and table if the task specifies names—import alone may leave default names like Table1 / Sheet2 .

If the task also asks to convert the result to a range or apply table style options, finish the import first, then complete those Domain 3 steps.

Keep one query per required source; duplicate imports waste time and confuse Refresh All.