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.

Table of Contents

• Obsidian Table Editor
  • 1. Usage Guide
    • 1.1 Create a New Table
    • 1.2 Edit and format an existing Markdown Table
    • 1.3 CVS data to Markdown Table
    • 1.4 Excel or Sheets to Markdown Table
      • 1.5 Operations
        • Cell Operations
        • Header Operations
  • 2. Installation
    • 2.1 From GitHub
  • 3. License
  • 4. Other Obsidian plusins/tools made by me

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)

@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.

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

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

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

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

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.

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.

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

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