How can i export just one Excel sheet as a csv in a multi sheet workbook

[Page]

I have an Excel workbook that has multiple sheets 2010

I can save a single sheet from it as a csv in what seems quite an involved messing about way - save as - name for the sheet - choose csv - warning - save - another warning - have to select no - a new save box appears for the sheet - to save the workbook as a whole - cancel or save - select xls format - save - done

gawd what workflow

Compared with bringing data in - where I can do - get external data - from text - and all sorts of option for refresh automatically or manually exist

I feel I must be missing a trick but cannot spot it - has anyone any ideas on how to make the export of a single page as csv pretty easy and maybe even with the sort of setting that can be used with importing data

Thanks

 

[PerfectP]

Not too sure if this is the most efficient but it works:

Right click on the sheet you want to save at the bottom of the page.
Goto move or copy.
click - create a copy and goto the drop down box where it says To book: New Book.

Your sheet should be saved to a new workbook and you can then save as csv if you want to.

 

[Jeff FV]

Right click on the sheet you want to save at the bottom of the page.
Goto move or copy.
click - create a copy and goto the drop down box where it says To book: New Book.

Thanks for that - (I'm not the OP) I've been wondering how to save just 1 sheet from a whole excel workbook and you've just answered my Q!

Thanks again

Jeff

 

[Page]

Not too sure if this is the most efficient but it works:

Right click on the sheet you want to save at the bottom of the page.
Goto move or copy.
click - create a copy and goto the drop down box where it says To book: New Book.

Your sheet should be saved to a new workbook and you can then save as csv if you want to.

I had cracked that one but thanks anyway

It just seems strange that they have so much for getting data in cleanly but nothing for getting it out

Getting it in - it can go and do things like load a file every x minutes - be connected and then refresh etc

 

[Scalloway]

Make sure you have saved your spreadsheet then select Save As CSV. Excel will warn you that it will only save the active sheet - job done!

 

[KM-Tiger]

I've just tested this on Ubuntu/OpenOffice but it may work in Windows:

Select the data to export and copy.

Paste into a text editor. This will come in as tab separated data.

Do a global Find/Replace to change all tabs to commas, and save.

Might be less steps than other ways, and avoids reopening the file if you do a SaveAs.

 

[Page]

Make sure you have saved your spreadsheet then select Save As CSV. Excel will warn you that it will only save the active sheet - job done!

Yes this works but I see it as a error prone because the current workbook becomes named as savedname.csv - but all the pages are still there - but if I then close it down and reopen it only the page saved as a csv reloads

So the danger is I save it - then think ah I need to do something else on page 2 and my mind being deep into the data rather than the processes that I need to be aware of with Excel on the saving and reopening etc - or the phone goes or the door bell.

To myself it is poor work flow - hackable but not right - and I find it hard to believe that it is not a common requirement and therefore source of problems

I feel there should be an option of - save current workpage as csv - done - the workbook keeps it name the csv is saved and no extra processes to go through.

 

[Scalloway]

I don't follow your logic there. If you follow my instructions you will have both your original file savedname.xls and the CSV file savedname.csv on your system. Go to File Open to get your original file.

 

[Astaroth]

The "problem" is that Excel expects you to want/ need all the additional functionality it offers above and beyond that of a CSV file hence all the warnings etc. Guess it could be easier if it had an export option but I doubt the volume of people wanting to do it regularly is that high.