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
2 answers
14k views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
Fonebone's user avatar
  • 113
1 vote
1 answer
740 views

Display-only Column Formatting in Vim for Character-Separated Value Files

I would like to be able to nondestructively align columns when I am editing csv files in vim. I know of various ways to tabularize/align columned data in vim, but they all modify the file itself ...
egan's user avatar
  • 31
1 vote
2 answers
723 views

Unix copy multiple folders based on a specified CSV list using rsync

I have done some research and it appears that rsync is the only method that can possibly help me achieve this. I want to specify a list of folders in a CSV which can tell rsync to copy them to ...
Pelly's user avatar
  • 21
1 vote
3 answers
19k views

d/m/yyyy to dd/mm/yyyy

I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy. I want to standardize all the data of such column into dd/mm/yyyy , I format the ...
kitokid's user avatar
  • 141
1 vote
2 answers
26k views

excel: merging to data sets based on a common field

I have two excel .csv files that have a single numerical field in common, FIELD_A. What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I ...
fox's user avatar
  • 807
1 vote
2 answers
3k views

windows text editor that allows csv/tsv data column sorting

I thought I remember reading that there is a text editor that exists for windows that allows the sorting of data, treating the csv/tsv similar to how it is treating when one sorts in excel. Any ...
jason m's user avatar
  • 113
1 vote
2 answers
868 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 ...
bumble_bee_tuna's user avatar
1 vote
3 answers
7k views

OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)

I am running OpenOffice 3.2 on Ubuntu. I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...
Takashi's user avatar
  • 135
1 vote
2 answers
835 views

Software to convert an EPS file to a vector format?

I've got an EPS file (provided by Ordinance Survey) which I'd like to convert into a vector file (2D points) for processing by another software application. I'm not fussed what final format it takes, ...
Rushyo's user avatar
  • 249
1 vote
4 answers
719 views

XY Diagram/Data Browser for mid-sized CSV files

I have a set of CSV files with about a 100k records in them. The records need to be visualized in an x-y diagram. Specifically, I'm looking for: Seamless zooming in and out of the data Navigation ...
Johannes Rudolph's user avatar
1 vote
1 answer
92 views

regex for searching a word in a word

i have a csv file which i need to filter mails marked with the word 'spam' lines look like this email;text;somestatus;mailserver status response; response message [email protected];mx.mail.com;2;...
John Doe's user avatar
  • 279
1 vote
1 answer
39 views

How do I use an API to extract to CSV? [closed]

Sorry, I've tried reading up on it but I just don't understand any of it. There is an organisation, ALISS.org, which has a section with their API that lets you interact with their database of local ...
Kilm's user avatar
  • 11
1 vote
1 answer
368 views

How to tell Excel to change right encoding in opened file?

Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
Čamo's user avatar
  • 345
1 vote
1 answer
696 views

Excel: How to search for values from a column within a cell that has comma seperated values

I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below. One Two AB AB, EF CD ... I'd like a formula to return True if any text ...
user1784316's user avatar
1 vote
1 answer
70 views

data recovery empty csv file created by arduino

Last week we launched a rocket, in which an Arduino saved the data of the sensor in a csv file. Every 30s the programme used myFile.close() and a new file was created. But even if the chute deployed, ...
paul's user avatar
  • 13
1 vote
2 answers
2k views

How do you open/import a CSV file with Unicode characters encoded as numeric character references?

In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example 香&#...
J K's user avatar
  • 113
1 vote
1 answer
4k views

Open UTF-8 csv files by double-clicking in Excel

I want to open UTF-8 coded csv- or text-files directly in Excel 2016 or later. Of course I am aware of the import option, but I want to do this with a simple double-click. Problem is that this way ...
Stefan Martens's user avatar
1 vote
1 answer
948 views

How to save filtered results in Procmon to a .csv file?

I have included the entire script below. It works without this added piece at line 16. If I remove the added code at line 16, the script will complete but does not save the filtered information. /...
Manning's user avatar
  • 68
1 vote
1 answer
2k views

Make a copy of an Excel file as a CSV without having Excel "re-open" the file as a CSV

