• alcoholicorn@lemmy.ml
      link
      fedilink
      arrow-up
      7
      ·
      edit-2
      12 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.