Excel распознал как sylk файл
Trying to open CSV file that my app had generated kept causing the following message to appear in Excel:
Excel has detected that ‘balhblah.csv’ is an SYLK file, but cannot load it. Either the file has error or it is not a SYLK file format. Click OK to try to open the file in a different format’ , you may also get the message SYLK: File format is not valid
The solution:
After many hours of pulling my hair out trying to work it out I discovered that if you make the first letters “ID” of a text file Excel incorrectly assumes you are trying to open an SYLK file (whatever one of those is!).
Hope that helps!
F1 heads to SKY
Codeigniter Beginners Tutorial Article
315 Comments
Geoffrey Hashman
One can only hope and pray.
funcsol
Nenad
Kevin
Antonio
AlunR
Andrew
Abhinav
save my day..thanks
techgodress
Still helping Feb 2020
Changed the field from ID to id.
Eric Blankenstein
Thank you and bless you for sharring this info.
Wesley
> 700 days later his post is still helping. Many thanks for saving me many hours of frustration.
10/20/2016 and it is still helping.
Reuben
Deckard
24th Feb 2017, still helping
jamie-b
Still helping 24th March 2017
strumpels
Shuting
Still helping 20 Avril 2017
Still helping at 25 APR 2017… 😀
Hasan
Still helping at May 31, 2017
Still helping in 15 June 2017..yihaaa
chris
Houlie
Aaron
7th September 2017!
Martins Savickis
3017 Still helping
Daniel Beltrami
Still helping at 03 Feb 2018
Cichy
Still helping (16 March 2018) 😀
Marco
Joerg
QA Tester
Moses
Still helping in May 2018
Julia
June as well! It continues haha
Still Helping. November 27, 2018
AlunR
Zak Stephens
Still helping, November 13, 2018.
Still Helping Jan. 2019 !
23rd Oct 2017, Still helping.
Enric
Still helping, mates! thanks
Ramon
METOO! 🙂
Still helping. Thanks
Cedric
Still helping, Thanks a lot .
Still helping today July 13th 2018
Chuck
Still helping at of Aug 13 2018. Amazing that MS has gone so long without addressing a basic bug.
psdcc
Seminoleslarry
August 10/2017 and still helping!
Vijay Kumar
Still helping. 6 years later.
Dolorum
Armaan Sandhu
Haha still helping in 2018!! 🙂
Saul Weighney
Richard Graham
And now still Helping
Glad to still be of help!
Linda
saved me today (7/18/18)
Zid Zidane
Another grateful user :)
Jaspreet
Put an apostrophe at the beginning of the first field and this irritating error goes away
Another code warrior salutes you!
Tushar
Thanks ! it helped..
David
Looking at the MS knowledge base this should be fixed in the most recent versions of excel
Michael
Deckard
Creighton
Jpfischbein
MT KMan
AlunR
Not dumb at all! Lots of frameworks WANT you to name the key ID!!
khandu
i cant save excel file in .csv format error you cant save multiple sheet in format
how to save
plz reply me.
i cant save excel file in .csv format error you cant save multiple sheet in format
how to save
plz reply me.
Alun Rowe
THANK YOU , THANK YOU , THANK YOU
Dennis
Thanks!! Still useful!
Mitch
Ronnie
This helped me as well. Thank you!
Julia
Chris_M
Thank you Mitch. Life saver. And thank you Alun for starting the whole topic.
Jewfin
HELL YEAH . Thanks.
Frustrated
Helped again, thanks
Yup, still helping.
Thank you!
Andrew N
Still a big help. Keep this alive (Incase you were thinking that no one is using this anymore)
received the error message during import of a custom csv file about 3 minutes ago.
googled it and this article resolved it in less than 60 secs.
thanks.
And there was me thinking it was my programming skills that sucked. Microsoft, as usual. Pfft. Suckers.
Changing ID to lower case id should also fix the problem.
Joel Weiner
We had to change from upper to lowercase to when saving from xlsx to csv. Other wise we would get the error.
AlunR
That’s useful to know! Thanks
Brian Patterson
You are the best ! Thank you.
Thank God for Google that found this.. I was pulling my hair out on this!
Thank you. You saved me much frustration.
Abu Alam
Tatiana
Glad to still be of help
Damien
Laurence
Just another drive by thank you. This is more helpful than the offical MS help page on this topic.
Vinutha
GOD , Would have never figured out this.. wasted one whole day.
Sebastian
Thanks for saving me hours of investigating.
The Moog
I want to have your babies. I love you. Thanks
Homer
Hamish
David Willis
This is amazing. Thanks!
This is awesome help!
Steph
Piotr
thank you, thank you, thank you!
Joost Carpentier
Thank you so much. Found this and fixed the error.
Maria
WOW. Awesome! Thank you very much for this post!
Gunnar
Jen G
Wow!, thanks for your post! That helped so much!
Michael
MarkW
Jon Rachiele
Rolando
Thank you, thank you, thank you.
scaevola
Emeline
Merci . Thank you . You just saved the day !
Hui Sheng
A thankful Python newbie
Nicholas Richardson
Andy T
thank you .
thank you .
thank you .
thank you .
you are the best
worked
David
Running Excel 2016 in the year 2017 and this is still a problem that you helped me solve! Thank you!
Hamidul Islam
AlunR
1st hit on google search, still an issue after all this time?
Prashant Ganpat Dhuri
Jeff G
Thank you for sharing this. I was so confused by the error and would have spend countless hours on the same issue!
Shahabaz
From Argentina with Love
Thanks this helped me too, March 31st, 2017
Kirkwood Paul Donavin
Thank you so much for pulling your hair out for us!
Ed Flood
Still helping, thanks a million!
joshelui
I solved this issue with:
Application.DisplayAlerts = False
Workbooks.Open Filename:=path, Local:=True
Application.DisplayAlerts = True
I hope this help you.
AlunR
Thanks! VBA Solution shared!!
Iguan
Maria M.
Priceless information! This thread will live on as you keep saving lives out there in MS World. Thank you.
David
Beach
David
And again today!
Costi A
Still useful. Thanks man.
BR/ Costi A.
Jackie
OMG, thank you for saving me so much time.
Jeff Langlois
You sir, are a gentleman and a scholar.
This resolved my issue so quickly!
Anton
AlunR
Why do you need ID as the first field? If you are outputting to Excel then you can choose anything as your output format. If you need to then send it on from there it you could then rename it once it is in the system or output it using a macro which renames the first column.
Alternatively make ID the last column? most imports should sort it out for you?
Aug 14, 2017 and still helping!
Aug 29, 2017 and still helping!
Wow, years later and this is still awesome. Thanks for the heads-up!
Mousumi
Thank you so much for sharing this info.Very useful.
SRamu
Still helping. Thank you so much for this info.
James
We have discovered if CSV is changed to UTF-8, the SYLK problem disapears (without change ID to Id)
PongoDog
OMG ! How much time potentially this has saved me. THANK YOU for posting this information.
renat
Abdul Hadi N
AMAZING! Saved me 8 hours of hair pulling. Damn excel!! THANKS.
Mohamed
So my very first cell was the state Idaho, what are the odds?
Another grateful user!
And Another!
Ha Ha!! Still helping. I would never have worked that out!
Nicola
Thanks was very useful
Dan Williams
Still helping!
Cheers!
random it guy
helpful defusing a panicked exec
Amjad
Trust me still helping
Brian Spolarich
This is the gift that keeps on giving
rajen
M Miller
Such a simple solution for such an annoying issue. THANK YOU!
dylanjharris
STILL HELPING! THANKS ALL
WHY IS THIS STILL AN ISSUE AFTER 4 YEARS?!
Thank you for the quick fix!
Stephanie
STILL HELPING after SIX years. Thank you 🙂
Peter
Another two thumbs up!!
Daniela
Still Helping! Thanks!
Bobby
Still helping. Thanks!
Nicolas
Still Helping! Thanks!
Joseph
Still helping! 🙂 Thank you.
AlyShutter
Yep still helping =D 2018! Thank you!
Lieutenant Geyser
Haha this is amazing. Thank you for this.
Best post ever 😉 Saving me a bunch of time
Steve Rawlinson
Still Helping! Thank you.
Well done Alun. Magic internet
Celia
Thanks a bunch! That prevented me from suicide 🙂
Richartd Noakes
Nikhil Bhansi
24th Feb 2018 | Still Helping
Robby
Thank you very much.
Mitisha
Stuart
Still helping March 2018!
Alex Claudio
This is still helping! April 2018!
Still helping 29th March 18.
Still Helping April 18
David
Thank you very much!
mdcclxv
Thank you. U da man!
Aromal
I found another option.no need to change the column heading order title. Just open a new excel and than open the file which you would like to open (SYLK format file), it will open this time.
Hope this works for you guys as well.
José Sanches
Thank you! Still help !
Jsanches
José Sanches
Niborg
Dhawal
Gav Massingham
Keren
Thanks! Another person saved hours of trouble by this.
Stacey Britton
So glad to find this, thanks!
day 2,304 and still helping!
Jem Shaw
Aaaaaand solved!
You rock.
jamie
I literally love you
Francois Janoras
Daniel
Still Helping! Thank you
Saved the day 6 years later!
Still Helping. May 2018
Thomas
melon
thanks heaps for this.
Niharika
Thanks a ton. Saved lot of time.
Hancel
This answer will remain Gold for decades to come 😀
Thank you so much
Aparna
Thank you.
God saved the world.
You saved my day.
Larry Nee
Sulcalibur
Just had this problem, you were the first result in Google, lol. Cheers buddy!
Hanna
Kathy
Still Helping! THANKS.
Josh Stauffer
Kiya Sharma
edel macias
Thanks you for the info!
Still helping haha
Much spam, such helpful
Archana
Thanks for the info!
Still helping
Thank You. It is help us 😉 fckng excel 😉
Lara Jain
thanks a lot. It worked. in 2018 🙂
AlunR
jamie
Thanks for this so many years later!
AlunR
Just change the first line of your address and your first name to ID.
They’ll never know who you are or where you live!
Leslie
AlunR
Off the top of my head you could try opening it in a proper text editor like Sublime?
Читайте также: