Import table from Excel online

  • Resolved joncwhall

    (@joncwhall)


    2 years, 10 months ago

    Hi,

    Is it possible to import a table from an online Excel sheet?

    I currently copy and paste the contents needs into an Excel file on my PC then Import that but was wondering if I can set it to Auto Import directly from the original Excel online file?

    Thanks,

    Jon

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    2 years, 10 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, this is not directly possible from within Excel Online, as they don’t seem to have a public CSV sharing URL. However, if you do this from within Onedrive, where the Excel table is stored, this could work, according to https://paperform.co/blog/onedrive-direct-download-link/#how-to-create-a-onedrive-direct-download-link

    That link describes how to get the proper URL that can be used for the import in TablePress:
    – Find the table/file in question in Onedrive.
    – Right click on it and choose “Embed”.
    – You will be seeing an embed HTML code similar to

    <iframe src="https://onedrive.live.com/embed?......" width="402"
height="346" frameborder="0" scrolling="no"></iframe>

    with a rather long and cryptic URL in the “src” parameter.
    – Copy/paste only that URL.
    – Replace “embed” (after onedrive.live.com/) with “download”.
    – That URL, when opened in the browser, should directly return an XLSX
    file offered for download.
    – If that works, you can use that URL on the “Import” screen of TablePress 🙂

    Best wishes,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Import table from Excel online’ is closed to new replies.