All Questions
24
questions
19
votes
8
answers
38k
views
Increase size limit of data import from csv into Excel
I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
0
votes
2
answers
6k
views
Microsoft Excel maintain formatting when importing
I am using a CSV to import data.
The column of data has different and sometimes multiple numbers in one field.
For example...
2924,2925, 2926 in one field
2927,2928, 2929 in another field.
I ...
4
votes
6
answers
4k
views
Transform Fixed Width to CSV?
I have a whole bunch of data files with different content but identical layout. I need to convert them to CSV before importing them into a CRM application.
I usually open the tab-delimited file in ...
0
votes
2
answers
2k
views
Get External Data with carriage returns
I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option.
The file has a text qualifier and is pipe delimited. Here is ...
4
votes
2
answers
3k
views
Excel 2007 save import steps on csv file?
I have a csv file that constantly needs opened into Excel and then have the data copied over to a separate workbook.
I find the process of having to click through all of the dialogs, setting the text ...
44
votes
3
answers
262k
views
How do you change default delimiter in the Text Import in Excel?
I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" ...
2
votes
1
answer
274
views
Excel Help: Data Input Help
Everyday I download data from a site that will have rows each filled with individual data for clients. I'm able to input the data into excel as a whole but after that I'm having trouble figuring out ...
17
votes
9
answers
104k
views
How do I get Excel to import a CSV file with commas in some of the content fields?
How do I get Excel to import my CSV file?
File
I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of these ...
22
votes
5
answers
32k
views
How can you make Excel 2007 stop formatting large numbers as scientific notation?
Kind of the inverse of this question.
I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...