How do you convert a table to an Excel spreadsheet?

Answer by  tvb3210 (21)

Easiest way would be to copy and paste the data from the table directly into excel, however the drawbacks are that if a lot of data is being copied the system that is doing the copying would need to be super fast. Alternatively you can use the excel import functionality to import the data directly from the table to Excel.

Answer by  stephenk2010 (293)

There are a number of ways to convert a table to Excel spreadsheet, especially if a table is created from a database application. For example, from Microsoft Access use an export command, and select a format, such as Excel. If you use Office 2007, from Access select External Data tab, and in the Export group select the icon labeled Excel.

Answer by  PowerIsMe (844)

Depending on where you have the table, it may be very easy to get that into an Excel spreadsheet... if you have it in a text file delimited by some character, head over to excel, click file>import and select your txt file.

Answer by  chirpynits (72)

Select the contents of the table which should be converted to Excel Spreadsheet. Right Click the selection. Click on "Export to Microsoft Excel". The table will be exported to Excel spreadsheet which can be used further.

Answer by  knightmare (1231)

From word, just copy the table contents and paste into Excel. From Access, export as a. csv file. From IE, try pasting table into Word then copy/pasting into Excel again.

Answer by  Isha (16)

Go to "Data" tab in menu bar and we get varisous options to import data from sources like web, text file etc. This should do the needful.