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!
it's possible to import a Wikipedia table into Google Sheets: but not for me...
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
u/saint_leonard - Your post was submitted successfully.
Once your problem is solved, reply to the answer(s) saying
Solution Verified
to close the thread.Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
Include your Excel version and all other relevant information
Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.