Unix and Linux network configuration. Multiple network interfaces. Bridged NICs. High-availability network configurations.


Reviews of latest Unix and Linux software. Helpful tips for application support admins. Automating application support.


Disk partitioning, filesystems, directories, and files. Volume management, logical volumes, HA filesystems. Backups and disaster recovery.


Distributed server monitoring. Server performance and capacity planning. Monitoring applications, network status and user activity.

Commands & Shells

Cool Unix shell commands and options. Command-line tools and application. Things every Unix sysadmin needs to know.

Home » Data

Import CSV into Excel Spreadsheet via OLEDB

Submitted by on September 6, 2012 – 2:53 pm 4 Comments

The following is a quick how-to explaining the process of importing an external CSV file into an existing Excel spreadsheet. This approach can be very handy if your CSV data is updated regularly by some external application. Keeping the formatting in the spreadsheet and pulling fresh data from a separate CSV is the way to go. The instructions below are for Excel 2010 running on Windows 7 64-bit. Command syntax for other versions of Excel and other platforms may differ.

  1. Open an existing spreadsheet or create a new one by hitting CTRL-N.
  2. Click on the “Data” tab –> From Other Sources
  3. Click on “From Data Connection Wizard
  4. Click “Other/Advanced” –> Next
  5. Select “Microsoft Jet 4.0 OLE DB Provider” –> Next
  6. Enter the directory path to the CSV file and click on the “All” tab.
    Note: do not enter the name of the CSV file, just the directory where it is located. Do not click “Test Connection” just yet.

  7. Under the “All” tab select “Extended Properties” –> Edit Value
  8. In the “Property Value” field enter Text;HDR=Yes –> OK
  9. Click “Test Connection” –> OK
  10. At this point you should see the CSV files in the directory you specified. Select the one you want –> Next
  11. Create a name and description for your connection and click Finish.
  12. Choose the destination for your imported data –> OK

I hope this has been useful and have a blast multiplying your useless spreadsheets!

Print Friendly, PDF & Email


  • Milk84 says:

    I have created a excel spreadsheet and used the vaildation function to have a drop down list for the values that can be added in a cell. I would like a background color to be associated with it value. This would be to show severity. IE low is green, medium is yellow, high is red.
    Thanks Fat Guy. That answer worked perfect.

  • Patrick says:

    I have an Excel Spreadsheet filled with record numbers. Each Record Number is hyperlinked to an InfoPath form. Now I have a table in MS Access containing many of these Record Numbers. Is there a way to match the Access Record Number to the Excel Record Number and open the associated hyperlink?

    Thanks for your help!

  • Mistry says:

    I have a list in a column on an Excel spreadsheet and I want to print them on labels. I think it has something to do with a mail merge in a Word document, but I don’t know how!
    It’s not working! I get to the part where I select recipients from the Excel file the list is on, then I click ‘next’ and when I get to the “Arrange your labels” step, I get all messed up!
    I’m working in Microsoft Office Word 2003

  • Jonny says:

    I’m trying to get data pulled from one excel spreadsheet into another. I’m not necessarily looking for the exact details but topics and title searches I should be reading up on.

Leave a Reply

%d bloggers like this: