M
M
Mr.2020-04-17 09:12:21
Google Sheets
Mr., 2020-04-17 09:12:21

How to import data from a website into Google Sheets?

Not all data but a few necessary data.

  • URL Any of this domain, not an example, https://readmanga.me/hero__i_quit_a_long_time_ago
  • Scrolling down, there is a table. And it's the very first line.
  • The data is a number, at the moment it is 90 and the release date is 04/17/20 at the moment

I only need these two values ​​separately and nothing more.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2020-04-18
@ALeBig

As an option

=INDEX(IMPORTHTML("https://readmanga.me/hero__i_quit_a_long_time_ago";"table";0);2;)

5e9afd773dab5805992810.png
Extract only a specific number
=REGEXEXTRACT(
  INDEX(IMPORTHTML("https://readmanga.me/hero__i_quit_a_long_time_ago";"table";0);2;1);
  ".*?\-.*?(\d+)"
)

5e9c21e3322c1169640251.png
Example in Spreadsheet https://docs.google.com/spreadsheets/d/1sq3ooY18FY...

D
Dimonchik, 2020-04-17
@dimonchik2013

in the 1st everything, in the second - the filter - not all

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question