it's possible to import a Wikipedia table into Google Sheets: but not for me... : r/excel Skip to main content

Get the Reddit app

Scan this QR code to download the app now
Or check it out in the app stores
r/excel icon
r/excel icon
Go to excel
r/excel
A banner for the subreddit

A vibrant community of Excel enthusiasts. Get expert tips, ask questions, and share your love for all things Excel. Elevate your spreadsheet skills with us!


Members Online

it's possible to import a Wikipedia table into Google Sheets: but not for me...

unsolved

it's possible to import a Wikipedia table into Google Sheets.

if we take this: page we have about 600 records ( links ) on the list: https://de.wikipedia.org/wiki/Liste_der_Genossenschaftsbanken_in_Deutschland

i try to do so - and go to google pages: into cell A1

with the following command:

=importhtml("https://de.wikipedia.org/wiki/Liste_der_Genossenschaftsbanken_in_Deutschland","table")

but this failes:

note: if we take this: page we have aboutz 600 records ( links ) on the list: https://de.wikipedia.org/wiki/Liste_der_Genossenschaftsbanken_in_Deutschland

i want to fetch all the names of the banks - and the corresponding links

Share
Sort by:
Top
Open comment sort options
u/AutoModerator avatar
Moderator Announcement Read More »