+ Reply to Thread
Results 1 to 4 of 4

Extract data from unstructured excel file

  1. #1
    Registered User
    Join Date
    10-15-2004
    Location
    California, USA
    MS-Off Ver
    2016
    Posts
    42

    Extract data from unstructured excel file

    Hi all,
    I've got a really large excel file, 22mb, that has a lot of data and fields that need to be organized so I can do a join to a larger SQL TABLE.

    The excel file was converted from a pdf that was about 800 pages long. This was a report that was exported from yet another software.

    I took the pdf report and converted to excel, but there is WAY TOO MANY FIELDS and WAY TOO MUCH DATA that I need.

    So, I'm thinking the best way to approach is to run a macro to filter what I need.

    Any tips or hints is appreciated.

    Thanks,

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: Extract data from unstructured excel file

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-15-2004
    Location
    California, USA
    MS-Off Ver
    2016
    Posts
    42

    Re: Extract data from unstructured excel file

    Sorry. I've tried to upload a zip file, about 5mb. But it keeps failing. I really pared down this .xlsx file.

    Thanks.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: Extract data from unstructured excel file

    Cannot figure out where your expected data is coming from. Need a step by step explanation. Is there any rhyme or reason to the expected solution.

+ 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. Transpose Unstructured Data
    By chouz06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2021, 04:43 AM
  2. [SOLVED] Help to extract unstructured data into a table
    By josephteh in forum Excel General
    Replies: 1
    Last Post: 09-29-2020, 03:57 AM
  3. VBA to extract zip file attachments AND extract time stamp data from .msg file
    By natjo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2020, 06:59 PM
  4. [SOLVED] Convert tabular data in unstructured text file to Excel
    By tax112 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-18-2019, 02:22 AM
  5. YTD formula unstructured data with several conditions
    By Absalon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2016, 04:43 AM
  6. [SOLVED] Wanted to extract data from a file which is already an excel macro file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2013, 11:43 AM
  7. How to extract Information from an Excel File and entering those data in a text file?
    By bikash.nitk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2012, 12:13 PM

Tags for this Thread

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