If you’ve created a document in Microsoft Word that needed to reference some data, then it’s entirely possible that you have elected to present that data in a table format.īut you may have discovered that Word tables have a limited set of options for sorting data or performing mathematical operations on data, which could lead you to work with that data in Excel.įortunately, you can convert a Microsoft Word table to Excel using a copy and paste method that gets the data into a spreadsheet with just a few steps. While Microsoft Excel features a number of advanced tools and settings to work with data in spreadsheet and table formats (there are even ways to convert text to numbers in Excel), Microsoft Word has some of those options, too.
Our guide continues below with additional information on how to convert Word table to Excel data, including pictures of these steps.
Open Excel and choose where to put the table, then press Ctrl + V. 
Highlight the table, then press Ctrl + C to copy it. If that fails, try restarting your computer.4 Additional Sources How to Do a Microsoft Word to Excel Table Conversion If you are getting poor results, try closing unneeded applications. For best results in PowerPoint, first insert an Excel table as described above.Ĭopy All Open Tables (HTML) can strain system resources. The same action will work in Excel or PowerPoint. 
MS Word) and insert using the Keep Source Formatting paste option.
To copy multiple tables, collapse those that you do not want to copy, then right-click on the report sheet page and choose Copy All Open Tables (HTML). To copy a report table, (a) click on the drop-down menu button on the corresponding table node or (b) right-click inside the table, then choose Copy Table (HTML). Word and other Office Applications, Origin 2021 and Laterīeginning with Origin 2021, you can copy report tables and footnotes as HTML and insert then into Office applications. Paste the table group into another Origin window or another application. Click the drop-down menu button above any table or right-click in the table and select Copy All Open Tables. To copy multiple tables at one time and paste them into an Excel or Word document: This differs from 2021 and later versions (see below) in that embedded graphs are copied but footnotes are not (the "EMF" component allows you to insert an non-editable EMF object into an Origin graph, workbook or layout window). In Origin 2020 or 2020b, use the Copy Table(HTML,EMF) menu command to copy tables including graphs, and paste them as an HTML table into an Excel/Word page. Word and other Office Applications, Origin 2020/b For information on including footnotes, see Word and other Office Applications, Origin 2021 and Later. However, Copy Table (Text) does not support copying of footnotes that are included with some report tables. Similarly, to insert the table into Excel, simply click on a cell in the spreadsheet and press Ctrl + V. Drag handles on the inserted table to show all the results. Click into the A1 cell in the inserted Excel sheet and use Ctrl + V to paste the Origin table into it. 
Switch to PowerPoint and on the Insert tab, expand the Table menu and choose Excel Spreadsheet.To copy just the text content of a report table, (a) click on the drop-down menu button on the corresponding table node or (b) right-click inside the table, then choose Copy Table (Text) (will just be Copy Table in earlier versions).This FAQ will show you how to insert that data into Office applications. Many of Origin's Analysis and Statistics tools create output in the form of an Analysis Report Sheet. 2.73 FAQ-815 How do I copy report sheet tables and paste them into Word, Excel or PowerPoint?
0 kommentar(er)
