+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!
A Lucid 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 age 18. You will be redirected to the Lucid app to log in.
A Lucid 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 age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
