An Obsidian plugin to provide an editor for Markdown tables

Overview

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.2.1 MIT License

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: /.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

Comments
  • [Feature Request] New Command: Select  Markdown Table

    [Feature Request] New Command: Select Markdown Table

    **Is your feature request related to a problem? Please describe. ** Since the starting point to edit tables is to make a selection of the markdown table in the note, I think would be amazing if we have a new command that selects a table based on the position of the caret cursors.

    Describe the solution you'd like If the caret cursor is placed inside a markdown table, hitting the new command will select the entire table !


    Thanks for reading this!

    Have a great day!!!!

    opened by FelipeRearden 17
  • [Question] Code Highlight for Excel Commands Syntax

    [Question] Code Highlight for Excel Commands Syntax

    Hello @ganesshkumar !!!!!

    Sorry to bother you with a question that is not 100% related to this plugin.

    I’m, finally starting to migrate my EXCEL knowledge to an Obsidian note and I’d like to ask something …

    Do you know if there is an code syntax highlight for EXCEL commands.

    =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
    

    Is there any code syntax that I could use to highlight the arguments of a command in a code block ?

    1FAFEB08-1FDC-4AF4-965A-9E9436BDD253


    Thanks for your help :)

    I wish you a fantastic day!

    opened by FelipeRearden 8
  • [BUG]

    [BUG] "\" Is not processed

    Describe the bug When using \ to use a link alias, the "\" doesn't get processed and the link gets split to two columns.

    To Reproduce Steps to reproduce the behavior:

    1. In a table, [[enter a link\|with an alias]]
    2. Open the markdown table editor
    3. Two columns show up, split at |

    Expected behavior There should be only 1 column, with the alias displayed properly.

    Screenshots Error/multiple columns: image

    What it normally looks like: image

    Desktop (please complete the following information):

    • OS: Windows
    • Version 10
    opened by shunnkou 8
  • [Feature Request] Remember location to open

    [Feature Request] Remember location to open

    I'd like the window to always open bellow. Now, the default setting is that when I click the button it opens in the side. This is kinda bothersome when I'm using Sliding Panes.

    enhancement 
    opened by ndharari 5
  • [Feature Request] Option to choose where to open MTE

    [Feature Request] Option to choose where to open MTE

    I know that we can set hotkeys for different locations for the MTE (under, right, floating), but I'd like an option to set where to open it when clickiung on the icon in the left sidebar.

    Also, the MTE commands are not available in the Command Palette (at least for me), they only works by hotkey.

    enhancement 
    opened by Cammagno 5
  • [BUG] Create a New Table - Version 0.1.2

    [BUG] Create a New Table - Version 0.1.2

    Describe the bug when creating a new table using the commands Open Editor Below and Open Editor Next the MTE window opens empty :(

    To Reproduce On an Active Note

    1. Go to a empty line
    2. Select one of the two commands : Open Editor Below or Open Editor Next
    3. See error (images 1 and 2)

    Screenshots 50 51

    Desktop (please complete the following information):

    • OS: Windows 7
    • Version 0.1.1
    • Obsidian 0.13.23

    Additional context Sorry for bring problems @ganesshkumar !!!!

    Let me know if you need more information

    question 
    opened by FelipeRearden 5
  • [BUG]: Table not readable in Dark mode

    [BUG]: Table not readable in Dark mode

    Great plugin! I just uninstalled Tableflip after trying this one out :)

    Describe the bug The pane is not readable in Dark Mode. Happens in the default theme, so it's not a theme issue. Screenshot 2022-02-26 22 22 54

    To Reproduce switch to dark mode

    Expected behavior better styling, grey is too light and the white on gray not readable

    opened by chrisgrieser 5
  • [Feature Request] Support for embedded table in callouts

    [Feature Request] Support for embedded table in callouts

    For example, the following two types of callouts are written The obsidain-table-editor plugin cannot render:

    > [!NOTE]
    > | title | content |
     | ----- | ------- |
     | 1111      |    333     |
    

    or

    > [!NOTE]
    > | title | content |
    >  | ----- | ------- |
    > | 1111      |    333     |
    
    enhancement 
    opened by cumany 4
  • [Feature Request] Caret Cursor Focused on the  `Rows:` filed

    [Feature Request] Caret Cursor Focused on the `Rows:` filed

    **Is your feature request related to a problem? Please describe. ** Hello @ganesshkumar !!!!!

    When using the command to Open Md Table Editor Window, would be amazing if the caret cursor is fosused in the first text field Rows:.

    This way I could just start to create/edit my table using only the keyboard !!!!!!

    • Since I can use TAB to navigate between the fields in the window :)

    Describe alternatives you've considered None

    Additional context Not this time.

    Thank you very much for creating this. It´s a plugin that I wanted in Obsidian for a long time. Now I can finally create/edit tables without effort :)

    I wish you a fantastic day!!!!!

    opened by FelipeRearden 4
  • [BUG] CSV to Editor failed

    [BUG] CSV to Editor failed

    My simple CSV content:

    111,222,333
    444,555,666
    777,888,999
    

    Select these lines, invoke Table Editor. It responsed:

    image

    Obsidian: v0.14.9 Table Editor: latest version

    bug 
    opened by emisjerry 3
  • Feature Request: Open in Hover Editor

    Feature Request: Open in Hover Editor

    Being able to open the table view in the hover editor would make this plugin really great!

    similar to this https://discord.com/channels/686053708261228577/855181471643861002/961957079952789515

    opened by chrisgrieser 3
  • [Feature Request]Quickly add multiple rows

    [Feature Request]Quickly add multiple rows

    Thank you for your work, it made my studies a great convenience!

    While reading the literature, I accumulate my words through obsidian-table-editor. Unfortunately, I couldn't know how many lines I needed to set to record words at the beginning, and I kept adding new lines over and over again. Even more annoying is that currently obsidian-table-editor can only add one line at a time.

    Hope obsidian-table-editor can consider doing things like Excel: 1) manually enter the number of rows added in bulk, or 2) select multiple rows to copy and paste and get more rows.

    opened by linfengtongxue70 0
  • [Feature Request] Provide some mechanism for adjusting column widths in the editor

    [Feature Request] Provide some mechanism for adjusting column widths in the editor

    **Is your feature request related to a problem? Please describe. ** I have many tables with a first column that contains brief (often one-word) headings/topics, while the later columns have long content. Yet in the table editor at the moment, that first column always takes up the same share of the width of the editor window, resulting in a great deal of useless whitespace and making the other columns wrap into many more lines than necessary.

    Describe the solution you'd like Some form of auto-width-calculation of the editor table might be nice; the obsidian preview mode does something like this, so that would be helpful to start with. Then either way, it would be nice to be able to drag the column divisions left and right to manually customize the width of each column in the editor. But really any mechanism to allow me to make that first column narrower and the other columns wider would be fine.

    Describe alternatives you've considered Not aware of any.

    opened by gwhitney 0
  • [BUG] Center align

    [BUG] Center align

    Describe the bug When I open a manually created table with center alignment, it resets in the editor

    Expected behavior I want alignment not to reset

    Screenshots 01 02

    Desktop:

    • OS: Linux Mint
    • Version: 18
    opened by SunnydeGross 1
  • [Feature Request] HotKeys for Row/Column Addition/Deletion

    [Feature Request] HotKeys for Row/Column Addition/Deletion

    Hi @ganesshkumar,

    Thanks for the amazing plugin. And the ease of editing is amazing.

    Would it be possible to add hotkeys for addition of rows or columns or deletion as well. As like in spreadsheet application. So editing the table would be easier, than to depend on the ellipsis options with a mouse click.

    Thanks.

    enhancement 
    opened by mhdatzh 1
