Skip to main content

Hi,


I’m very familiar with using the org chart tool in Lucid Chart to import CSV data and add data to shapes on an org chart. I’d like to do something similar with a bunch of freeform cards. I’d like to import a spreadsheet of 100 rows with 5-10 columns and have it generate 100 cards with the data from most of the columns on the cards. I’ve seen the ability to import data to a lucid chart but am unsure how to generate the cards.  I need them to be in a freeform format where I can freely organize them similar to how you would do a sticky note excercise.

 

Thanks!

Hi @Jshood

Thank you for the post! You can import data into a document by following these steps: 

  1. Click data-panel-icon-in-lucidchart.png the Data Panel icon in the left bar.
  2. Click Link Data.
  3. In the window that appears, click Import Your Data.
  4. Select the file type (Google Sheets, Excel, or CSV) that you would like to import, or select to choose a file that you have already uploaded to Lucidchart. 
  5. Select a file

Once you have uploaded data in the Data Panel you can assign it to an object by following the steps in this Help Center article. Please let me know if you have any other questions!


An excellent question Jshood.  This is excactly what I am trying to do.

 

I am not sure the response is complete though.  Linking excel data seems simple.  But being able to perform functionality like you can with the org chart tool is not so simple.  I am not sure it is possible and I find the help center article very generic and high level.

 

I want to define a template card (apply some basic formatting to make it look presentable) and then have this card used to display all the rows from my xls.Then I want to be able to dynamically group the data based on values of the data.

Is this possible.  Do you have examples of the results?

 

Thanks


Hi ​@AndrewL

Thank you for the reply! Are you wanting to link all your data to the same card? Would you be interested in something like smart containers to group your imported data?


Hi Kelsey, thanks for the quick response.

 

i have an xls of business processes. One on each row. Say 30 rows.

i would like to link to lucid and have 30 cards. Then be able to group, filter etc to show subsets of cards during workshops.

 

 Does this make sense?


Hi ​@AndrewL

Yes that makes sense. I think what might help you achieve this is cards in Lucidspark. You can import your data into cards from a CSV file, and then you can using the tag feature to sort these cards. 


Reply