+1Hello to all,
i have been using lucidchart for a while, but this is the 1st time i want to import data from an Excel file and NOT and csv, to create an ERD diagram that i can upload to an Database later on.
I have done already most of the videos and i cant find the format in how should i put the excel file that Lucidchart can draw automatically the ERD diagram, can someone help me on this?
thanks
Lisbeth
Best answer by Amelia W
Hi
However, in the meantime, you can write a custom query and run it in your database if you'd like. If you are able to generate an output file in the format our ERD importer expects you should be able to import successfully. I've created an example output file from a PostGreSQL import here for reference, that is the format our importer will need your file to be in.
Hope this helps! Please let me know if you have any further questions!
+24Hi
Lucidchart primarily supports importing CSV and text files for this functionality and not with Excel is what i learnt,
Meantime - We also look forward to hearing from other community members and associates, who may have alternative suggestions that could better address your requirements.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
+9Hi
However, in the meantime, you can write a custom query and run it in your database if you'd like. If you are able to generate an output file in the format our ERD importer expects you should be able to import successfully. I've created an example output file from a PostGreSQL import here for reference, that is the format our importer will need your file to be in.
Hope this helps! Please let me know if you have any further questions!
+1Is this still not available?
Your public facing marketing screenshots shows someone importing ERD from Excel, but this appears to not actually be possible? https://lucid.co/diagram/erd
+13Hi
My apologies for any confusion here. I’m checking with our product team to verify whether this is supported, and will get back to you asap!
In the meantime, one possibility while importing your file is selecting Other from the dropdown shown below, and then uploading your file as a CSV, TSV, or TXT file.
A Lucid or airfocus account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under 18. You will be redirected to the Lucid or airfocus app to log in.
A Lucid or airfocus account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under 18. You will be redirected to the Lucid or airfocus app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Your privacy choices
