How do I pull this website data?

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
first update your profile about Excel version and OS
 

Bob Todd

New Member
Joined
Mar 27, 2017
Messages
12
Office Version
  1. 2016
Platform
  1. Windows
  2. Mobile

ADVERTISEMENT

Sandy's correct, It would help to know what version you are using.
 

srallen3

New Member
Joined
Feb 26, 2016
Messages
31
Office Version
  1. 2019
Platform
  1. Windows
Sandy's correct, It would help to know what version you are using.
Just updated. Office 2019. Just weird that I can pull tables/data on other sites no issues. Guess the second part of this table with the game statistics are implemented differently.
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499

ADVERTISEMENT

is that what you want?
RKTeamGPPTSFGMFGAFG%3PM3PA3P%FTMFTAFT%ORDRREBASTSTLBLKTOPF
1Phoenix Suns698.73782.2458.528.33016.222.870.88.23543.2206.33.31420.3
2New Orleans Pelicans599.236.283.443.41542.83511.815.476.66.833.24025.87.84.816.221.6
3Philadelphia 76ers599.836.888.841.410.830.435.515.419.479.49.834.844.623.285.215.822.8
4Dallas Mavericks5103.637.481.645.811.233.833.117.623.475.2936.645.623.46.84.21624
5Toronto Raptors4103.838.38843.51135.830.816.322.373104050278.35.818.318.3
6New York Knicks5105.238.889.643.31037.426.717.624.671.512.43547.4238.47.21320.6
7Utah Jazz5106.239.289.643.81433.242.213.817.678.48.431.840.22275.410.419
8Indiana Pacers51073883.445.611.6274319.426.672.99.63241.622.48.66.217.419.6
9Los Angeles Lakers6107.840.390.544.61235.234.115.220.5748.831.840.723.59512.321.5
10Cleveland Cavaliers5108.238.886.644.814.837.239.815.822.869.39.835.445.225.6104.219.419.8
10Charlotte Hornets5108.239.686.845.613.438.834.515.622.469.69.637.847.4289.25.416.418.8
12LA Clippers6108.83883.845.312.337.33320.525.779.99.733.242.822.76313.517.7
13Milwaukee Bucks6110.540.588.845.612.735.735.516.821.777.77.833.841.721.775.515.819.8
14Boston Celtics611141.886.548.411.331.735.81620.876.89.833.843.722.37.75.516.719.3
15Miami Heat5111.239.287.644.715.438.440.117.422.876.310.434.244.623.4123.216.422.2
16Brooklyn Nets6111.841.597.242.71234.734.616.822.873.714.835.850.725.87.23.814.222
17Oklahoma City Thunder411243.391.547.311.531.536.51420.369.111.836.848.52510.3512.820
18San Antonio Spurs5112.243.293.646.211.630.238.414.219.672.410.239.649.825.27.46.211.820.6
19Orlando Magic5112.644.490.64910.831.234.61318.869.18.83846.824.66.45.216.622.6
20Detroit Pistons5115.240.685.647.413.235.437.320.82874.37.638.245.8258.86.81622
21Atlanta Hawks5115.44192.844.21239.430.521.425.484.310.632.643.222.66.84.411.222.8
22Sacramento Kings5115.644.691.448.811.434.433.11518.680.6933.842.8287.4614.420
23Portland Trail Blazers5115.841.488.446.8133735.12024.880.68.438.246.6246.25.613.221
24Memphis Grizzlies5116.642.292.245.812.434.635.819.823.883.210.836.447.225.810.26.814.418.8
25Denver Nuggets5117.441.686.448.114.835.24219.424.280.210.430.440.828.26.4414.624.8
26Minnesota Timberwolves5118.645.490.85012.633.637.515.220769.23847.228.66.26.615.219.8
27Washington Wizards612042.78947.911.73236.52329.278.99.535.54523.88.3314.722
28Chicago Bulls6123.54388.348.714.536.539.72329.278.98.235.8442711.34.516.525.3
29Houston Rockets3123.7469548.414.736.340.41726.364.61235.347.3279.75.713.719.7
30Golden State Warriors512442.290.446.7173844.722.629.676.41142.453.42485.217.222.6
 

srallen3

New Member
Joined
Feb 26, 2016
Messages
31
Office Version
  1. 2019
Platform
  1. Windows
