How can I import a csv file with over 256 columns into Excel?

A

aaron.overington

Hi

I have several large csv files (semi colon separated) with over 256
columns of data that I need to convert to xls files. I can manually
import 256 columns into a worksheet, then block those columns and
import the next 256 into a new worksheet, but as some of the csv files
have 750+ columns, is there a programmatical solution though that is
easier (and quicker)? I deal with these files weekly so any help
gratefully accepted!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I import a csv file to Excel that has over 256 columns? 2
CSV file conversion + True/False over multiple columns of data 1
Merging from an Excel file with graphics 1
How can I modify Excel coloumn from A to T? 6
Import more than one .csv file into the same Excel file. 1
import multiple csv files into excel 2007 1
import text file with more than 256 columns 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top