Would be nice to be able to import any tabular data, with option to choose how it’s interpreted by Anytype (which columns go to each Relation/field etc.).
Definitely a nice-to-have, but would save a lot of time for people who (like me) has dozens of spreadsheets with hundreds of items on them.
Bumping this. I’d like to be able to test Anytype with my existing “real” data. Doing tests by manually entering dummy data is very time consuming and there’s a limit to how much insight I can get from it…
I guess there’s a way to import from Notion, but I don’t use that software.
Will these options be worked on also?
If I am understanding this correctly, there are general import options.
I know it will take people to work on the code to create import options but if these are general ones, does that mean they will work for any app that exports in these formats?
+1
I would like to be able to import a spreadsheet into a simple table or even better into a set. It would also be nice if anytype could monitor the spreadsheet file (ie cvs) and have the table or set change as information in source spreadsheet is updated.
ask if we want to put them in a existing collection
ask if we want to create object as a existing type
in this case, if this type already has a property with the same name of the columns from CSV : use this relation!
REAL WORLD USE CASES
CSV import is still very basic, and at the moment it’s best not to use it at all.
(I tried…)
Case study: I’m importing a database of bottles, with specific data (name, origin, characteristics, etc.).
The aim is to have an equivalent collection in Anytype.
If I import my CSV :
it will create page objects: rarely the right choice for CSV!
the relationships will all be textual and, as you can’t change the type, you’ll have to throw them out.
Conclusion: delete everything.
Now, if I create a “bottle” type in Anytype, with relations that have the same name, when I import the CSV I’ll have to tell Anytype to save the lines as “bottles”.
Ideally, I’d even like to be able to map the columns of my CSV to Anytype relations, but that’s more complex.
RECOMMENDED ALTERNATIVES
Propose to map CSV columns to AT relation
Or let the user change the type of relation
My vote is especially for @Shampra 's comment ; I don’t mind converting Excel or Google Sheets to CSV before importing them into AnyType, but not being able to map imported data to the relations defined in existing types makes the “CSV import” feature conterproductive for my usecases.
@Shampra Sorry to bother you since your FR actually got merged into this one, but could you re-create this FR as a separate one again?
I would like to mark this one as implemented since csv import has been added over a year ago.