Questions tagged [csv]

Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

Filter by
Sorted by
Tagged with
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:...
Emerson Prado's user avatar
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 ...
dwdwdan's user avatar
  • 11
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 -...
bbartling's user avatar
  • 225
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 ...
JosephDoggie's user avatar
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 ...
Tim Dunphy's user avatar
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 ...
djvol's user avatar
  • 11
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 ...
Laurent Richer's user avatar
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 ...
nico1234's user avatar
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 ...
Gareth McCaughan's user avatar
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 ...
kswenito's user avatar
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, ...
nilsinelabore's user avatar
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\"...
magoosh's user avatar
  • 23
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 ...
magoosh's user avatar
  • 23
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 "...
Eric Hofer's user avatar
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 ...
Pelso's user avatar
  • 11
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....
john c. j.'s user avatar
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 ...
Zain Raza's user avatar
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 ...
Momergil's user avatar
  • 679
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: ...
Christer Jegbert's user avatar
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 ...
latee late's user avatar
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 ...
Flowers's user avatar
  • 11
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,...
Jordan's user avatar
  • 11
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 ...
Zachary's user avatar
  • 11
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 ...
Brice Buchanan's user avatar
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 ...
Mastaxx's user avatar
  • 1,218
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 ...
Dan Bovata's user avatar
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**...
Vincent's user avatar
  • 13
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 ...
beginner's user avatar
  • 223
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. ...
kevinks's user avatar
  • 13
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 ...
John McCabe's user avatar
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 ...
Ana's user avatar
  • 21
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 ...
cmccarra's user avatar
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 ...
Oliver Williams's user avatar
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 ...
Zuntaruk's user avatar
  • 111
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 ...
demongolem's user avatar
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 ...
Alan Dazay's user avatar
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 ...
bman's user avatar
  • 163
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 -->...
KirstyK's user avatar
  • 11
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 ...
kaur's user avatar
  • 11
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 ...
Areck Degeneffe's user avatar
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. ...
anton's user avatar
  • 11
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 ...
s_a's user avatar
  • 2,099
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 ...
Deersfeet's user avatar
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 ...
Roberto's user avatar
  • 11
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.
meredith helms's user avatar
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 ...
HNSKD's user avatar
  • 111
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 ...
Toskan's user avatar
  • 347
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....
Vikram's user avatar
  • 11
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 ...
War Eagle's user avatar
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 ...
KDM's user avatar
  • 142

1
8 9
10
11 12
20