• alcoholicorn@lemmy.ml
    link
    fedilink
    arrow-up
    7
    ·
    edit-2
    7 days ago

    You can also use BULK INSERT for csvs or just INSERT INTO and some text editing depending on the specifics.

    This is more for one-off stuff like analyzing some 10,000 row spreadsheet you’ve been handed that you could probably do with formulas in excel, but it’s easier to use sql, but not worth building a proper process for.