Closed

Excel add-in to import csv as text fields

This project was awarded to thnam for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
5
Project Description

I want to create an Excel add-in that does the following:

If the file being opened (Workbook_Open event) is .csv and column values are in quotes, then import columns as text field type.

Excel annoyingly tries to reinterpret fields and determine their type on open, which means zip code fields are interpreted as numbers and lose leading zeroes, etc. If installed, this add-in should automatically open .csv file fields as text type unless the values are not wrapped in quotes (text qualifier). The add-in should also not impede the manual data import functionality in any way (in other words -- people could still walk through the data import and select field types manually -- this add-in only impacts the default behavior for csv files).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online