Page 1 of 1

Can Wandora extract data from excel sheet? how?

PostPosted: Wed Nov 11, 2015 6:06 pm
by malihaz
Can Wandora extract data from excel sheet? how?
I have 1000+ records in excel sheeting with different columns and i want to add only two columns and their values as Topics in wandora.
Any help?

Re: Can Wandora extract data from excel sheet? how?

PostPosted: Thu Nov 12, 2015 8:59 pm
by akivela
Hello

Sure you can extract data from Excel sheet. Wandora features several extractors that take Excel files as input and create topics and associations out of Excel data. Documentation is at [1].

Second option is to export a CSV file out of Excel and use Wandora's Simple CSV association extractor [2].

Third option is to copy Excel data into a text file via system clipboard and use Wandora's Adjacency List Import [3] or Incidence Matrix Import [4].

And you can always just paste the data into Wandora. Look at the submenu options under Paste Also... And you may find Sketch Grid [5] useful.

Depending on your data and specific structures in the data, it may be necessary to import the data in smaller chuncks.

Kind Regards,
Aki / Wandora Team

[1] http://wandora.org/wiki/Excel_extractors
[2] http://wandora.org/wiki/Simple_CSV_asso ... _extractor
[3] http://wandora.org/wiki/Adjacency_list_import
[4] http://wandora.org/wiki/Incidence_matrix_import
[5] http://wandora.org/wiki/Sketch_grid