Releases(0.3.1)
Owner
Ganessh Kumar
Software Engineer @microsoft
Ganessh Kumar
A JQuery plugin to create AJAX based CRUD tables.

What is jTable http://www.jtable.org jTable is a jQuery plugin used to create AJAX based CRUD tables without coding HTML or Javascript. It has several

Volosoft 1.1k Dec 21, 2022
Live searching/filtering for HTML tables in a jQuery plugin

jQuery Filter Table Plugin This plugin will add a search filter to tables. When typing in the filter, any rows that do not contain the filter will be

Sunny Walker 175 Oct 29, 2022
jQuery plugin to make HTML tables responsive

FooTable V3 This is a complete re-write of the plugin. There is no upgrade path from V2 to V3 at present as the options and the way the code is writte

FooPlugins 2.1k Dec 19, 2022
jQuery plugin for stacking tables on small screens

stacktable.js The Responsive Tables jQuery plugin for stacking tables on small screens. The purpose of stacktable.js is to give you an easy way of con

John Polacek 1k Nov 30, 2022
jQuery grid plugin

jqGrid jQuery grid plugin jqGrid is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the w

Tony Tomov 2.8k Jan 7, 2023
jQuery plugin to show a tree structure in a table

jQuery treetable jQuery treetable is a plugin for jQuery, the 'Write Less, Do More, JavaScript Library'. With this plugin you can display a tree in an

