/obsidian-table-editor

An Obsidian plugin to provide an editor for Markdown tables. It can open CSV data and data from Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice Calc as Markdown tables from Obsidian Markdown editor.

Primary LanguageTypeScriptMIT LicenseMIT

Obsidian Table Editor

An Obsidian plugin to provide an editor for Markdown tables. It can open CSV, Microsoft Excel/Google Sheets data as Markdown tables from Obsidian Markdown editor.

Obsidian Table Editor

Tag 0.3.1 MIT License codecov

Table of Contents

1. Usage Guide

Changelog 0.2.0

Thank you @cumany, for this release.

  1. Added "Update Table" button
  2. Added support for popover window (if obsidian-hover-editor plugin is installed)
bandicam.2022-03-17.22-55-19-219.mp4

@emisjerry has made a video walkthrough of this plugin in Chinese (with English subtitle). Thank you emisjerry!

1.1 Create a New Table

  1. Click Open Markdown Table Editor button from the ribbon.
  2. Use Markdown Table Editor: Open Editor command from the command palette.

Create a New Table

1.2 Edit and format an existing Markdown Table

  1. Select the markdown content or just place the cursor inside the table content
  2. Open Markdown Table Editor

Edit and format an existing Markdown Table

1.3 CVS data to Markdown Table

  1. Select the CSV content or just place the cursor inside the CSV content
  2. Open Markdown Table Editor

CVS data to Markdown Table

1.4 Excel or Sheets to Markdown Table

  1. Select the Excel data (pasted via Ctrl/Cmd + Shift + V) or just place the cursor inside the Excel data
  2. Open Markdown Table Editor

Excel Sheets to Markdown Table

1.5 Operations

The following operations are supported

Cell Operations

  • Row
    • Add row above
    • Add row below
    • Delete row
    • Move row up
    • Move row down
  • Column
    • Add column above
    • Add column below
    • Delete column
    • Move column up
    • Move column down

Header Operations

  • Justify
    • Left
    • Center
    • Right
  • Sort
    • Text
      • Ascending
      • Descending
    • Numberic
      • Ascending
      • Descending

operations

1.6 Selecting table

  1. Just place the cursor inside Markdown table or CSV or Excel data
  2. Invoke the command "Markdown Table Editor: Select surrounding Table Content" command from the command palette.

selecting table content

1.7 Opening the Table Editor below the active leaf

  1. You can right click the ribbon icon and select "Open Editor (Below the Active View)" to split the current view horizontally and open the Table Editor below.
  2. You can also do it from the command palette using the "Markdown Table Editor: Open Editor (Below the Active View)" command.

horizontal spilit

2. Installation

2.1 From GitHub

  1. Download the Latest Release from the Releases section of the GitHub Repository
  2. Put files to your vault's plugins folder: <vault>/.obsidian/plugins/obsidian-excel-to-markdown-table
  3. Reload Obsidian
  4. If prompted about Safe Mode, you can disable safe mode and enable the plugin.
    Otherwise, head to Settings, third-party plugins, make sure safe mode is off and enable the plugin from there.

Note: The .obsidian folder may be hidden. On macOS, you should be able to press Command+Shift+Dot to show the folder in Finder.

3. License

MIT

4. Acknowledgements

  1. Special thanks for @FelipeRearden for his valuable feedback and feature suggestions that has helped shaping up this plugin!
  2. Thank you @cumany, for adding "Update Table" button and adding support for popover window.

5. Other Obsidian plusins/tools made by me

# Name/Repo Link Type
1 Obsidian Excel to Markdown Table Plugin
2 Obsidian Clipper Maker Live Link Tool
3 Obsidian Plugin Stats Live Link Tool

If you like my work, you could consider buying me a coffee. It is unnecessary, but appreciated 🙂

Buy Me A Coffee