How to import table from web site to excel

Outdoor

Hello there,

I would like to import this table
to excel.

Non-IT people need to do it every day.

What would be the simplest way to do it?

Excel import from the web is not working https://prnt.sc/SbK550UvlotA

Regards

webhorizon

https://chromewebstore.google.com/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop?hl=en

ailice

~~You can technically making simple scripting to output it to csv, or just use phpmyadmin / adminer to export as CSV
Excel would happy open CSV~~
Edit : Nevermind, I though you call table SQL

itachikonoha

1. Get the their api end point url (go to chrome dev console and check the responses of fetch/xhr). It will give you JSON data.

2. Save those JSON data (you can name the file whatever; doesn't make any significance)

3. Convert json to excel with any tool available.

---

If needs to be done everyday by non tech people then I would have opted for the following:

1. Send a curl request with daily cron to consume the data coming from their endpoint.
2. Save the incoming data to the database.
3. give the non techy people a button where they can click and the server will output the excel file based on the data which was consumed in step 1.

rust, python, nodejs, php.... you can do it in any programming language.

noob404

Are you looking to download tables as spreadsheets from any random website, or are you planning to add a button to your own website to allow people to download your tables as spreadsheets?

Outdoor

@webhorizon said:
https://chromewebstore.google.com/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop?hl=en

Thanks, but it is not working with pagination or I did not use it right.

@ailice said:
~~You can technically making simple scripting to output it to csv, or just use phpmyadmin / adminer to export as CSV
Excel would happy open CSV~~
Edit : Nevermind, I though you call table SQL

It is not my web site
I do not have access.

@itachikonoha said:
1. Get the their api end point url (go to chrome dev console and check the responses of fetch/xhr). It will give you JSON data.

2. Save those JSON data (you can name the file whatever; doesn't make any significance)

3. Convert json to excel with any tool available.

---

If needs to be done everyday by non tech people then I would have opted for the following:

1. Send a curl request with daily cron to consume the data coming from their endpoint.
2. Save the incoming data to the database.
3. give the non techy people a button where they can click and the server will output the excel file based on the data which was consumed in step 1.

rust, python, nodejs, php.... you can do it in any programming language.

But they don't have any API

@noob404 said:
Are you looking to download tables as spreadsheets from any random website, or are you planning to add a button to your own website to allow people to download your tables as spreadsheets?

I need to download the table from this web site to excel.
This is not my website and I don't need this table on my web site

itachikonoha

@Outdoor

Just check the requests in dev console and there's already an endpoint for retrieving the json data (there is even options for filtering).

Whether they legally allow these data to be used, that's a whole another circumstance. But since it's just a js data table, client side fetching will be always possible.

hyperblast

hmm...

hostnoob

http://zbirniregistri.gov.ba/Home/ReadNGOs

Save file (containing JSON data)

Upload here

https://www.convertcsv.com/json-to-csv.htm

"JSON to Excel"

You'll have to do a find/replace for the date though.

szarka

@hostnoob said:
http://zbirniregistri.gov.ba/Home/ReadNGOs

Save file (containing JSON data)

Upload here

https://www.convertcsv.com/json-to-csv.htm

"JSON to Excel"

You'll have to do a find/replace for the date though.

You don't need this third-party site if you have a reasonably up-to-date version of Excel.

1. Data | Get Data | From Other Sources | From Web
2. Paste in the http://zbirniregistri.gov.ba/Home/ReadNGOs URL
3. Click on the List next to Data to expand to a list of Records.
4. Convert to Table
5. Click on the expansion icon next to Column1.
6. Close & load to your worksheet

Outdoor

I have made it work with these steps using PowerShell:

Install-Module -Name ImportExcel -Force -Scope CurrentUser

Set-ExecutionPolicy -Scope CurrentUser -ExecutionPolicy Unrestricted

Import-Module ImportExcel

Fetch JSON data

$JsonResponse = Invoke-RestMethod -Uri "http://zbirniregistri.gov.ba/Home/ReadNGOs"

Extract the 'Data' array

$NGOs = $JsonResponse.Data

Export to Excel

$NGOs | Export-Excel -Path "NGOs.xlsx" -AutoSize -TableStyle Medium2

Write-Host "Excel file saved as 'NGOs.xlsx'."

letstayfree

Nowadays chatgpt would help such kinda things. You can use bolt.new to write a tool with Python or powelshell scripts with little it knowledge