Forum Discussion
I need Help with the web import in excel
Hallo all i need help and dont know wath to do.
If i Import somthing from the in Excel i kan not use it. I can not add the Numbers ore do anithing witz it i have allways the same bug. #value! in germen #wert!
Do you know wath i do wrang ?
I Just want to add the exchanges date and make a small portfolio. but i can not use the date and make +100 ore *2 a alway geht a bug.
pleas help me.
Thx and best regards
11 Replies
Hi Manuel,
I guess, you imported the data from a text file or a CSV file? It looks like that the values have been imported as text ($ 123...). Therefore, when adding the values by using a formula, you get an error. So, please transform the values from text to values.
An easy way to import data from text is to use the Get & Transform features (Daten abrufen und transformieren) from your Excel version. For example, in the Data tab, click on From Text/CSV (Daten / Aus Text/CSV) and select your text file or CSV file. Then, a dialog opens which looks like the following sample screenshot in German:
In this window, click on Edit (Bearbeiten) for opening the query editor (Abfrageeditor). Now you have a lot of options to transform your data, for example changing the data format and so on.
Once you are done, click on Close & Load (Schließen & laden) to import the data on a sheet. And then, you can perform your calculations.
Best,
Mourad
Hallo Mourad, thanks for helping me,
Ne is it not a TEXT/CSV Date i want to Import the Live Price form https://www.worldcoinindex.com/
to Excel, and make a Poertfolio so i can see how much i have earn with my BTC Coins.
I dont want to put everytime the Prive munuell in Excel
Best regards & thx
Manuel
