[solved] Problems reading exported csv file in Excel

Solutions for other phpList version 2 users
Forum rules
Please do not ask questions here, this is for Solutions you have discovered or come across.

[solved] Problems reading exported csv file in Excel

Postby JJRose » 3:24pm, Sun 01 Apr, 2007

When I try to export in csv format, Excel won't recognise the file format. I get the message
"SYLK: format not supported."
I have tried both '0' and '1' in the config file in the option that says,
"# if you want to use export format optimized for Excel, set this one to define("EXPORT_EXCEL",1);"
and either way, I get the same error message.
I am using Excel 2000
.

I can open the file in Notepad, but all the info is clulmped together and not nicely readable.

Any suggestions?
JJRose
phpLister
 
Posts: 13
Joined: 2:47am, Sat 31 Mar, 2007

Postby SaWey » 7:03pm, Sun 01 Apr, 2007

That's because you can't just open them,
you have to import them,
go to 'data'->'import external data' and then just open your csv file.
A wizard will then guide you through the importing.
SaWey
PL Master
 
Posts: 192
Joined: 8:28pm, Wed 08 Mar, 2006
Location: Belgium

exporting

Postby tracyselena » 12:47pm, Thu 28 Feb, 2008

Hi...I'm having this same problem. Does anyone have a solution.

The one reply that is here is referring to importing, but the original question is about exporting and that is the problem I'm having.

Thanks Tracy
tracyselena
phpLister
 
Posts: 9
Joined: 3:02pm, Fri 04 Jan, 2008

Re: exporting

Postby railroadguy » 3:56am, Sat 01 Mar, 2008

tracyselena wrote:Hi...I'm having this same problem. Does anyone have a solution.

The one reply that is here is referring to importing, but the original question is about exporting and that is the problem I'm having.

Thanks Tracy


If you first open the file in a text editor and change the first line from ID to id and then save, you can now open in Excel. Be sure to change it back again in you import back to phplist.

This problem occurs when you open a text file or CSV file and the first two characters of the file are the uppercase letters "I" and "D". For example, the text file may contain the following text:

ID, STATUS
123, open
456, closed


Note This problem does not occur if the first two letters are lowercase "i" and "d".

Here is where I found the answer and it works for me
http://support.microsoft.com/kb/323626
railroadguy
phpLister
 
Posts: 10
Joined: 3:43pm, Fri 04 Aug, 2006
Location: Dwight, IL

Postby rontom » 3:04am, Mon 15 Dec, 2008

I thought I would add what I found in case others are looking for a solution too.

I disagree about the ID having to be changed. It doesn't from what I tested.

But it does appear to be correct that you must import it to a new spreadsheet (and niot just open it in Excel)

So save the export file. Then open a new spreadsheet in Excell Then go to Data/Import external data/Import data and import the file as TAB delimited.

(this worked in 2003 but not Excel 97)

Hope that helps someone.

Cheers

Ron
rontom
PL Nut
 
Posts: 27
Joined: 10:09am, Thu 12 Feb, 2009

Postby Guest » 6:19pm, Wed 21 Jan, 2009

I agree with previous poster. I tried the Micro$oft solution of adding " before ID in wordpad, then had trouble with the list. Importing and then converting text to coloms worked fine. Thanks for the support.

Cheers, Dutch
Guest
 

Re: [solved] Problems reading exported csv file in Excel

Postby yourownfriend » 10:10pm, Wed 01 Jul, 2009

Saways response worked for me!!!
Thanks!
yourownfriend
phpLister
 
Posts: 9
Joined: 5:22am, Wed 25 Mar, 2009


Return to Answers, Howtos, Tips & Tricks

Who is online

Users browsing this forum: No registered users and 0 guests