I have several dozen Microsoft Excel files in xlsx format. These files are the "master" copy for editing and include various formatting to make them easier to edit. However, the data from ...
Patrick Kenny's user avatar
1 vote
1 answer
998 views

Splitting files in Mac and then adding .csv extension removed them?

I have been following the methods from this YouTube video. Method: cd /Volumes/Seagate/Work/Tickets/Thirdticket/Extinction/species_all.df split -b 10000m species_all.csv for i in *; do mv "$i&...
Stackbeans's user avatar
1 vote
1 answer
715 views

Csv file - User permission needs to be created after each save

For context, I'm uploading a csv file to a Postgres database via the psql command line. The cmd can only access the file after I add Everyone to its permissions and allow full control. The weird thing ...
half of a glazier's user avatar
1 vote
2 answers
537 views

Opening csv file with notepad with two different desktop running both windows gives different results

Opening csv file with notepad with two different desktop running both windows gives different results One of the desktop when opened, it's kind of lined nicely with newline, but somehow the other one ...
Dora's user avatar
  • 147
1 vote
1 answer
807 views

How to rearrange columns when you don't know their initial positions (UNIX, BASH)

I'm having an issue to rearrange columns of a csv file (separator ";"). I know where the columns should be, but not where they are in the first place. Example of file: first_name ; age ; ...
DuDu Advocate's user avatar
1 vote
2 answers
596 views

Does Tableau Public support live connections?

Are live connections available in Tableau Public? I have seen a "Live connection" checkbox in a few tutorials, but it is missing from Tableau Public 2020.3.1 - is it missing from the Public ...
octosquidopus's user avatar
1 vote
1 answer
1k views

Import emails from Outlook to Gmail

I have emails in my desktop Outlook and want to transfer them in Gmail (G Suite if it matters). I exported a folder in a CSV file, however, cannot find a way to import them in Gmail. The solutions I ...
Miroslav Popov's user avatar
1 vote
1 answer
8k views

How can I escape commas in a CSV file?

I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
ekolis's user avatar
  • 479
1 vote
1 answer
156 views

Merge CSV Files Error 1004

So I am trying to make a macro that will merge multiple .csv files into one excel worksheet. I used the following tutorial for it: vba code However, once I put in the correct path to the .csv files, I ...
TomBird's user avatar
  • 174
1 vote
1 answer
3k views

How to retain date format from raw csv file as is when opened via MS-office Excel?

I have data given to us via email/hard drive which has randomized future dates (ex: 21/02/2200) in multiple formats. During data transfer 1st mail, the file sent has date format in DD/MM/YYYY. ...
The Great's user avatar
  • 139
1 vote
1 answer
464 views

Excel and Google Sheets calculate different .csv column totals to MySQL and LibreOffice

I have a .csv file with 9273 rows. I have one column of whole numbers and one column of decimal numbers with values like 0.0001752. I totalled these columns using Excel's sum function and got totals ...
Moggz's user avatar
  • 21
1 vote
1 answer
67 views

Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?

Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell: ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
Questioner's user avatar
1 vote
1 answer
2k views

Return a row if a column has a partial or perfect match with CSV in Powershell

Basically, I want to search for a string and return any full or partial matches in a CSV format. Let's say I have an object $Shoes that looks like: "Brand","Style","Color","Price" "Reebok","...
knorberg's user avatar
  • 121
1 vote
3 answers
344 views

How to make in CSV First and Last name in one

I have one CSV that looks like this: Versand Vorname;Versand-Nachname;Versand-Zusatz;Versand-Firma;Versand Thomas ;Lellig ; ; ;Brunnenstrasse I want to ...
Drago's user avatar
  • 21
1 vote
1 answer
359 views

Excel is adding = in front of cells containing @ mark when importing from CSV

I'm not sure why, but since a few days ago when I import a .csv it is adding a "=" infront of cells which begin with an @. It should be like this: But now it is doing this: I've compared all ...
Ed Briscoe's user avatar
1 vote
1 answer
571 views

Windows CMD sort retaining header?

Need to sort in Windows a large CSV-like file with a header row (~7 million rows). Can successfully do this with a CMD command sort, but it includes the header row in the sort. I would like to keep it ...
Kjell Rilbe's user avatar
1 vote
1 answer
254 views

Replacing Date Format in multiple Columns

I am trying to edit a CSV file in Notepad++. I have about 500 lines of dates in a format that I need to change to a different format, so basically, in the CSV file in Notepad, the dates are shown as ...
Ted Walsh's user avatar
1 vote
3 answers
3k views

Display multiple CSV columns that have space on one line

I have a CSV file with first and last names. The headers are "First Name" and "Last Name". I can get it to display, but it puts the first and last name on separate lines. Question: How can I get the ...
Jeremy's user avatar
  • 41
1 vote
1 answer
325 views

FFMPEG Split Mp3 using CSV in Shell, parsing doesn't seem to work

Task: Split one mp3-files to several mp3-files, use a CSV-File with Starttime, Endtime, and Title. Errors: Skipped Parts, some parts with wrong naming, randomly accruing errors: Invalid duration ...
Chris F's user avatar
  • 23
1 vote
1 answer
523 views

OpenOffice Calc import special characters in CSV incorrrectly?

I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly. For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...
rbhat's user avatar
  • 521
1 vote
3 answers
4k views

How can I convert multiple XML files in CSV automatically [closed]

I have about one hundred of XML file (with the same structure) and I want to import them in SAS. Unfortunately in doing that I have some issues relatated to the MAP file of the XML files (I have not ...
Giacomo Rosaspina's user avatar
1 vote
1 answer
4k views

Excel removes blank lines when saving in csv format

I have an Excel file with blank lines at the start. When I save as a CSV file from within Excel, the blank lines are being removed from the saved CSV file, but the Excel view of the file, i.e. ...
DeeBee's user avatar
  • 11
1 vote
2 answers
3k views

How to join/merge 2 worksheet tables from time-series in Excel?

How do you join two datasets in excel from time-series, but the observations have been made at different times. How would you combine the observations in one table with the second? Example: table 1: ...
slimmey's user avatar
  • 11
1 vote
2 answers
1k views

How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?

I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C. Is there a ...
Mastaxx's user avatar
  • 1,218
1 vote
2 answers
3k views

Trying to export single column's data from large CSV file

Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...
OtterJesus's user avatar
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 ...
AcePL's user avatar
  • 1,806
1 vote
1 answer
497 views

.csv file from Excel vs .csv file from Libre Office

I created a simple .csv file with Excel which looks like this: I also created the same .csv file by using Libre Office. Both .csv files are looking absolutely the same at TextEdit: id, questions 1,...
Outcast's user avatar
  • 131
1 vote
1 answer
2k views

Find a string at the beginning of all lines in a file and save to another file

I have tried quite a few options with no luck for this task. I would really like to do this as batch file but my attempts fail to get the desired result. I have tried a lot of different commands with ...
JAH's user avatar
  • 23
1 vote
2 answers
2k views

Read CSV for variable and check the cells on that line for another variable

I am trying to create a batch file to read a CSV file to find a username that will be a variable then check the next 10 cells on that line if they match another variable which will be a number. ...
JimBean2208's user avatar
1 vote
1 answer
238 views

Parsing errors due to special characters in dns txt records

I have trouble parsing dns txt records retrieved by a script I wrote. The script takes a records, ns records and txt records and writes them to a .csv file. I am using semicolon to separate entries ...
Katja Eichelberger's user avatar
1 vote
1 answer
152 views

Excel- combining multiple CSVs into one

Excel 2016 on Windows 10: I have 120 CSV documents each containing 10 columns of text data (A-J). None of the CSVs have any column headings- Row 1 contains the first row of data rather than headings. ...
Theo F's user avatar
  • 131
1 vote
3 answers
2k views

Where does the @{ } come from in this foreach loop?

I'm building a script to take a IP addresses from a CSV and then attempt to ping/connect to them. Eventually I will run some commands against them and output all of it as extra data in the CSV. ...
YetAnotherRandomUser's user avatar

1
6 7
8
9 10
20