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
Project Budget$30 - $250 USD
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online