Forum Discussion
I need Help with the web import in excel
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
Hello,
the Get & Transform features lets you import data from websites too. I attached a sample, where I did some formattings in the query editor. You may do additional formattings, e.g. replace M and B by their meanings. Note: I did this in Excel German, so the steps are in German.
Best,
Mourad
Ich bin aus Österreich, also können wir auch Deutsch schreiben, ich frage mich wie du das gemacht ?
Ich hab hab es selbst nicht hinbekommen, aber die Excel datei die du mir zugeschickt hast funktionier nice.
Ich würde gern wissen wie das geht? Du hast mir die Top 100 Coins Kurse geschickt, ich brauch aber die top 200, also 100 weitere.
Kannst du mir bitte veraten wie du das gemacht hast ?
Danke
Manuel
