All Questions
43 questions
0
votes
0
answers
67
views
Adobe form import
I am trying to import data from a tsv into my Adobe form. I am having trouble importing my "Representative" field. Any ideas?
Below is a link to the examples of the files I am working with.
...
- 1
0
votes
1
answer
5k
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
1
answer
794
views
Can't import CSV contacts to Google
I have a csv list I would like to import to google. I downloaded the basic sample from google here it goes:
cat contacts.csv
Name,Given Name,Additional Name,Family Name,Yomi Name,Given Name Yomi,...
- 390
0
votes
1
answer
1k
views
Importing big bunch of files to LibreOffice Base table in one shot
I have table like this:
and a bunch of CSV files like this:
in per-patient directories.
Please note that I need to take a Patient field from path name and Date from file name (as you see).
What is ...
- 350
0
votes
1
answer
205
views
Excel Tables: Imported data from CSV files in a folder are not calculated
I have a source folder with CSV files in an identical format and data structure. The files contain monthly data from our internal system with columns named "service name", "date from", "date to", "...
- 162
1
vote
0
answers
24
views
Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS
In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...
- 11
1
vote
0
answers
332
views
phpMyAdmin import csv into database error
I'm trying to import a csv file into a database without having defined a table in it but I got an error. I did it one week earlier but now I am not able to import the same csv file.
When I import ...
- 11
0
votes
0
answers
129
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
407
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
79
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,849
2
votes
1
answer
7k
views
Anki import from CSV is not working
I'm trying to import cards into my Anki deck from a CSV text file. I've tried importing it as a CSV, TSV, and TXT file, and each time I've had the same message, "Unknown file format". The text file is ...
- 654
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
941
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
738
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
votes
1
answer
69
views
Using Chrome Tools to inject CSV information into sporcle quiz
I've just started a project where I plan to scrape information from wikipedia articles and put it into a quiz on Sporcle. I've scraped my information and have it in CSV format, but I'm struggling to ...
Jack H
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
855
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,210
1
vote
2
answers
3k
views
Import from csv to Libreoffice Calc using 'two blank spaces' as delimiter
I want to import some data from a csv/text file to Calc.
In the first column I'd like to have the 'Dummy text # i', and in the second column the numerical value.
In the text file, 'Dummy text # i' ...
- 140
1
vote
1
answer
2k
views
Preserve existing tags in Anki CSV import/batch-add tags
I have downloaded the complete 2012 HSK vocabulary from here, where it is available as an excel file. I have then converted it to .CSV and changed it to this form:
爱;HSK:1
…
做主;HSK:6
The first field ...
- 399
0
votes
1
answer
3k
views
Anki fails to import from .csv file
I have created an custom note type containing 3 fields: Character, Pinyin and Definition.
I have a .csv file containing a few entries. The fields are comma-delimited.
Here's what I am presented when ...
- 313
0
votes
1
answer
2k
views
Comma delimited import issues in SQL Server
I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
1
vote
1
answer
408
views
phpmyadmin CSV files import and export
When I try to import CSV files in phpmyadmin, I get message in green that says "0 rows" but it is nevertheless a success message. I know my data is correct, as it importing fine on another computer.
...
- 165
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"
"...
- 763
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
17
votes
6
answers
47k
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 ...
- 297
3
votes
2
answers
4k
views
Import-CSV with powershell using a variable path
I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work.
$path = "C:\Users\Admin\Desktop\TestFolder\file.txt"
Import-CSV -...
- 85
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 ...
- 528
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 ...
- 1
6
votes
2
answers
118
views
Importing first line of TXT files to a spreadsheet
I have 2000 txt files that I need to read the first line of (it should contain a person's name).
Ideally I would have a spreadsheet/csv with
FILENAME, FIRST LINE OF FILE
- 71
1
vote
2
answers
899
views
User Friendly CSV to MSSQL import with column match
Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
- 307
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 ...
- 449
0
votes
1
answer
761
views
Example users list for import into Windows Server 2008
I am in the process of learning a Microsoft course AD DS for Windows Server 2008.
To practice, I need at least 1000 users to import into my server, so I wonder if there is an example .csv list to ...
- 326
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 ...
Jeremy
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 ...
- 1,183
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" ...
- 825
2
votes
1
answer
275
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 ...
- 256
6
votes
2
answers
8k
views
Set CSV import default to UTF-8 in Calc
Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences.
The current default character set is "Eastern Europe (ISO-8859-2)".
I would ...
- 191
1
vote
3
answers
14k
views
Transferring contacts from an old phone to the iPhone
Getting contacts off your old mobile phone and onto the iPhone may or may not be a straightforward process. If you already have your contacts stored neatly in Outlook (Windows), Address Book (Mac) or ...
- 1,936
17
votes
9
answers
105k
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 ...
- 475
22
votes
5
answers
33k
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 ...
- 3,487