Obsidian Excel Plugin：easy to handle markdown table

Share & showcase
1

The way to insert tables in Markdown was too cumbersome, and one day I thought it would be really cool if I could replace tables with spreadsheets, and that’s what I wanted to solve with this plugin

GitHub: https://github.com/ljcoder2015/obsidian-excel

Feature

create sheet file

create

import/export xlsx file

If you are using Microsoft Office 365 to create xlsx files, you need to import the display.

import

embed link to markdown

link

copy selected cells to HTML

html

14 Likes
2

cool！

3

Great !!!

4

UI is not adaptive to dark theme. It would be great if we can do that. Is there some css to make the UI adaptive to dark theme ?

2 Likes
5

I will consider it in the future

6

This is an excellent idea. But I am not seeing the functionality to import or export in dark or light themes.

7

Very interesting, thanks.
I´m having an issue when trying to embed into a note, the table appears with incomplete or no data. Sometimes it doesn´t render at all.

8

This is great work! I noticed one bug: upon importing a large sheet with over 300 lines, I can only see the first 100 lines.

The other lines are there (i know this as formulae in the first 100 lines refer to the invisible lines) but I cannot see them at all, they are hidden.

I also noticed it doesn’t import colour highlighting in an XLSL doc, so that’s a feature request

9

Just an update, the bug above is now squashed as of 1.3.21, and the table with over 100 rows imports showing all the columns and rows now,

There are also default settings for numbers of rows and columns, excellent quick work, thank you!

1 Like
10

Thanks for the plugin! I would like to import xlsx from google drive and create a income vs expenses page and have it display visually with tracker plugin. I would then like to have a budget session using calculations from the spreadsheet. Does anyone knows if this is possible?

many thanks

11

I’m not sure you’ll see this but I’ve been using your plugin and I really enjoy it! I am running into an issue where I try and do an IF formula. =IF(G4>B13,G4-B13,0) but it doesn’t do anything. It actually blocks me from interacting with anything unless I backspace it out, multiple things on my sheet also seem to go invisible when this happens. If there’s anything you could do to fix this, I would appreciate it!

14

This is great. I would keep improving this if I were you.

Things I missed and I think can add inmense value to the plugin:

  1. Use of functions like =A1+B1
  2. Import outer Excel spreadsheets keeping format: colors, font styles, sizes, etc.
  3. Be able to link the Obsidian Excel spreadsheet/note with a new one thanks to something like a button to click and navigate
  4. Keep format whenever embedding data through ![[file-folder/file-name#sheet-name|sri-sci:eri-eci{html}]]
  5. Keep formulas whenever importing new xlsx outer files

Hope this ideas help to inspire and to get a even better work!
Thank you

16

If only I could link the Obsidian MD file in Excel

17

Thanks for the plugin! Just one question, can we swap lines within a cell? I struggled to do it using the normal “up/enter” as i normally do in excel… and I struggled to add new hotkeys too (don’t know why it only allow me to add hotkeys for “creating new excel file”.