I've just exported the earnings report for September as a csv document - and then opened it in Excel and am absolutely dismayed to find that all the income reported is formatted as TEXT!
Bottom Line: this means it is completely useless for manipulation when imported into Excel because the $ are not numbers - they have had an $ artificially inserted as a prefix in front of the number which nullifies the value of this data as numerical data.
Could you PLEASE:
* put the denomination for the value at the top of the column (i.e. incorporate $ in all relevant column headings NOT as prefix)
* RENDER ALL EARNINGS AS NUMERICAL VALUES and not text (i.e. remove the $ which currently prefaces all numbers)
This would then allow calculations (e.g. averages, percentages etc) with ease when the data is exported to a spreadsheet
Thank you for your consideration.
A csv file is just a text file. When you import it to Excel you can choose to import that part as numbers. Or, you can select the column and change the format to numbers.
To remove the $ just do a search/replace. Yes this bit is annoying, I can see that.
which is why it is a lot simpler if the TEXT that is entered is just numbers.......
One person at the HQ end enters as numbers as opposed to all hubbers who download into excel having to convert the text to numbers - assuming they know how to do this.
It's just an awful lot simpler to make it simple in the first place by making numbers just numbers and include a $ sign as a column heading
I upload HP's CSVs into Google Spreadsheets (now in Google Drive) and it always treats numerical entries as numbers automatically without me having to do anything. In GS you can averages, sorting, etc, so some people might prefer to use it instead of Excel.
GS also has the option of letting you download the sheets as .xlsx files, which perhaps you prefer to work with, and it preserves the number formatting you need.
but it's not a numerical entry - it's text!
I prefer to download csvs direct to Excel which is what I've been doing for the last eight years with Squidoo.
I then change them to Excel files (because I've used Excel for some 20 odd years)
However I haven't had the problem before of being unable to manipulate numerical data because it's been represented as text rather than as numbers
For the record, csv files are comma separated files. They are capable of recording both numerical and text data in plain format and it's very easy to import them into Excel so long as text is text and numbers are numbers.
I can't think of a good reason why numbers of dollars should not be represented as numbers in a csv file - given they will have started life as numbers!
That file format is text, and can only be text, although excel can sometimes figure out it is meant to be a number. Just select the columns in the excel spreadsheet -- go to cell format -- select numeral. That leads it to disregard the dollar sign. If they remove it someone will be here asking what units it in.
You think so? Even if they put a $dollar sign at the top of each column?
You don't think the calibre of person who writes hubs can cope with $ signs at the top of columns - which is a perfectly normal and routine way of representing cash?
How difficult is it to input numbers only?
Re the file format issue csv can be text or numbers - it is NOT a file format which ONLY deals in text. I also guarantee that these numbers started life as numbers!
by Katherine Tyrrell2 years ago
I'm wondering if the HubPages Team are aware that earnings data on Amazon sales exported to a csv file is much less useful than it could be because the $ notation is a prefix to each amount rather than topping the...
by Jonathan Wylie2 months ago
Last month, and in other recent months, my Amazon earnings are almost twice as much as my Ad Program earnings, yet, every month, I get notices from Hubpages saying that they removed Amazon capsules from my articles. I...
by Prayer Power5 days ago
How do I find which of my own blog posts earn the most ad revenue? I'm trying to find out the blog posts that is earning the most so that I can optimize it and boost earning potential.
by Juliette Kando4 years ago
I recently filled in a survey on how to improve HubPages but forgot to mention a very important design issue which has been bothering me for a long time.When a text capsule is very long, I like to turn it into 2...
by Gina Lou12 days ago
I just joined not long ago and while I am earning on the Ad Program, I have no earnings from Amazon. It is active so what am I doing wrong?
by Dr. John Anderson6 years ago
I think it is related to images being used for the HUB ads and Google ads. When I turned off the Hub ads my adsense revenue rose significantly. I think it is because the block of adsense ads to the right of the column...
Copyright © 2017 HubPages Inc. and respective owners.
Other product and company names shown may be trademarks of their respective owners.
HubPages® is a registered Service Mark of HubPages, Inc.
HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.