Can Wandora extract data from excel sheet? how?

Forum is for miscellaneous user help requests.

Can Wandora extract data from excel sheet? how?

Postby malihaz » Wed Nov 11, 2015 6:06 pm

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?
malihaz
 
Posts: 3
Joined: Tue Mar 31, 2015 6:15 pm

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

Postby akivela » Thu Nov 12, 2015 8:59 pm

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
akivela
Site Admin
 
Posts: 256
Joined: Tue Sep 18, 2007 10:20 am
Location: Helsinki, Finland


Return to How to... and problems

Who is online

Users browsing this forum: No registered users and 1 guest