SheetJS – Parse And Manipulate Excel Spreadsheets In The Browser

Home » Blog » Software » Web Applications » SheetJS – Parse And Manipulate Excel Spreadsheets In The Browser

SheetJS (source code available on GitHub) is an extremely useful JavaScript library that enables you to have Microsoft Excel spreadsheets parsed directly in the browser without any backend interaction necessary.

What makes SheetJS even more impressive is the ability to query spreadsheets in-place with an SQLite-compatible SQL language called WebSQL. Check out the example on the website to see how awesome this is.

Together with a grid component such as Handsontable (source code) SheetJS allows for on-the-fly display, querying and manipulation of Excel spreadsheets.

For a more complex real life use case see this blog post by Patrick McKenzie: Design and Implementation of CSV/Excel Upload for SaaS

One comment

    Leave a Comment

    * Checkbox GDPR is required

    *

    I agree

    By continuing to browse the site you agree to our use of cookies. Privacy Policy

    Privacy Preference Center

    Strictly necessary

    These cookies are necessary for the site to function.

    PHPSESSID: Preserves user session state across page requests.

    __cfduid: Used by the content network, Cloudflare, to identify trusted web traffic.

    PHPSESSID
    __cfduid

    Preferences

    Remembers the user's submitted data when a comment is submitted in a blog post. The purpose is to aut o-populate form fields for subsequent comments, in order to save time for the user.

    wfvt_#

    Statistics

    Statistic cookies help us to understand how visitors interact with our websites by collecting and reporting information anonymously.

    _ga: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

    _gat: Used by Google Analytics to throttle request rate.

    _gid: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

    collect: Used to send data to Google Analytics about the visitor's device and behaviour. Tracks the visitor across d evices and marketing channels.

    _ga,_gat,_gid
    collect

    Security

    We use Wordfence to secure our website against hacking attempts: https://www.wordfence.com/

    wordfence_verifiedHuman

    Close your account?

    Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?