advanced-tables-obsidian icon indicating copy to clipboard operation
advanced-tables-obsidian copied to clipboard

Import CSV to Markdown

Open ddetton opened this issue 3 years ago • 7 comments

Most of us have a lot of spreadsheet files we have accumulated over the years. Almost all spreadsheet programs can export to CSV. If the Advanced Table plug in had the ability to import a CSV into markdown, it would really streamline the process of bringing more of our legacy data into Obsidian. deathau has a CSV import plug in. Maybe you could look at merging the two plug ins.

ddetton avatar Apr 12 '21 19:04 ddetton

csv2md might help?

chrisgrieser avatar Jul 17 '21 14:07 chrisgrieser

There is an editor-paste event which could be used to support automatically reformatting content into a table when pasted. It would likely make sense to only activate this functionality if the cursor is already in a table. This means if you were starting from scratch you would need to create an empty table and then paste into it.

Just a thought. Not sure it's the right user experience...

tgrosinger avatar Nov 25 '21 21:11 tgrosinger

Pasting a csv to md converted table into Obsidian with this plugin enabled seemed to break the plugins correct display of the table. Seems to only display correctly if it's been typed in. Is this correct? Update: OK, using right-click and paste as plain text works. Confusing as I had copied from VS Code and would've thought it was plain text already.

ghost avatar Nov 29 '21 06:11 ghost

Pasting a csv to md converted table into Obsidian with this plugin enabled seemed to break the plugins correct display of the table. Seems to only display correctly if it's been typed in. Is this correct? Update: OK, using right-click and paste as plain text works. Confusing as I had copied from VS Code and would've thought it was plain text already.

I had this but pasting as 'paste as plain text' works without breaking the table

j-r-e-i-d avatar Jan 11 '22 04:01 j-r-e-i-d

Most of us have a lot of spreadsheet files we have accumulated over the years... it would really streamline the process of bringing more of our legacy data into Obsidian.

I'm curious as to the use case/benefits of putting tabular data into obsidian, it would be great if you can elaborate on this @ddetton. Sorry for the side point in the discussion but I'm a new user of obsidian and am learning where it would be most useful :)

ppreshant avatar Nov 11 '22 05:11 ppreshant

Most of us have a lot of spreadsheet files we have accumulated over the years... it would really streamline the process of bringing more of our legacy data into Obsidian.

I'm curious as to the use case/benefits of putting tabular data into obsidian, it would be great if you can elaborate on this @ddetton. Sorry for the side point in the discussion but I'm a new user of obsidian and am learning where it would be most useful :)

It's just about getting our data out of proprietary formats. We could always cut and paste but having a feature where we could export out of the spreadsheet and into Obsidian makes it very streamlined. Obviously, this would not be useful for an active spreadsheet with formulas. It's more for cases where the spreadsheet was used to store data.

ddetton avatar Nov 11 '22 07:11 ddetton

That makes sense, thank you.

It's just about getting our data out of proprietary formats. We could always cut and paste but having a feature where we could export out of the spreadsheet and into Obsidian makes it very streamlined. Obviously, this would not be useful for an active spreadsheet with formulas. It's more for cases where the spreadsheet was used to store data.

ppreshant avatar Nov 11 '22 08:11 ppreshant