An Obsidian plugin to paste Excel tables as Markdown tables in Obsidian editor.

Overview

Obsidian Excel to Markdown Table

Tag 0.1.0

An Obsidian plugin to paste Excel tables as Markdown tables in Obsidian editor.

Demo

You can paste the copied Excel date from the clipboard by using either

  1. Hotkey - Crtl/Cmd + Shift + V or
  2. Command Palette: Ctrl/Cmd + P > Excel to Markdown command

Obsidian Excel to Markdown Table

Installation

From Obsidian

  1. Open Settings > Third-party plugin
  2. Make sure Safe mode is off
  3. Click Browse community plugins
  4. Search for this plugin
  5. Click Install
  6. Once installed, enable this plugin and close the community plugins window and the plugin is ready to use.

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.

License

MIT

Acknowledgements

Comments
  • [BUG] Prompt: Fail to load, on IOS

    [BUG] Prompt: Fail to load, on IOS

    Describe the bug Plugin Can't load properly on IOS, and prompt: Fail to load xxx, when start Obsidian.

    To Reproduce Steps to reproduce the behavior:

    1. install plugin on IOS
    2. enable plugin
    3. See error: Fail to load xxx

    Expected behavior Load successfully without warning.

    Screenshots image

    Desktop (please complete the following information):

    • OS: Windows
    • Version v1.0.0

    Smartphone (please complete the following information):

    • Device: iPhone12
    • OS: iOS16.0.2
    • Version v1.4.0
    opened by aooaa 5
  • [Bug Report] Bypass plugin

    [Bug Report] Bypass plugin

    Is your feature request related to a problem? Please describe. I need to be able to paste some text verbatim that happens to contain tabs. Unfortunately, this plugin assumes that this is a table.

    Describe the solution you'd like A way to paste as if obsidian-excel-to-markdown-table were disabled

    Describe alternatives you've considered I've tried to "type" text using BetterTouchTool. I've tried option+shift+cmd to paste without formatting. Neither worked.

    bug 
    opened by huyz 5
  • [BUG] Pipe characters in excel cells are not escaped when pasted into Obsidian.

    [BUG] Pipe characters in excel cells are not escaped when pasted into Obsidian.

    Describe the bug Pipe | characters in excel cells are not escaped when pasted into Obsidian.

    To Reproduce Steps to reproduce the behavior:

    1. Create table in excel and enter a pipe | character somewhere inside the cell image
    2. Copy and paste the table into Obsidian
    3. Source code looks like
    | Column 1        | Column2 |
    |-----------------|---------|
    | Value1a|Value1b | Value2  |
    

    Expected behavior The pipe character should be escaped.

    | Column 1         | Column2 |
    |------------------|---------|
    | Value1a\|Value1b | Value2  |
    

    Desktop (please complete the following information):

    • OS: Windows
    • Version 10

    Additional context According to https://www.markdownguide.org/extended-syntax/#escaping-pipe-characters-in-tables

    You can display a pipe (|) character in a table by using its HTML character code (&#124;).

    But it also doesn't specifically say you should not use the \ escape character which is a valid escape code and using \| does seem to render the table correctly which would be my preferred method as it's easier to remember. Perhaps this should be a configurable user option in case other users have a different preference.

    opened by reticulator 2
  • Still awaiting Obsidian proper LP rendering

    Still awaiting Obsidian proper LP rendering

    This is a great plug-in and am very eager to use it, but ……… Obsidian does not render tables in Live Preview as in Reading mode à la Typora. I am using Typora only for notes with tables because the rendering is fantastic.

    Unfortunately, as WhiteNoise stated 4 weeks ago, it won't happen in the short term.

    opened by DutchPete 2
  • [Feature Request] Paste cells with hyperlinks from Excel

    [Feature Request] Paste cells with hyperlinks from Excel

    **Is your feature request related to a problem? Please describe. ** When I copy and copy a row of cells which have hyperlinks but also a "friendly name" as Microsoft calls it ("link text") and paste it in Obsidian, it automatically creates a link in the desired form: [link text](https://example.com).

    When I paste the table using your plugin, it only pastes the plain text and loses the hyperlink.

    Describe the solution you'd like It would be nice to have an option to paste tables from Excel to Obsidian and keep the hyperlinks.

    This online converter does this exactly like described: https://tabletomarkdown.com/convert-spreadsheet-to-markdown/

    opened by m0lt 0
  • [BUG] If multiple line exists in one cell, this plugin parses quirkly.

    [BUG] If multiple line exists in one cell, this plugin parses quirkly.

    Describe the bug

    If multiple line exists in one cell, this plugin parses quirkly and generate wrong table.

    | # | Name | Method | Notes | |----------------------------------------------|------------------|-----------------------------------|------------------------------------------------| | 1 | Pasting | Ctrl/Cmd + V | will paste only table with two or more columns | | 2 | Hotkey | Crtl/Cmd + Alt + V | will paste table with one column as well | | reassign the Hotkey from settings if needed | | | | | 3 | Command Palette | Ctrl/Cmd + P > Excel to Markdown | will paste table with one column as well |

    To Reproduce

    Steps to reproduce the behavior:

    Tyy copy & pasting table from https://github.com/ganesshkumar/obsidian-excel-to-markdown-table#demo into obsidian.

    Expected behavior

    A clear and concise description of what you expected to happen.

    | # | Name | Method | Notes | |---------------------------------------------|------------------|-----------------------------------|------------------------------------------------| | 1 | Pasting | Ctrl/Cmd + V | will paste only table with two or more columns | | 2 | Hotkey | Crtl/Cmd + Alt + V | will paste table with one column as well
    reassign the Hotkey from settings if needed | | 3 | Command Palette | Ctrl/Cmd + P > Excel to Markdown | will paste table with one column as well |

    Desktop:

    • OS: Windows 10
    • Version: 10.0.19044 build 19044
    opened by dewcked 0
  • support html past (e.g., jupyter notebook, QUIP)

    support html past (e.g., jupyter notebook, QUIP)

    Hi Ganessh, Really appreciate it that you have created this awesome plugin. Personally, I work with some tools (e.g., jupyter notebook, QUIP) that doesn't have very good raw text when copying tables, so to get proper table content, I need to refer to the html paste. Here is a draft diff that solves my problem and I hope is can also help other who have similar issues. Best Regards

    opened by xychang 1
  • [BUG] Fails to paste table with blank cells in header row

    [BUG] Fails to paste table with blank cells in header row

    Thank-you for creating this plugin!

    Describe the bug The plugin fails to insert excel tables which have blank cells. I have manage to work around this by putting spaces into my excel table which are supposed to be blank. Granted, this is not legitimate markdown, as header rows cannot be blank. The real problem is that there is no warning of the failure to paste, so I was left wondering whether the plugin was working or not for 30 mins. Perhaps empty cells could be replaced with a space?

    To Reproduce Try and paste the following table where cell A1 is completely empty. image

    Plugin version: version 0.4.0

    opened by NickN-Eng 0
  • Marking entries as bold [Feature Request]

    Marking entries as bold [Feature Request]

    Is your feature request related to a problem? Please describe. I often mark entries in bold in google sheet to show sub headings, and make the lines stand out. So when I copy the table from google sheet to markdown using the plugin, only the first line is in bold. Rest of the bold entries are lost and I have to resort to adding the double stars manually. As the sheet keeps changing over time, this becomes a repetitive process.

    Describe the solution you'd like When I copy the table from google sheet to obsidian. I would like the entries in bold (google sheet entries) to be marked in bold in markdown as well.

    Describe alternatives you've considered The alternative is to do it manually and that is tedious.

    opened by orthodoc 0
Releases(v0.4.0)
Owner
Ganessh Kumar
Software Engineer @microsoft
Ganessh Kumar
Mind Mapping to excel, or excel to .xmind file

Mind Mapping To Excel Project setup Prepare project npm install 1、Fetch data and generate excel Open the Mind Mapping like this Process On Mind Mappi

xuzelin995 3 May 5, 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
A markdown-it plugin that process images through the eleventy-img plugin. Can be used in any projects that uses markdown-it.

markdown-it-eleventy-img A markdown-it plugin that process images through the eleventy-img plugin. Can be used in any projects that use markdown-it. F

null 25 Dec 20, 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 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
An Obsidian Plugin that allows to export tables from a pane in reading mode to CSV files.

Obsidian Plugin "Table to CSV Exporter" This is my very first attempt in writing a plugin for Obsidian. I didn't even know TypeScript before (but Java

Stefan Wolfrum 26 Dec 27, 2022
NoPrint.js - Disable Print, Screenshot, Copy & Paste in HTML by JavaScript.

NoPrint.js Disable Print, Screenshot, Copy & Paste in HTML by JavaScript. NoPrint.js is a small and neat open source JS library that disables print, s

null 33 Dec 26, 2022
JSON Visio is data visualization tool for your json data which seamlessly illustrates your data on graphs without having to restructure anything, paste directly or import file.

JSON Visio is data visualization tool for your json data which seamlessly illustrates your data on graphs without having to restructure anything, paste directly or import file.

Aykut Saraç 20.6k Jan 4, 2023
A collection of scripts to build offline documentation for your favourite frameworks/libraries. Simply search, copy/paste the commands and enjoy.

Offline-docs A collection of scripts to build offline documentation for your favourite frameworks/libraries. Simply search, copy/paste the commands an

Naveen Namani 37 Dec 24, 2022
Copy/paste detecting GitHub Action for programming source code (jscpd)

dry-code Copy/paste detecting GitHub Action for programming source code with jscpd Action inputs Action input Description Default Value Required optio

null 5 Dec 14, 2022
Types generator will help user to create TS types from JSON. Just paste your single object JSON the Types generator will auto-generate the interfaces for you. You can give a name for the root object

Types generator Types generator is a utility tool that will help User to create TS Interfaces from JSON. All you have to do is paste your single objec

Vineeth.TR 16 Dec 6, 2022
VSCode extension to paste text as a string array

VSCode extension to paste text as a string array. This is useful when copying command line into launch.json args

Shady Boukhary 4 Dec 28, 2022
Excel-like Experience for Web Apps

DataGridXL 2 Excel-like Experience for Web Apps Built in JavaScript ES6. Made in the 2020s. ✅ Works with JSON ✅ Works with CSV ✅ Works with SQL ✅ Work

DataGridXL 381 Jan 2, 2023
FortuneSheet is an online spreedsheet component library that provides out-of-the-box features just like Excel

FortuneSheet FortuneSheet is an online spreedsheet component library that provides out-of-the-box features just like Excel English | 简体中文 Purpose The

Suzhou Ruilisi Technology Co., Ltd 1.6k Jan 3, 2023
Suplemento para Excel para auxiliar na elaboração de cálculos judiciais.

Getting Started with Create React App and Fluent UI This is a Create React App based repo that comes with Fluent UI pre-installed! Available Scripts I

null 4 Jul 6, 2022
Import flow for Excel (.xlsx) and CSV file with automated column matching and validation.

RSI react-spreadsheet-import ⚡️ A component used for importing XLS / XLSX / CSV documents built with Chakra UI. Import flow combines: ?? Uploader ⚙️ P

Ugnis 123 Dec 24, 2022
🌸 A cli can automatically generate files from Excel files.

unxlsx A cli can automatically generate files from Excel files. Why We often need to export some information from XLSX to generate our files, such as

Frozen FIsh 24 Aug 22, 2022