Tag Archives: import csv

Dealing with dates 3: opening and saving csv files without data corruption

This post makes use of a spreadsheet for reading data from text files, including comma separated value (csv) files.  The latest version includes a routine for saving the imported data in csv format.  It can be downloaded (including full open-source … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , | 4 Comments

Daily Download 32: Text functions

Today’s daily download covers functions to import data from text files into Excel quickly and efficiently, a function to combine text strings, with improved functionality over the built-in Concatenate function, and functions to extract numbers from the beginning or end … Continue reading

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

Automatic download of csv files

I was recently asked if I could assist with preparing a spreadsheet to automatically download .csv files from an internet location, with the filename incorporating the date of issue.  The process turned out to be quite straightforward, and works well … Continue reading

Posted in Excel, VBA | Tagged , , , | 21 Comments