Import data from a spreadsheet into a database

I'd like to know how to import data from a spreadsheet into a database or convert a table into a database. What's the best way to add multiple rows of information to the database at once?

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...
    • massivebox
      PRO

      Even though there is at least a plugin that should improve the database importing capabilities of SiYuan, I've tried it and I haven't gotten it to work.

      Therefore, I find that the best option now is to simply copy the spreadsheet and paste it into the database.

      You can find a better guide in this comment I left a while ago: Table to Database (Solved) - massivebox reply

    • MiscReply
    • ACai

      表格文件转思源数据库 - by 浅沧 - 动作信息 - Quicker

      There is also an action in Quicker (a third-party app) that can import selected Excel and other files, and lets you customize the field types.

      Quicker is like macOS Shortcuts for Windows

    • 45782
      VIP Warrior Author

      It worked perfectly. Thank you!