Hallo, nutze die Funktion als Hilfe
https://support.google.com/docs/table/25273?hl=de&rd=2 GoogleIMPORTDATAIMPORTDATA(URL)Importiert Daten unter einer bestimmten URL im CSV-Format (Comma-Separated Value; zeichengetrennt) oder im TSV-Format (Tab-Separated Value; tabulatorgetrennt). Weitere Informationen <https://support.google.com/docs/answer/3093335>GoogleIMPORTFEEDIMPORTFEED(URL; Abfrage; Überschriften; Anzahl_Inhalte)Importiert einen RSS- oder Atom-Feed. Weitere Informationen <https://support.google.com/docs/answer/3093337>GoogleIMPORTHTMLIMPORTHTML(URL; Abfrage; Index)Importiert Daten aus einer Tabelle oder Liste auf einer HTML-Seite. Weitere Informationen <https://support.google.com/docs/answer/3093339>GoogleIMPORTRANGEIMPORTRANGE(Tabellenschlüssel; Bereichszeichenfolge)Importiert einen Zellenbereich aus einer angegebenen Tabelle.Weitere Informationen <https://support.google.com/docs/answer/3093340>GoogleIMPORTXMLIMPORTXML(URL; XPath_Abfrage)Importiert Daten aus einer Reihe verschiedener strukturierter Daten, darunter XML, HTML, CSV und TSV sowie RSS- und Atom-XML-Feeds. Weitere Informationen <https://support.google.com/docs/answer/3093342> 2015-05-28 13:21 GMT+02:00 Av <[email protected]>: > Hi, > I need google sheets to pull data from the web based on a field of data > within the sheet - pulling the top web result information fields relating > to the search e.g - the name, address, e-mail etc... if possible! > (almost like a vlookup google search) > > I just need the data returning from the TOP listing in google search page > relating to the search query. > > eg my i have a field in my sheet that has a telephone number 012112345667, > (which will change) i just need within google sheets to go off and pull the > top results data into google sheets - Company name, address, e-mail etc. > > Can somone advise on how to do this? > > -- > You received this message because you are subscribed to the Google Groups > "Google Spreadsheets API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
