Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
992
questions
1
vote
0
answers
268
views
How to specify output file cell format when using ssconvert --merge-to to create ODS file from multiple CSVs?
I successfully converted a series of .csv files into a single .ods spreadsheet file, but I had a minor formatting problem: all cells with date contents ended up with date and time format. Command used:...
1
vote
0
answers
52
views
Awk stopping printing at "
I'm making an awk script to convert a csv of aliases into a shell script to apply them, but I'm having an issue where awk seems to be stopping at a " in the second field. The command I'm running ...
1
vote
0
answers
258
views
secure file copy (scp) back and forth from remote line to Windows
Need to learn more about scp but I was able to transfer an entire directory (registry_configs) of CSV files from a remote linux machine ([email protected]) to my Windows 10 environment with this:
scp -...
1
vote
0
answers
179
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
1
vote
0
answers
282
views
Excel intermittently opens blank excel and CSV files
I have a python script that reads info from MongoDB into a file. It can output either Excel or CSV files.
For some reason when I open the files it either opens as a blank document or showing the ...
1
vote
0
answers
527
views
Automating Excel to save file as CSV and run live updates
For starters - I am raw and have limited skills, thus the guidance here is important to me.
We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
1
vote
1
answer
665
views
Automatic folder creation using Terminal
I am trying to sort files on my NAS using the Terminal from Mac OSX.
I am planning on using the following steps:
create folder for specific year
create folder for each month
use the "Find" command to ...
1
vote
1
answer
672
views
Merge 3 .csv into one file with different number of columns
I have 3 .csv files and I want to merge them together to one .csv file which can be in R or Matlab.
The files are:
1597 obs of 167 variables;
160 obs of 167 variables;
533 obs of 146 variables
I ...
1
vote
0
answers
4k
views
Loading new data from a CSV file into an Excel table
I have an Excel spreadsheet which I made by
starting with a CSV file
converting the data into a table
adding some columns to the table in which various computations happen
saving the file as .xlsx
...
1
vote
0
answers
173
views
Excel - Manual Column(s) Beside Imported Data
In excel, how do you properly mix 'manual' data and imported data in a sheet / data range?
Requirement
For context, my particular use case is a sort of bare-bones data "triage" tool in excel.
Ideal ...
1
vote
1
answer
880
views
convert sql-excel date to recognisable format
I have a large csv file(1.1G) exported from SQL Server. I would like to do data wrangling in python, but I had a few problems doing this. The original csv file dates look like this 00:07.5, 00:08.3, ...
1
vote
2
answers
3k
views
Batch file to remove double quotes from csv
My file is tab separated file(TSV) with 5 columns
I have local drive path on my first column but each image name from path contains double quotes.
Path
C:\Users\magoo\"flower.jpg"
C:\Users\magoo\"...
1
vote
1
answer
2k
views
bat file to copy column data to another column in csv
My csv file contain 6 columns and I want to copy 6th column value inside first column path value.
Path,Firstname,Lastname,Name,Description,Images
C:\Users\magoo\abc.jpg,alex,ross,pvs,data,123.jpg
...
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 "...
1
vote
0
answers
312
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 ...
1
vote
0
answers
557
views
Fixed column width for CSV files
I use LibreOffice (6.1.6.3) Calc to work with CSV files.
Some of these files have very long text in their "cells". When I open such file in Calc, the Calc tries to make the column as wide as possible....
1
vote
1
answer
134
views
Certain Time Values in a .xlsx not Changing When I convert to a .csv
I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
1
vote
0
answers
32
views
Which tools to use to backup SQL servers to csv files and delete?
I need an app which can do the following tasks:
Log in into an SQL database (Microsoft, Oracle, etc.)
Find the oldest data in some tables (can do with query; the tables have a "datetime" field)
Save ...
1
vote
0
answers
155
views
Saving to CSV changes data from numbers to written dates
I Have an Excel file that contains data that change specific cells to a written date when saved as a CSV file....And I dont want that!
For instance "4000-03" in a cell will be "mars-00"
conditions:
...
1
vote
0
answers
81
views
JMeter Table Result Created 3 Timestamps
I am new to JMeter and Automation Test, and I have a problem in reading JMeter results in CSV. I tried running a test plan with the following Thread Group Properties:
My JMeter Thread Group
Number of ...
1
vote
0
answers
975
views
Why does a .csv file lose kilobytes when it is saved as the same file, just under a different name?
I had a .csv file called "removed.csv" whose size was 3,959kb, but when I saved it under a different name, "uncleaned_df.csv", its size suddenly became 3,784kb. I've verified that I haven't changed ...
1
vote
2
answers
3k
views
Splitting a xlsx/csv file based on column value
I'm aware this question has been asked previously, but I've had no luck with previous answers. My spreadsheet has around 30000 total lines.
My spreadsheet is formatted like this:
Name,colour,...
1
vote
1
answer
160
views
Is there an existing script to automate compiling email address from the "sent" folder of Outlook and OWA into a CSV file?
I'm an employee of a small business and we pay for a task service to manually comb through the "sent" folder of our email accounts and create a list of email addresses we have sent emails to. Though ...
1
vote
0
answers
29
views
I want to push either a TSV file or JSON up to a Google Sheet
I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows:
A: The unique key for ...
1
vote
2
answers
6k
views
How to I export filenames, filepath and properties of a directory tree to CSV?
I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
1
vote
0
answers
384
views
Issue with MS Word mail merge with footnotes
I have kind of a weird issue regarding MS Word's mail merge (MS Word 2010).
I have a simple docx document with some text and some footnotes. Now I am connecting it to a csv file for starting a mail ...
1
vote
1
answer
27
views
Excel Unable to Display or Distinguish Text Strings
I created a simple CSV file with only this exact text (quotes included):
"-2**31-1","-2**31"
How can I open this CSV file in Excel and get it to display exactly:
A B
1 -2**...
1
vote
1
answer
657
views
How to move the folders to new directory based on their match in csv file?
In my present directory I have many folders like F1, F2, F3, F4, F5, F6, F7, F8, F9, F10.
I have a csv file "dan.csv" in the present directory which has a column with folder names.
csv file looks ...
1
vote
1
answer
972
views
Excel cell value and formula bar display different data
I have a csv file which when opened gives an incomplete data as the cell value, the hour portion of timestamp is missing to be exact.
However the complete timestamp can be seen in the formula bar. ...
1
vote
1
answer
4k
views
How to remove lines from csv that match lines from another csv
So I have two csv files (list1.csv and list2.csv) They both have these columns:
FirstName LastName MiddleName City
I want to check list1.csv and see if any rows match a row from list2.csv and if ...
1
vote
1
answer
140
views
Text file to comma delimited file
I have a text file that needs to be converted to a comma delimited file. I have imported my text file into excel and then have chosen the Fixed width and according to this I have separated my columns ...
1
vote
1
answer
14k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
1
vote
1
answer
119
views
CSV stopping excel from changing column values
Here is the deal. We are approaching the limits I think of what you can do with CSV but I am wondering if anyone has a solution.
We have a CSV file that is 357MB in size. Downloads fine, and doesn't ...
1
vote
0
answers
908
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 ...
1
vote
1
answer
258
views
Column-wise operations in reCsvEditor (Column Fill)
I have a csv file which is too large to open with Excel. So I downloaded reCsvEditor which can handle my csv file which is around 2.3 million rows.
I have the need to apply a few column-wise ...
1
vote
2
answers
166
views
Trying to convert .xls into .csv that have different delimiters than excel 2010 is automatically saving it as
I'm trying to get a .csv file with this exact format http://puu.sh/ubMVZ/6d7b9968d5.png to be used in a statistical analysis in metaboanalyst (this is a list of concentrations of metabolites from ...
1
vote
0
answers
120
views
Extract PDF Data using categorized annotations
Are there any existing tools to extract data from PDF files using this method.
Lets say I have 3 categories
Image - this will be a rectangle annotation which will crop that specific area where the ...
1
vote
2
answers
246
views
CSV files downloaded from limesurvey are displaying strangely in MS Excel 2016
I administered a questionnaire using limesurvey and downloaded the responses in csv format to analyse in R. For some reason, the column names are displaying very weirdly in excel. I have tried Data -->...
1
vote
1
answer
58
views
Issue saving SQL query results in Excel
My query results look like this in SQL Server. EmpBarr has string with multiple values that must be double quoted and comma delimited.
id EmpBarr
6928108 "ELL","LII","LLL"
When I copy the ...
1
vote
1
answer
162
views
Deleting all line breaks between two matching variables in notepad++
So I am trying to ultimately make a table out of a whole bunch of text, but it's giving me a headache. Basically here is an idea of what is going on:
matchingvariablelengthupccode1 ...
1
vote
0
answers
84
views
Creating a website CSV
Im building a webshop, and asked a wholesale for a datafeed import for all my products.
They did not have it so im wondering if i could create my own.
Ive got all the information except discriptions.
...
1
vote
0
answers
83
views
Stream decompress file for reading in Windows transparently
I have a collection of compressed, very large .csv files from which I need to extract some small subset of the contents. Let's not focus on possible practical solutions, but rather on the following ...
1
vote
2
answers
4k
views
Russian UTF-8 tab delimited csv file saved from Excel 2016 is garbage in text editor
There is an option in Excel 2016 to export as a UTF-8 comma delimited CSV file. I don't want commas between fields- i want tabs.
I save the file as a tab-delimited txt file. In the Save As ...
1
vote
3
answers
4k
views
I want to create multiple csv files from the data in the main csv file
I am not an expert, so I apologize in advance for my question (which I'm certain is fairly basic for a power user). I have 350+ rows in an excel file. Instead of copying and pasting the individual ...
1
vote
1
answer
32
views
excel 2013 save files correctly in a CSV format. Numbers come up as text and produces incorrect totals
not able to completely save files correctly in a CSV format. Numbers come up as text and produces incorrect totals. We had several people on the team try and we are all having the same issue.
1
vote
1
answer
186
views
Conversion from Excel to CSV Correct Cells with Errors
I have a lot of cells which I want them to be formatted as texts. However according to Excel they are not texts and hence should be corrected to numbers instead. For example, "6814070833E000101" is a ...
1
vote
0
answers
333
views
Office Excel 2011 for Mac : when exporting an excel sheet to csv, around 25000 empty csv lines get added
so when saving as windows csv and press save i get the actual data:
1,1,2,
then i get around 25'000 lines:
,,,
,,,
,,,
,,,
,,,
,,,
....
when i do the same with libre office i get only the data, no ...
1
vote
0
answers
2k
views
How to Avoid rounding off when converting from CSV to Excel?
As far as I know (") double quotes are used in the CSV file and who opening the file in Excel it should treat that as Text and all the numbers should displayed.
My actual CSV file value is: 1,026....
1
vote
0
answers
424
views
Number formatted as text keeps reverting to scientific notation in Excel
I am creating a large file in Excel that contains two columns with large numbers. I am formatting these columns (actually the entire worksheet) as TEXT.
When I save the file as .xlsx and open it ...
1
vote
0
answers
2k
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 ...