Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links


Shells Virtual Desktop
BMail.ag - Secure Email Service
Server.net
CPLicense.net
VPS Server
Buy VPN
Vultr
VMs for AI
HostDare
ReliableSite White-Label Dedicated Hosting for Resellers
InterServer VPS
BMail.ag - Secure Email Service
Best VPN
High-Performance Bare Metal Server Solutions
Karvl.com
Server Mania Cloud Hosting
DataWagon Hosting
AlphaVPS Hosting
Evoxt.com
Clouvider
VPS Hosting with NVMe
Residential IPs in the US & 4G Mobile Proxies in EU & US with Unlimited Bandwidth
ReliableSite White-Label Dedicated Hosting for Resellers
Rabisu - Hosting Solutions
Shells Virtual Desktop

Categories

In this Discussion

Home › Help
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

How to import table from web site to excel

OutdoorOutdoor Member
edited January 2025 in Help

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

Comments

  • webhorizonwebhorizon Member, Host Rep

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

    Thanked by 1Void
  • ailiceailice Member
    edited January 2025

    ~~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

  • itachikonohaitachikonoha Member
    edited January 2025

    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.

  • noob404noob404 Member

    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?

  • OutdoorOutdoor Member

    @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.

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

    2. 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 :)

  • itachikonohaitachikonoha Member

    @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.

  • hyperblasthyperblast Member
    edited January 2025

    hmm...

    Thanked by 1yoursunny
  • hostnoobhostnoob Member

    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.

  • szarkaszarka Member

    @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
    Thanked by 1cainyxues
  • OutdoorOutdoor Member

    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'."

    Thanked by 1szarka
  • letstayfreeletstayfree Barred

    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

Sign In or Register to comment.