Jump to content

Importing Climate Data into PVSol


Recommended Posts

Hi Martin,

I am not sure what I am doing wrong. I am having a challenge  uploading my last two (2) measured climate data files into PVSol. I have converted the files into .DAT  format, as per the instructions but I keep getting "Conversion failed, Formatting error" message  whenever I try to upload same into PVSol. 

I have attached the two (2) files for your kind review and support. Could you please convert them into .DAT file for me.  I am  using  PVSOl Premium 2019 (R10)



MLow Values.xlsx MHigh Values.xlsx

Link to comment
Share on other sites

Hi Dongash,

I guess it is line 3, as mentioned in our previous conversation, and the whitespace (space) right after the column name "Ta". Copy the values from your Excel sheet to a text file, remove the (invisible) tabs in line 3 and at the end of lines 1 and 2, remoe also the whitespace after Ta in line 4 (only the space, not the tab), then save as *.dat. That should work.


This doesn't import.


This works.

Hope that helps, kind regards,


Link to comment
Share on other sites

  • 9 months later...

Hi Nasr,

1. In this case it is https://notepad-plus-plus.org/, a free editor which can show "hidden characters" like SPACE, TAB, NEWLINE and so on. View > Show Symbol > ...

2. TAB is a special character https://en.wikipedia.org/wiki/Tab_key#Tab_characters

So in this case the \t is represented as string:


and here as character:


Best regards,


  • Like 1
Link to comment
Share on other sites

  • 2 months later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...