将维基百科世界杯球队表导入Google Sheets时出现公式解析错误

Let's break down why you're hitting that #ERROR! and fix it step by step:

• First, fix the quote marks: The biggest culprit here is the Chinese-style quotation marks (“”) in your formula. Google Sheets only recognizes standard English double quotes ("") for string values. Swap those out, and you'll eliminate the most common cause of a Formula Parse Error here.

• Check the table index: The 1 at the end of your formula tells importHTML to grab the first table on the page. But the "Qualified teams" table isn't the first one on that Wikipedia page—there are several tables above it (like confederation breakdowns, qualification slots per region, etc.).

  To find the correct index easily:

  1. Open the Wikipedia page in your browser
  2. Scroll through and count tables starting from the top (the first visible table = index 1)
  3. The "Qualified teams" table is actually the 9th table on the page (you can count to confirm this yourself!)

• Optional: Remove the anchor tag: While the #Qualified_teams anchor doesn't break things outright, importHTML doesn't use it to target tables—it pulls all tables from the full page. You can safely omit it if you want, but it won't hurt to leave it in once the other issues are fixed.

Corrected Formula #

Try this adjusted formula first (with proper quotes and correct table index):

=importHTML("https://en.wikipedia.org/wiki/2018_FIFA_World_Cup_qualification","table",9)

If you still run into issues, try refreshing your sheet (File > Reload) or checking if Google Sheets has any temporary import restrictions—though the above fixes should resolve the formula parse error you're seeing.

内容的提问来源于stack exchange，提问作者Potato Toddler