This is a community support forum where you can ask questions and interact with other PremiumPress Customers.
I downloaded a CSV file back in May and entered around 150 directory listings, which when imported was absolutely fine.
Now I have another few hundred listings I want to put in, i’ve downloaded another CSV to populate.
Now the CSV back in May was spanned across numerous columns and easy to populate, but the CSV i’ve just downloaded now has all column headers in cell A1, and all of the listings data just in Column A, seperated by comma’s, this is very different to the previous one I managed to download/re-import.
Whats going on and how do I get the original back?
Temporarily solved this by selecting column A and doing Data > Text to columns…
But would still like to know why it didn’t export this way in the first place when it did first time round.
What software do you use to open the csv file? As csv has no structure (it’s a list of comma separated values) so it is up to the software that opens that file to put it into columns and rows. Make sure that the file is ending in .csv as otherwise it might not be recognised correctly.
Glad you got it sorted.
@Richard – I use Excel 2003 which is what I also used first time round so not sure why it’s behaving differently.
Adrian, this is a relatively common problem and you might want to look it up in Google. Here is one possible solution: http://help.lockergnome.com/office/problem-opening-csv-file–ftopict225326.html
Thanks, checked regional settings on this PC (The one that it opened funny on) and the list separator is already set to comma, but as said before the temporary fix of text to columns worked for me.
Other option is to add an extra line to your CSV file to tell Excel what the separator is. Add the following line to the top of your CSV file:
This will tell Excel to use the “,” character as separator for the next lines. This first line is considered an instruction and not shown in your Excel sheet.