+ Reply to Thread
Results 1 to 2 of 2

Importing from Word Documents into Excel

Hybrid View

Greeey Importing from Word Documents... 05-31-2023, 05:57 AM
indecent43 Re: Importing from Word... 06-10-2023, 12:27 PM
  1. #1
    Registered User
    Join Date
    05-14-2021
    Location
    UK
    MS-Off Ver
    Excel for Mac 16.49
    Posts
    2

    Importing from Word Documents into Excel

    Hi,

    Incredibly rusty user here!

    I have and Excel worksheet, which for the purposes of explanation I'll simplify as follows:
    - In one column is the name of a word document
    - In another column, I want to include the entire contents of that corresponding word file (they're not massive word files)

    So as an example, the file ProductA.doc would contain the text "Giant box of cornflakes" (they might include paragraph breaks)

    Product Name File Name Description
    Product A ProductA.doc Giant box of cornflakes
    Product B ProductB.doc Tin of soup
    Product C ProductC.doc Pasta

    Any suggestions for how I'd go about this?

  2. #2
    Registered User
    Join Date
    05-24-2014
    Posts
    12

    Re: Importing from Word Documents into Excel

    for Single Cell Import
    Launch Microsoft Excel and open the Excel spreadsheet you want to import Word document data into.
    Click the Insert tab, then click the “Object” button on the Ribbon.
    Click the “Create from File” tab on the Object window and browse to the Microsoft Word document to import.
    Double-click the name of the file and click “OK” to close the Object window. You are brought back to the Excel spreadsheet with the Word document merged into it. Note the cell text box below the ribbon shows =EMBED(“Document”,””).
    Double-click anywhere within the Word document to open it, making it editable. You can perform all Word features here, even though you are still in Excel, such as changing or reformatting text.
    Click the File tab and select “Save As.” Rename the current Excel spreadsheet instead of saving over it so your nonmerged version remains accessible. Click the “Save” button.
    for Cell by Cell
    Start Microsoft Word and open the document with the table of data to import into Excel.
    Click the small hatch mark in the table's top-left corner, which highlights the table in default Word blue, then press "Ctrl-C" to copy the table. Close Word if desired.
    Open Excel. Click the cursor into the first cell in the grid and press "Ctrl-V" keys to paste in the Word table's contents. The data exports from Word into Excel, with the same cell layout. For example, if your Word data was a table of two rows with three columns, the Excel spreadsheet now shows two rows with three columns.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA - importing content of Word documents to Excel
    By J.Cz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2017, 02:42 PM
  2. [SOLVED] Importing Multiple Word Documents Into Excel
    By X82 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-26-2016, 09:45 PM
  3. VBA Transfer Data From Excel to Word and Keep Bookmarks in Word Documents
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2015, 05:37 AM
  4. [SOLVED] Importing Multiple text documents into Different Tabs in Excel
    By jzy2101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2014, 09:40 AM
  5. [SOLVED] Importing Data from Multiple Excel Documents Into a Single File (take 2)
    By YvonH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 08:02 PM
  6. Importing Data from Multiple Excel Documents Into a Single File
    By DinahMarcinko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-07-2012, 04:41 PM
  7. importing and exporting documents using word/excel
    By Denise Camara in forum Excel General
    Replies: 0
    Last Post: 07-07-2006, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1