I have a spreadsheet with 1400 lines (only 1 column) and I need to get
it into a .csv file. How can I do that?
I have a spreadsheet with 1400 lines (only 1 column) and I need to get
it into a .csv file. How can I do that?
File>Save as...>Files of type dropdown...Comma Delimited *.csv
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS
<[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> it into a .csv file. How can I do that?
>
<[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> it into a .csv file. How can I do that?
File/ Save As/ Save as Type/
select CSV
--
David Biddulph
hi,
just FILE | SAVEAS | chose CSV (DOS file)
hope this helps
regards from Brazil
Marcelo
"[email protected]" escreveu:
> I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> it into a .csv file. How can I do that?
>
>
I don't have .csv as an option!!! I have xml, html, xlt and txt but NO
CSV??
David Biddulph wrote:
> <[email protected]> wrote in message
> news:[email protected]...
> >I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> > it into a .csv file. How can I do that?
>
> File/ Save As/ Save as Type/
> select CSV
> --
> David Biddulph
I don't have .csv as an option!!! I have xml, html, xlt and txt but NO
CSV??
David Biddulph wrote:
> <[email protected]> wrote in message
> news:[email protected]...
> >I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> > it into a .csv file. How can I do that?
>
> File/ Save As/ Save as Type/
> select CSV
> --
> David Biddulph
Did you click "File|Save As Web Page" or "File|SaveAs"?
Since it's just one column, you could always just copy that column and paste it
into notepad and then save your data from notepad.
[email protected] wrote:
>
> I don't have .csv as an option!!! I have xml, html, xlt and txt but NO
> CSV??
>
> David Biddulph wrote:
> > <[email protected]> wrote in message
> > news:[email protected]...
> > >I have a spreadsheet with 1400 lines (only 1 column) and I need to get
> > > it into a .csv file. How can I do that?
> >
> > File/ Save As/ Save as Type/
> > select CSV
> > --
> > David Biddulph
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks