how to import site coordinates from Excel Table

[Zack]

In the network Module, How can I import site lists from an Excel table?

[Linas Spraunius]

Export your sites from Excel to text file. Then select "Site list" from Network module, then "Import/Site Text File". I'm not sure about result :) Probably you have to enter call sign and other attributes to the Excel file first.

[Zack]

Thank you Linas. I have tried. But it doesn't work.Maybe there is something wrong with the field delimiter character.
Do you think pathloss can import coordinates directly from excel files?
Happy New Year!!!

[Linas Spraunius]

I think Pathloss can't import directly from Excel.
In Pathloss Manual (Network section, 12 page)is written how to import from text file. If you have no call sign, station name, elevation, etc. leave it blank in import dialog box. You should set correct delimiter.
Your Excel file save as CSV text file. Then choose "import/set text file" from site list. Set options. Delimiter should be ";". Press Import. Select file type: *.csv. It should work. I tested it today.

[Vic Rhys-Williams]

Zack;
Importing from excel is quite easy if you use the save as a CSV file. It is important to delete information that you do not require initially from the excel file. What I generally do is save the file in a work file and delete the coloums not required. Then save the file as a CSV, a further edit is then required of the CSV file in Word usually to add a further comma to the line ends, and check that the comma delimiting is accurate. This file will then directly import to Pathloss IV.

Cheers and Happy New Year.

Vic R-W

[Zack]

Thank you Linas and Vic R-W.
I will try it.

[Zack]

Thanks again, Linas and Vic R-W.
It works.

Best Wishes,
Zack

[Hossam_El_Meadawy]

As I understand we will be able to import and export from Excel in the comming PL version.
:D