Ludo van den Boom 734 Nov 14, 2022
Lightweight Grid jQuery Plugin

jsGrid Lightweight Grid jQuery Plugin Project site js-grid.com jsGrid is a lightweight client-side data grid control based on jQuery. It supports basi

Artem Tabalin 1.5k Dec 31, 2022
A stupidly small and simple jQuery table sorter plugin

Stupid jQuery Table Sort This is a stupid jQuery table sorting plugin. Nothing fancy, nothing really impressive. Overall, stupidly simple. Requires jQ

Joseph McCullough 708 Dec 26, 2022
jQuery plugin to export a html table to JSON, XML, CSV, TSV, TXT, SQL, Word, Excel, PNG and PDF

tableExport.jquery.plugin Export HTML Table to CSV DOC JSON PDF PNG SQL TSV TXT XLS (Excel 2000 HTML format) XLSX (Excel 2007 Office Open XML format)

null 918 Dec 29, 2022
An Obsidian plugin to provide an editor for Markdown tables

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.

Ganessh Kumar 112 Dec 31, 2022
Obsidian-dataview-table-filter-menu - Dynamically created filter menu for dataview tables in obsidian

Dataview table Filter Menu for Obsidian Dynamically created filter menu for data

shiro 17 Sep 24, 2022
A plugin for the Obsidian markdown note application, adding functionality to render markdown documents with multiple columns of text.

Multi-Column Markdown Take your boring markdown document and add some columns to it! With Multi Column Markdown rather than limiting your document lay

Cameron Robinson 91 Jan 2, 2023
An obsidian plugin for uploading local images embedded in markdown to remote store and export markdown for publishing to static site.

Obsidian Publish This plugin cloud upload all local images embedded in markdown to specified remote image store (support imgur only, currently) and ex

Addo.Zhang 7 Dec 13, 2022
Shrinks any large data tables into compact and responsive tables

jquery.table-shrinker A Jquery plugin to make HTML Table responsive across all devices, the right way! Demo Click here to see the demo, remember to re

null 29 Sep 11, 2022
Grupprojekt för kurserna 'Javascript med Ramverk' och 'Agil Utveckling'

JavaScript-med-Ramverk-Laboration-3 Grupprojektet för kurserna Javascript med Ramverk och Agil Utveckling. Utvecklingsguide För information om hur utv

Svante Jonsson IT-Högskolan 3 May 18, 2022
Hemsida för personer i Sverige som kan och vill erbjuda boende till människor på flykt

Getting Started with Create React App This project was bootstrapped with Create React App. Available Scripts In the project directory, you can run: np

null 4 May 3, 2022
Kurs-repo för kursen Webbserver och Databaser

Webbserver och databaser This repository is meant for CME students to access exercises and codealongs that happen throughout the course. I hope you wi

null 14 Jan 3, 2023
A plugin for Obsidian (https://obsidian.md) that adds a button to its search view for copying the Obsidian search URL.

Copy Search URL This plugin adds a button to Obsidian's search view. Clicking it will copy the Obsidian URL for the current search to the clipboard. T

Carlo Zottmann 6 Dec 26, 2022
Markdown Plus is a markdown editor with extra features

Markdown Plus Markdown Plus ("M+" or "mdp" for short) is a markdown editor with extra features. Online demo: mdp.tylingsoft.com Apps We currently don'

null 2.1k Dec 29, 2022