All Questions
24
questions
0
votes
1
answer
4k
views
Import multiple TXT files to one Excel csv sheet using Text Import Wizard macro?
I need to import data from approximately 30 individual TXT files into one CSV sheet. They are all formatted the same, so the Text Import Wizard should work. However, instead of running the Text Import ...
- 3
0
votes
0
answers
123
views
I have a CSV file that has 3 column. Need help to format correctly via SQL SSIS Import
I have an CSV file being dropped to a file location once a day. When SSIS picks it up it's failing due to format issue since it has 3 columns and not delimited with 1 column.
Can someone help me ...
0
votes
1
answer
401
views
Excel, importing incomplete data to a complete table?
I'm not sure if I'm asking this correctly, but here's my problem.
I'm managing the occupancy of a building, and the website we use lets us generate a report of the occupants by room. This information ...
- 1
0
votes
1
answer
76
views
Excel: how to import identically formatted CSV files
Apologies if this has been asked and answered before - I have looked but not found.
I get CSV files every two weeks that are identically structured, and I need to import them to the same Excel 2016 ...
1
vote
1
answer
1k
views
Import from tab delimited text file in Excel - CR character in quote marks is ignored
I have a large TXT file delimited with TAB.
Text is enclosed with quotation marks, but Excel still breaks the values into two rows when a CR character appears within the encapsulated string.
Is there ...
- 1,836
0
votes
1
answer
278
views
Is it possible to set Excel import preferences
I have to work with data exported from SQL Server as a CSV. The CSV file contains embedded linefeed characters, for example:
Jane Doe, 123 Main Street{LF}Apt B, Anytown, NY, 10010{CR}{LF}
When the ...
- 11
1
vote
0
answers
930
views
How can I automatically import csv files into SQL Server?
My goal
Automated aggregation of data so that I can use a tool (Microsoft Power BI or equivalent) to automatically update dashboards and or reports with the new data.
The situation
I work with an ...
- 111
2
votes
1
answer
697
views
Import CSV data with units into Excel
I've got a bunch of CSV files that contain values with trailing units. This makes Excel think it's text so I can't sum them in a pivot table.
The data looks something like this:
Date; Text; Amount;
...
- 124
1
vote
0
answers
3k
views
Excel Text Import Wizard Default Delimiter
Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma?
Don't be tempted to think that this is a duplicate question. Neither this ...
- 142
5
votes
1
answer
3k
views
Excel 2010 - Get CSV wizard to open by default
I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
- 379
2
votes
1
answer
828
views
How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac
(Using Microsoft Excel form Mac version 15.18)
Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is.
I need this so ...
- 4,140
2
votes
1
answer
17k
views
Excel How to make Text Qualifier editable or add a new entry in the existing list?
I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
"...
- 753
2
votes
1
answer
3k
views
Reversing Excel's Text Import Wizard for CSV Export
I have a CSV file that I want to import to excel, edit, and save back as CSV.
The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...
- 23
0
votes
1
answer
6k
views
Macro to Import CSV files into Excel
I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
- 61
16
votes
6
answers
46k
views
Excel CSV import treating quoted strings of numbers as numeric values, not strings
I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question:
28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE"
Since ...
- 287