search

afterschoolstudio / Depot

Structured data editor built inside VS Code
Apache License 2.0
186 stars 19 forks source link

is there a way to import data into sheets? #29

Open fredzannarbor opened 3 years ago

fredzannarbor commented 3 years ago

I would like to import a csv file and use it as the basis for a Depot document.

kkukshtel commented 3 years ago

Hey @fredzannarbor ! Nothing yet to be able to do this but it is definitely possible. The easiest way in the meantime would be to create a depot file with the structure you want for your csv file, and then use a small commandline tool to read in your csv file and spit out a JSON tree that represents that data as Depot's "Lines". Then merge those two files together.

Worth noting though that Depot won't be able to save out to a CSV after its imported though (not now or likely ever) just because of the way the data Depot stores is represented.