How do I pull this website data?

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

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,126,992
Messages
5,622,033
Members
415,874
Latest member
JockPC

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