is that what you want?
RKTeamGPPTSFGMFGAFG%3PM3PA3P%FTMFTAFT%ORDRREBASTSTLBLKTOPF
1Phoenix Suns698.73782.2458.528.33016.222.870.88.23543.2206.33.31420.3
2New Orleans Pelicans599.236.283.443.41542.83511.815.476.66.833.24025.87.84.816.221.6
3Philadelphia 76ers599.836.888.841.410.830.435.515.419.479.49.834.844.623.285.215.822.8
4Dallas Mavericks5103.637.481.645.811.233.833.117.623.475.2936.645.623.46.84.21624
5Toronto Raptors4103.838.38843.51135.830.816.322.373104050278.35.818.318.3
6New York Knicks5105.238.889.643.31037.426.717.624.671.512.43547.4238.47.21320.6
7Utah Jazz5106.239.289.643.81433.242.213.817.678.48.431.840.22275.410.419
8Indiana Pacers51073883.445.611.6274319.426.672.99.63241.622.48.66.217.419.6
9Los Angeles Lakers6107.840.390.544.61235.234.115.220.5748.831.840.723.59512.321.5
10Cleveland Cavaliers5108.238.886.644.814.837.239.815.822.869.39.835.445.225.6104.219.419.8
10Charlotte Hornets5108.239.686.845.613.438.834.515.622.469.69.637.847.4289.25.416.418.8
12LA Clippers6108.83883.845.312.337.33320.525.779.99.733.242.822.76313.517.7
13Milwaukee Bucks6110.540.588.845.612.735.735.516.821.777.77.833.841.721.775.515.819.8
14Boston Celtics611141.886.548.411.331.735.81620.876.89.833.843.722.37.75.516.719.3
15Miami Heat5111.239.287.644.715.438.440.117.422.876.310.434.244.623.4123.216.422.2
16Brooklyn Nets6111.841.597.242.71234.734.616.822.873.714.835.850.725.87.23.814.222
17Oklahoma City Thunder411243.391.547.311.531.536.51420.369.111.836.848.52510.3512.820
18San Antonio Spurs5112.243.293.646.211.630.238.414.219.672.410.239.649.825.27.46.211.820.6
19Orlando Magic5112.644.490.64910.831.234.61318.869.18.83846.824.66.45.216.622.6
20Detroit Pistons5115.240.685.647.413.235.437.320.82874.37.638.245.8258.86.81622
21Atlanta Hawks5115.44192.844.21239.430.521.425.484.310.632.643.222.66.84.411.222.8
22Sacramento Kings5115.644.691.448.811.434.433.11518.680.6933.842.8287.4614.420
23Portland Trail Blazers5115.841.488.446.8133735.12024.880.68.438.246.6246.25.613.221
24Memphis Grizzlies5116.642.292.245.812.434.635.819.823.883.210.836.447.225.810.26.814.418.8
25Denver Nuggets5117.441.686.448.114.835.24219.424.280.210.430.440.828.26.4414.624.8
26Minnesota Timberwolves5118.645.490.85012.633.637.515.220769.23847.228.66.26.615.219.8
27Washington Wizards612042.78947.911.73236.52329.278.99.535.54523.88.3314.722
28Chicago Bulls6123.54388.348.714.536.539.72329.278.98.235.8442711.34.516.525.3
29Houston Rockets3123.7469548.414.736.340.41726.364.61235.347.3279.75.713.719.7
30Golden State Warriors512442.290.446.7173844.722.629.676.41142.453.42485.217.222.6
I did not know that, yes that is what I want!
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
so use Power Query
Power Query:
// Table 0
let
    Source = Web.Page(Web.Contents("https://www.espn.com/nba/stats/team/_/view/opponent")),
    Data0 = Source{0}[Data],
    Index = Table.AddIndexColumn(Data0, "Index", 1, 1)
in
    Index

Power Query:
// Table 1
let
    Source = Web.Page(Web.Contents("https://www.espn.com/nba/stats/team/_/view/opponent")),
    Data1 = Source{1}[Data],
    Index = Table.AddIndexColumn(Data1, "Index", 1, 1)
in
    Index

Power Query:
// Merge1
let
    Source = Table.NestedJoin(#"Table 0",{"Index"},#"Table 1",{"Index"},"Table 1",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Source, "Table 1", {"GP", "PTS", "FGM", "FGA", "FG%", "3PM", "3PA", "3P%", "FTM", "FTA", "FT%", "OR", "DR", "REB", "AST", "STL", "BLK", "TO", "PF"}, {"GP", "PTS", "FGM", "FGA", "FG%", "3PM", "3PA", "3P%", "FTM", "FTA", "FT%", "OR", "DR", "REB", "AST", "STL", "BLK", "TO", "PF"}),
    RC = Table.RemoveColumns(Expand,{"Index"}),
    Type = Table.TransformColumnTypes(RC,{{"RK", Int64.Type}, {"Team", type text}, {"GP", Int64.Type}, {"PTS", type number}, {"FGM", type number}, {"FGA", type number}, {"FG%", type number}, {"3PM", type number}, {"3PA", type number}, {"3P%", type number}, {"FTM", type number}, {"FTA", type number}, {"FT%", type number}, {"OR", type number}, {"DR", type number}, {"REB", type number}, {"AST", type number}, {"STL", type number}, {"BLK", type number}, {"TO", type number}, {"PF", type number}})
in
    Type
just in case
 

Watch MrExcel Video

Forum statistics

Threads
1,129,700
Messages
5,637,882
Members
416,988
Latest member
Ahmed_Yehia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top